Advance queries support

Product
1

Is there ability to query assets on any field (across type_fields) with multiple conditions.
For e.g.

  1. query="(asset_tag:121021 or serial_number_18000431187:121021)"
  2. query="(name like IT_Laptop)"

Where can I find the documentation for query operators?

3

@rightstar,

Service Desk API for Developers | Freshservice This API is used to filter assets based on the queries

I hope it helps :slight_smile:

Thanks
Santhosh

2 Likes
4

Hi Santosh, thanks for your response. This link doesn’t cover all my questions. It states that it only allows filtering on supported asset fields and not the type_fields. Also, it doesn’t document the syntax for other conditions (sql e.g. like, in, not like, not in…).

5

@rightstar,
As per the document, it is not possible to filter based on type_fields.
And there are no conditions supported like, in, not like, not in
only these conditions are supported

  1. Logical operators AND, OR along with parentheses () can be used to group conditions.
  2. Relational operators greater than or equal to :> and less than or equal to :< can be used along with date fields and numeric fields.

I hope it helps :slight_smile:

6

This topic was automatically closed after 14 days. New replies are no longer allowed.