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.
You need to have access to report Studio.
So a profile of Hopex Customizer, with a token MTS2 (I am not sure if other tokens give you access to this too)
In the menu Report studio, you can easily create queries implemented through macros, and write the macro itself.
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.