Skip to main content
Question

How to sort client screen field

  • Mar 7, 2024 9:14 PM UTC
  • 5 replies
  • 105 views

Forum|alt.badge.img+4

We want to sort FSM client fields on some screens.  Example: ‘Product’ screen has a section in the workspace called Service History where we show information from the Request table that is related to the Product.  Currently it is sorted by Request Id, but we would want this sorted by the Request create_dttm.

I looked in UI Designer at the properties for this field but did not see an option to sort.  See attached screenshot of the Product screen.

5 replies

Shneor Cheshin
Superhero (Employee)
Forum|alt.badge.img+28
  • Superhero (Employee)
  • Mar 8, 2024 12:41 AM UTC

Hi @Jacksonc 

Users should click the column header and sort by column. 

Cheers!


Forum|alt.badge.img+4
  • Author
  • Do Gooder (Customer)
  • Mar 8, 2024 9:44 PM UTC

Thanks for your reply Shneor.  I was looking for a way to make the sort permanent for the screen.  Morris Ruben (IFS) showed me how to use UI Designer - child relationships to add in a sort to the table and field that displays for the screen.


Shneor Cheshin
Superhero (Employee)
Forum|alt.badge.img+28
  • Superhero (Employee)
  • Mar 11, 2024 1:39 AM UTC

Hi @Jacksonc 

Mind sharing with us the solution?

I think many will benefit from it.

Cheers!


Forum|alt.badge.img+4
  • Author
  • Do Gooder (Customer)
  • Mar 14, 2024 11:23 AM UTC

Hi Shneor,

I hadn’t shared the solution, because in my case it’s not working 100% - we believe this may because of other sorts in place in the native app??

However in most cases this should work:

UI designer for the screen / Edit Child Relations / Select the Parent and Related table (in my case it was request_unit and request) / Add in an ‘Order By’ at the bottom (in my case the Name for this was request.created_dttm)


Shneor Cheshin
Superhero (Employee)
Forum|alt.badge.img+28
  • Superhero (Employee)
  • Mar 14, 2024 11:52 PM UTC

@Jacksonc 

Cheers mate!