question Mobile Agent offline fetch script in Community Central forum

Mobile Agent offline fetch script

Jeff Lyons — Tue, 20 Jan 2026 16:53:19 GMT

When downloading the cache for offline mode, I can only retrieve up to a maximum of 1,000 users from the sys_user table. I have many more active users than this limitation. I'm looking for guidance on creating an offline fetch script under input attributes for assigned to in my create interaction function. I need to dynamically fetch the logged in user's sys ID (gs.getUserID() and return results of any records on the user table who share the same location.

I will apply this same logic to any sys_user reference field for incidents and interactions. Thanks for the help!

Re: Mobile Agent offline fetch script

Matthew_13 — Wed, 21 Jan 2026 03:42:07 GMT

Hi Buddy,

Offline reference caching is capped at ~1,000 records, so you must filter sys_user instead of caching all

Here is the short version that works for Mobile / Now Mobile offline mode.

1) Script Include (server-side)

Create a Script Include to return active users in the same location as the logged-in user, plus the user themself.

var MobileOfflineUserFetch = Class.create();
MobileOfflineUserFetch.prototype = {
    initialize: function() {},

    getUsersByMyLocation: function() {
        var ids = [];
        var myId = gs.getUserID();
        var myLoc = gs.getUser().getLocation();

        ids.push(myId); // always include self

        if (!myLoc)
            return ids.join(',');

        var gr = new GlideRecord('sys_user');
        gr.addActiveQuery();
        gr.addQuery('location', myLoc);
        gr.setLimit(1000);
        gr.query();

        while (gr.next()) {
            ids.push(gr.getUniqueValue());
        }
        return ids.join(',');
    },

    type: 'MobileOfflineUserFetch'
};

2) Assigned To → OfflineFetchScript

On the Assigned to reference input (Create Interaction):

javascript&colon;new MobileOfflineUserFetch().getUsersByMyLocation()

Result

Offline cache stays under 1,000 records
Users see only relevant users (same location)
Reusable for Incident, Interaction, or any sys_user reference field

@Jeff Lyons - Please Mark Accepted Solution and Thumbs Up if you found Helpful 🙂

Re: Mobile Agent offline fetch script

nataliya_b — Thu, 09 Apr 2026 17:49:44 GMT

Hi @Matthew_13

I tried your solution and still could not get the user list for assigned_to reference input in offline mode.

For some reason assigned_to input's attribute OfflineFetchScript with value = javascript&colon;

new MobileOfflineUserFetch().getUsersByMyLocation()

just not working. No data brought back.

Interesting, when I set Conditions for online (for example: type=active^location=sys_id), offline uses this data to bring users back and not offline script fetch attribute.

Any idea?