Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have the following table:
Phone1 | Phone2 | Call direction | date | time |
123 | 789 | OUT | 01/01/2012 | 10:00 |
123 | 456 | OUT | 01/01/2012 | 10:05 |
123 | 456 | OUT | 01/01/2012 | 10:45 |
123 | 456 | IN | 01/01/2012 | 10:30 |
123 | 456 | IN | 01/01/2012 | 10:50 |
123 | 789 | IN | 01/01/2012 | 10:22 |
123 | 789 | IN | 01/01/2012 | 10:55 |
123 | 456 | OUT | 01/01/2012 | 11:30 |
123 | 789 | OUT | 01/01/2012 | 11:00 |
and I have also a dynamic variable:
I need to create a report that shows all the call that took place within 20 minutes (or any other value from the slyder) between any couple Phone1-Phone2.
For example in this case and a 20 minute interval it will show:
Phone1 | Phone2 | Call direction | date | time |
123 | 456 | IN | 01/01/2012 | 10:30 |
123 | 456 | OUT | 01/01/2012 | 10:45 |
123 | 456 | IN | 01/01/2012 | 10:50 |
is it possible?
tnx
anyone??