- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-24-2025 08:56 AM
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.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-24-2025 11:00 AM
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-...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-24-2025 11:00 AM
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-...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-24-2025 11:27 PM
Somehow Ascending didn't work
However, it does descending and it is good to our solution.
Thank you!!