Hello collegues,
I need your help.
I'm trying to calculate the time enlapsed between login and logout of each user in specifc function of my application.
I don't have rights on the database to create procedures and triggers...
Can you help me to create a query?
Example:
| ID | User | Function | Date | Time | Task |
1 | User1 | X | 2016-09-02 | 06:08:00 | Login |
| 2 | User2 | Z | 2016-09-02 | 06:08:32 | Login |
| 3 | User1 | X | 2016-09-02 | 06:09:00 | Logout |
| 4 | User2 | Z | 2016-09-02 | 06:09:32 | Logout |
| 5 | User1 | X | 2016-09-02 | 06:09:38 | Login |
| 6 | User1 | X | 2016-09-02 | 06:10:38 | Logout |
| 7 | User2 | A | 2016-09-03 | 06:10:35 | Login |
| 8 | User2 | A | 2016-09-03 | 06:11:36 | Logout |
The desired result:
| User | Function | Date | Time enlapsed |
| User1 | X | 2016-09-02 | 00:02:00 |
| User2 | Z | 2016-09-02 | 00:01:00 |
| User2 | A | 2016-09-03 | 00:01:01 |
Thanks in advance!!
Best Regardss