I have a project using mongodb as database. and there are 3 collections mainly in the db, stations, inverters, inverter_logs. there is relationship between inverter to station, inverter_log to inverter.
the schema of each inverter_log document is something like the following link
[url removed, login to view]
what i need is, i need to query for history data (station or inverter), (aggregation or whatever workable solution)
1. station history use the given parameters (station objectid, date from, date to, interval), if interval is day, then the result should be sum of the each inverter_log of related inverter of each day from dateFrom to dateTo. and if the interval is month, should be the last inverter_log of each inverter of the station, and sum of them.
2. inverter history is obvious easier, it working now. but i wanna make the interval as above.
feel free to contact me, pay immediately if the result of query working fine.
you can take a glance of current db by uri: ds019628.mlab.com, port: 19628, username: test, password: test
7 фрилансеров(-а) в среднем готовы выполнить эту работу за $44
Hi. The project is very interesting for me. Looking forward for the details of your requirements. I have strong knowledge both in development and administration on MongoDB system.