How do I build a custom query based on a runtime property?
I have to find the list of objects not exported to any other sites. I know there is this runtime property 'export_sites'. But I couldnot find the attribute in Query builder.
Can someone help me.
Solved! Go to Solution.
Good afternoon! You can not use runtime properties for a query. Use another type of query, the exported objects have ImanExportRecord. Here is the solution I used once with gtac, which should help you:
If you are referring to the run-time property "Exported To", there is no
It can be added a query clause to the Item Query using Referenced By.
This query clause will enable the user to find items that are exported to a
specific site (search criteria).
In Query Builder,
(1) Pick Item as search class.
(2) In Attribute Selection Panel, double-click "Referenced by"
node (located at the bottom of the tree).
Class Attribute Selection Dialog should popup.
In this dialog, select ImanExportRecord as the SearchClass.
Then, select ixr_exported_object as the target attr ..
"Reference by" node should be changed into "ixr_exported_object
(3) Expand the node: "ixr_exported_object [ImanExportRecord]"
(4) Under the above node, expand the node: "ixr_target_site"
(5) Under the node:: "ixr_target_site", double-click the node:
"name" or "id"
Target name or target id should be added to the Search Criteria
Thanks for your quick reply.
I added the clause as per your suggestions, but I'm facing an error when executing the query.
"An invalid query identifier given to the enquiry"
I've added the screenshots of the error. Could you let me know how I can resolve this.
Note : I've given the search criteria as 'IS_NULL' since I want to get the list of items not exported.