Order records in Mobile APP Screen Segment with several list streams

[Marta Vicente R]

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. 

[davidmurch · Accepted solution]

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-...

[Marta Vicente R]

Somehow Ascending didn't work

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

Thank you!!