I'd like to accomplish the following: Show all records in a datagrid that are created x time ago (this is easily done by an XPath constraint, when x is a static value, e.g.: createdDate < '[%CurrentDateTime%] - 5 * [%DayLength%]', but...). I'd like x to be configurable by a system admin (this is the tricky part, because it is impossible to use constants in XPath constraints). How do I solve this?
asked
Tijl Oomens
3 answers
1
You could have the grid filled by a microflow and make the microflow retrieve items with an xpath query based on some configuration object that you can set as system admin.
answered
Sebastiaan van den Broek
0
Use three search fields where you show the created date. One normal one and two using the smaller then and greater then functionality. This way the user can drill down all the objects within a time frame.
Regards,
Ronald
answered
Ronald Catersels
0
If not already present, create an entity as a specialization of the system.user entity.
Create attributes for the criteria that you wish to filter on.
Fill the attributes at wish, for example using a microflow.
In the datagrid filter the data for the logged in user, using the new attributes.