Hello,
I'm having difficulty trying to get the last date of an activity compared to a date in a other table.
I have the following tables:
System
System | Test | Timestamp |
---|
Test_system_A | Test_cycle_1 | 2018-01-01 12:08:09 |
Test_system_A | Test_cycle_4 | 2018-01-03 11:08:49 |
Test_system_B | Test_cycle_3 | 2018-01-02 16:16:09 |
Test_system_A | Test_cycle_2 | 2018-01-05 08:08:19 |
Test_system_A | Test_cycle_9 | 2018-01-06 20:18:09 |
Config
System | Configuration | Timestamp |
---|
Test_system_A | config1a | 2018-01-01 08:08:09 |
Test_system_A | config1b | 2018-01-05 20:08:09 |
Test_system_B | config1a | 2018-01-01 10:08:09 |
The report should show the number of test cycles have been performed on which system and configuration and when the last test cycle has been performed.
The outcome should look like this:
System | Configuration | Nbr of test cycles | Last test cycle performed |
---|
Test_system_A | config1a | 3 | 2018-01-05 08:08:19 |
Test_system_A | config1b | 1 | 2018-01-06 20:18:09 |
Test_system_B | config1a | 1 | 2018-01-02 16:16:09 |
Is there a sollution for this situation?