Help with search syntax : OR
Answered
Posted Jan 30, 2024
Hi,
I am trying to do an OR search in zendesk and cannot seem to get full list of tickets.
I need to search for a numerical value that may or may not have a letter attached to it.
Can someone help with the syntax to get a complete list of tickets containing this information?
Example : search for tickets containing 123456 OR C123456.
1
3
3 comments
Official
David
For Combining Different Fields with OR Logic:
- When you tried (query=organization_id:17641448189073 OR type:ticket), and it didn't return the expected results, it's likely because of how Zendesk interprets OR between different field types.
Correct Syntax and Approach:
- For Numerical Value OR Prefixed: Use 123456 OR "C123456" directly in the search bar in the Support interface. Ensure there's no space before or after OR to avoid confusion. Based on your reply, that space may be the issue here.
- For Different Fields (e.g., organization_id OR type): Ensure you're using the correct field names and that the syntax follows Zendesk's guidelines. If direct OR queries aren't working, consider:
Breaking down your search into two parts and manually combining the results.
0
Brett Bowser
Let me know if that doesn't get you what you're looking for. Cheers!
0
Abenandh Varmman
Brett Bowser :
This OR search was not working when I use the two different fields in the query param.
example: (query=organization_id:17641448189073 OR type:ticket). In this case it shows like no result found. But if i try like (query=organization_id:17641448189073 type:ticket). It internally uses the "AND" search and I'm getting results for this exact match.
Could you Please check with the developers? For the correct match.
0