Question

Sorting of IFS Screen data when navigated through a Lobby Element

  • 1 May 2023
  • 5 replies
  • 191 views

Badge +2

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

Userlevel 5
Badge +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.

Badge +2

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

Userlevel 5
Badge +9

It can be done through this option:

 

This thread is talking about it:

 

Badge +2

Thanks a ton. I was missing a simple configuration. 

Userlevel 3
Badge +8

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