Skip to main content
Question

Sorting of IFS Screen data when navigated through a Lobby Element

  • May 1, 2023
  • 5 replies
  • 331 views

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+10
  • Hero (Customer)
  • 61 replies
  • May 1, 2023

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+10
  • Hero (Customer)
  • 61 replies
  • May 1, 2023

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+10
  • Hero (Customer)
  • 97 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