I want to get the list of Clients created in last hour, can I pass the qualifier with MS SQL ADDDATE() function?
If not how to do it?
I would say that most likely not possible, but let me check with engineering.
This will require access to SQL directly. You can use a query similar to this:
select * from client where creation_date > DATEADD(hour, -1, GETDATE())