Skip to main content
Question

Sorting of IFS Screen data when navigated through a Lobby Element


Forum|alt.badge.img+4
  • Do Gooder (Partner)
  • 6 replies

Dears - When navigating from Lobby Element to a particular IFS Screen, is there any option to fetch the data sorted on the basis of a field value.

Example - Lobby Element -- navigates to Purchase Orders screen. Can we sort the Purchase Orders on the basis of ORDER_NO ?

5 replies

Forum|alt.badge.img+9

Hi, I may not have understood your question properly, but in Navigation you can filter the target view by specifying relevant target column (NB: make sure you name them exactly as they are in the target view) and/or through the URL that can also contain filters.

You can have something a bit more sophisticated URL thanks to “external search” function:

ifsapf:frmAvailabilityPlanning?EXTERNAL_SEARCH=CONTRACT%3D{&CONTRACT}%26PART_NO%3D{&PART_NO}%26PROJECT_ID%3D%23

If needed, you can easily find other discussions describing this function.


Forum|alt.badge.img+4
  • Author
  • Do Gooder (Partner)
  • 6 replies
  • May 1, 2023

Thanks for this. Is there any option to SORT the data ?


Forum|alt.badge.img+9

It can be done through this option:

 

This thread is talking about it:

 


Forum|alt.badge.img+4
  • Author
  • Do Gooder (Partner)
  • 6 replies
  • May 1, 2023

Thanks a ton. I was missing a simple configuration. 


DHCRADPA
Hero (Customer)
Forum|alt.badge.img+9
  • Hero (Customer)
  • 93 replies
  • May 10, 2023

You can also sort with specific/multiple columns by providing the &$orderby system query option in the URI/URL, after the #COMPANY_ID# parameter. It allows clients to request resources in either ascending order using asc or descending order using desc. The request below orders Trips on property EndsAt in descending order.

GET serviceRoot/Trips?$orderby=EndsAt desc

 

Basic Tutorial · OData - the Best Way to REST


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings