question Re: Order records in Mobile APP Screen Segment with several list streams in Mobile Apps & Platform forum

Order records in Mobile APP Screen Segment with several list streams

Marta Vicente R — Mon, 24 Mar 2025 15:56:47 GMT

In Mobile app, I want a list with records from 2 different tables with records ordered by date.
- one table is wm_task, order by window start
- second table is custom event table, order by start date time field

The records should be ordered by the date, so the list is unify and record of both tables are mixed.

Is that even possible?
Notes: These tables does not have a common parent table. I know it can be done with calendar screen, but the requirement is to do it on a regular list.

Re: Order records in Mobile APP Screen Segment with several list streams

davidmurch — Mon, 24 Mar 2025 18:00:54 GMT

Yes, you should be able to do this by putting two list streams [sys_sg_item_stream] within one list segment [sys_sg_item_stream_segment].

On the list streams you will use the date fields you mentioned to populate the "interleaved field" field. On the segment, set the "interleaved sort" field to ascending or descending, depending on your desired sort.

https://www.servicenow.com/docs/bundle/washingtondc-mobile/page/administer/tablet-mobile-ui/task/sg-configure-list-screen.html

Re: Order records in Mobile APP Screen Segment with several list streams

Marta Vicente R — Tue, 25 Mar 2025 06:27:44 GMT

Somehow Ascending didn't work

However, it does descending and it is good to our solution.

Thank you!!