Let’s use this example,
I want to search everything that ends with “AM”. But if I search “AM” nothing shows up. I tried doing * AM , $ AM and @ AM, but no known wildcards seem to work. Thoughts?
I’d rather not export the excel sheet to search, but yes I know that’s a painful option.
No, I think wildcards don’t exist for Orchestrator queue searching. The search field doesn’t support suffix matching or wildcard operators like *, $, or @.
Your options:
1. Search for “| AM” (including the pipe separator) - this might work since it appears in your reference format.
2. Use Get Queue Items activity in a workflow and filter with LINQ:
queueItems.Where(Function(qi) qi.Reference.EndsWith(“AM”)).ToList()
Apparently the queue search function is a StartsWith, not a Contains (not sure why this is the case..), so not possible to search unfor.
Yes, The Orch queue search uses StartsWith only, not Contains. That’s why searching for “AM” returns nothing
it’s looking for references that start with “AM”, not end with it.
Since you need items ending with “AM”, you can’t do it directly in the UI. Use Get Queue Items activity in Studio and filter with LINQ
yes its a startswith by default..if you inspect you would see the call
only ways you are left with is export and filter or use api call..I know its not the correct way
cheers
Use Get Queue Items in studio and filter with LINQ
queueItems.Where(Function(q) q.Reference.EndsWith(“AM”))
Or query via Orchestrator API and filter programmatically.
UI-Based suffix search is not possible by design.
The Ui searches the queue using filter contains
It looks for Queue Name and the description as well.
((contains(QueueDefinitionName,%27am%27))%20or%20(contains(QueueDefinitionDescription,%27am%27)))
As you really can’t control the filter over Ui, you can use API to query API endpoint /odata/QueueDefinitions to get Queues with name ending with.
Use filter like this - (endswith(Name,%27am%27))