Timeline for Joining 3 Tables with Left Join
Current License: CC BY-SA 4.0
9 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Oct 26, 2018 at 7:48 | answer | added | Randi Vertongen | timeline score: 0 | |
| Oct 25, 2018 at 13:35 | answer | added | Jonathan Fite | timeline score: 1 | |
| Oct 25, 2018 at 9:42 | comment | added | psyborg.eth | Yes, It's on an hourly basis. I have to generate a report for a particular time range on daily basis. | |
| Oct 25, 2018 at 9:34 | comment | added | Biju jose | so your analysis is hourly right | |
| Oct 25, 2018 at 9:30 | comment | added | psyborg.eth | If there exists a row entry in ping table than a device will be active. For eg. If there is a row entry in ping table corresponding to AreaID on 10:39 PM . Device will be treated active from 10PM to 11PM and vice versa . If the device was active for all the hours in the time range than the device will be treated active for the day . Otherwise I have to show the time range when it was inactive | |
| Oct 25, 2018 at 9:19 | comment | added | Biju jose | what are the criteria for a device to be active and vice versa? | |
| Oct 25, 2018 at 8:58 | history | edited | psyborg.eth | CC BY-SA 4.0 |
Corrected a typo and Explained in a better way
|
| Oct 25, 2018 at 8:44 | history | edited | user1822 | CC BY-SA 4.0 |
added 46 characters in body; edited tags
|
| Oct 25, 2018 at 8:34 | history | asked | psyborg.eth | CC BY-SA 4.0 |