@MitJamieB Advanced Searches using queries are supported in IFS Cloud.

Please refer to the following:

Required to use oData operators and functions

https://docs.ifs.com/techdocs/23r2/060_development/022_user_interface/030_aurena_dev/099_concepts/search_concepts/#filter_operators_and_functions

Query is not identical to App10 SQL where expression though.

Hope this helps !

Hello Buddhika

Can you give me an example how the get command should look like, I want to search in the sales part for part numbers that have one special Prime_Commodity in the inventory part, the Odata command looks like this, but how to enter it in the advanced search?

https://ifspsc2-d01.demo.ifs.cloud/main/ifsapplications/projection/v1/InventoryPartHandling.svc/InventoryPartSet(PartNo='10010-66A',Contract='100')/PrimeCommodityRef

@FRSMDE I dont think this would be possible without a defined relationship or reference.

Similar thinking to why it is not possible to “Join” Odata queries (in a url)

If you used a reference, then it would work like normal and then @Buddhika Kurera link would be the way to go

If you were to go the relationship route, I think the structure and Search Context would need to be altered

@MitJamieB Advanced Searches using queries are supported in IFS Cloud.

Please refer to the following:

Required to use oData operators and functions

https://docs.ifs.com/techdocs/23r2/060_development/022_user_interface/030_aurena_dev/099_concepts/search_concepts/#filter_operators_and_functions

Query is not identical to App10 SQL where expression though.

Hope this helps !

Could You @Buddhika Kurera provide some examples of the “Advanced Query” syntax? I would like to get a advanced query that retrieve for example Customer Orders where the search criteria is in some other entity - Like Customer country.

IFS technical documentation says only the below which doesn’t help much.