Hi Johannes, we don’t have the possibility to use SQL statements in IFS cloud excel add-in. We can search by the text on each column. 

Hello Nirogini,

thank you yor your response. Is there a possibility to “connect” search requests?

Like PART_NO: part_no_A;part_no_B (2 different part numbers)

Or Like PART_NO: part_%_A (any part no starting with “part”, ending with “A”)

Best regards,

Johannes

Hello Johannes,

I have used Fiddler to inspect the https GET request.

The filter looks like:
&$filter=((startswith(tolower(PartNo),%27PartNoSearchEntry%27)))

in case of more columns:
$filter=(((startswith(tolower(PartNo),%27PartNoSearchEntry%27)))%20and%20(startswith(tolower(SerialNo),%27SerialNoSearchEntry%27))) 

Based on this information, the SearchEntry must start with exactly what you want to search for, ignoring upper and lower case letters.

BR Holger

Hi Johannes, you can search on the PART_NO field with ‘part’ that will result the parts starts with ‘part’ exactly same as LIKE in SQL 

Hello Holger,

many thanks for your answer. That helps a lot to understand the search functionality.

Best regards,

Johannes