Hello
Following the Knowledge Session on queries on 10/12/25, I've successfully created a number of queries but have run into an issue:
We use the "Organizational unit" object type for both our internal Organisation units as well as Third party organisations, using a different symbol for each. In my query results spreadsheet I want to have one column which shows our internal Organisation units and another which shows the Third party organisations for the given process.
I have been able to create an Organizational unit column which shows EITHER one or the other by applying a condition to the Organizational unit in the query builder window. However, I can't work out how to add a second Organizational Unit to the results to apply the second condition - if I select Organizational unit again in the query panel it removes it from the query and the spreadsheet rather than adding it again.
I am able to add the same Organizational unit twice to the spreadsheet template but there doesn't seem to be a way to filter by the symbol type here.
If it's not possible to do this it would be useful to add an attribute column to indicate the object symbol, but I can't seem to find the right attribute to show this.
Is there a way to do either of these?
Many thanks
Florian Gerdes on
Hello Jude.
I haven't tested it for your special case, but my solution idea would be to create 2 individual queries ("sub-queries") and one "master-query". Those are just normal queries, I just named them "sub-queries" and "master-queries" to point out the relation.
Now you should be able to create a third query in which you add both queries via "add query".
Then your master query should contain twice the organisational unit and you can filter, like you want.
Kind regards,
Florian