5 Replies Latest reply: Sep 5, 2017 4:01 AM by Anand Chouhan RSS

    need to get the count of records based on sysdate-lastactivitydate>4 hours

    Sasikiran V

      Hi All,

       

      i have records in my qvd as follows

       

      id                     activitydate

      ---                   -----------------

      1                    12-jun-2016 14:20:30

      2                    05-sep-2017 10:00:03

      3                    05-sep-2017 11:00:03

      4                    04-sep-2017 10:00:03

      5                    03-sep-2017 10:00:03

      6                    03-sep-2017 10:00:03

      7                    02-sep-2017 10:00:03

       

      Now i need meassure which gives the count of records based on condition (sysdate-activitydate> 4 hours).

       

      i tried to create like this but didn't work..

      count({<[interval(activitydate-now(),'HH')={'>4'}]>}  id).

      please help any one on this scenario