I am trying to get a list of elements created on a particular day by using the 'Created' date in general properties. Is this possible with GQI ?
Pieter Van Compernolle [SLC] [DevOps Enabler] Answered question 23rd December 2021
Wale,
It seems not possible to do this for all elements in the system using GQI. Using the Get Parameter By ID gives you access to the Created Property but only for a single element.
However, you could leverage the pivot table and a parameter feed to achieve what you are looking for.
- Create a parameter feed and pass all the elements in your system by dragging the entire element list into the feed
- Pass the Property Name and Value parameters from any connector into the parameter feed
- Pass the parameters from the feed into the pivot table component and make the necessary selections for "Created"
- Export the content from the pivot table into a CSV file and sort by the Created date accordingly
I hope it helps.
Wale Oguntoyinbo [SLC] [DevOps Enabler] Selected answer as best 23rd December 2021
Rene, Thanks! for a very detailed answer.