I am trying to write some queries that return objects modified or created in specific time frames. For example:
Right now, I only know how to query for objects created/modified today using the "&CurrentDate" parameter.
For example, here is a query that returns all diagrams modified today
Select Diagram WHERE [Modification Date] >= "&CurrentDate"
Now, what I would like is to have a query that returns diagrams modified in "past 7 days" or "past 14" days etc..
Is there any special keywords for this in HOPEX, or are any calculations allowed and if so - how?
Solved! Go to Solution.
@PBessodes Thank you!! this works now. I can now enter a date as query parameter.
This query works...as soon as you have activated the "Display repository administration properties..." option :
A quick followup @PBessodes @CLAVALLEE
Do you know if we can use Date as a Request Parameter.
I envision something like this
SELECT Application WHERE [Modification Date] >= &"Date"
@PBessodes @CLAVALLEE Thank you both!
Good to know that macros is the way to go about this.
ERQL doesn't offer this kind of capability today. You can only use system variable : &CurrentDate
But you can implement a query by a macro.
As far as I know, you would have to create query with a macro implementation.
For example, for the implementation :
Sub FillSelectionCollection(mgobjObject as MegaObject, vntSelectorID as Variant, mgcolCollection as MegaCollection)
Dim mgRoot, col
mgRoot = mgobjObject.getroot
col = mgRoot.getSelection("Select [Diagram] where [Modification Date] > '" & CDate(Now-7) & "'")
Hope this can help.
@PBessodes Are you able to offer any help on this question?
I am writing some queries - and would really like to be able to have a way to return results "from last week" or "last month" or something like that.
WARNING We have changed our authentication method to support single sign-on (SSO).
To learn how SSO will affect your access to the MEGA Community, please read the FAQ here