Skip to main content
Question

API Call within Advanced Search IFS Cloud

  • January 19, 2024
  • 5 replies
  • 446 views

COVJAMIEB
Hero (Partner)
Forum|alt.badge.img+11

Apologies if this has been asked.

I am looking to created an advanced search within the Inventory Part in Stock screen within IFS Cloud. I want to be able to retrieve a list of stock records which are classified as Manufactured Parts.

Within EE you could add in API calls to advanced searches,

inventory_part_api.get_type_code(contract,part_no) = ‘Manufactured’

Does anyone know the options for this rather than added a custom attribute within this screen?

 

Thanks,

Jamie

5 replies

Buddhika Kurera
Superhero (Employee)
Forum|alt.badge.img+15
  • Superhero (Employee)
  • January 21, 2024

@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 !


FRSMDE
Do Gooder (Employee)
Forum|alt.badge.img+6
  • Do Gooder (Employee)
  • May 8, 2024

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


PhillBronson
Hero (Customer)
Forum|alt.badge.img+11
  • Hero (Customer)
  • August 9, 2024

@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


AveTonitM
Hero (Partner)
Forum|alt.badge.img+10
  • Hero (Partner)
  • November 1, 2024

@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.

 


Forum|alt.badge.img+7
  • Do Gooder (Customer)
  • July 9, 2025

I have a similar situation.  Watching this ticket