Examples of Filtering Offline Objects

Here are examples of using SOQL filters for Offline Objects:

Filtering Offline Orders for CT Order Module

Filtering Offline Orders Created in Specified Period

In this example, you need to synchronize only Offline Orders, which are created not earlier than in the current month to reduce volume of data during every synchronization:

  • In CT Mobile Control Panel

  • In CT Mobile Control Panel 2.0

  1. Go to CT Mobile Control Panel: Offline Objects.

  2. In the Selected list, click on CT Order object. If it is not in the Selected list, drag it from the Available list.

  3. In the Object Permission section, click the setup icon 62556081 next to the offline object.

    ct mobile offline orders tab

  4. In the Query Editor window, add criteria:

    • Field: Created Date;

    • Operator: Greater or equal;

    • Value: LAST_MONTH.

      ct mobile last month filter

  5. Click Save in the Query Editor window and on the Offline objects page.

  6. Launch Full Synchronization for the new filter to take effect.

  1. Go to CT Mobile Control Panel 2.0: Offline Objects.

  2. In the Selected list, click on CT Order object. If it is not in the Selected list, move it from the Available list.

  3. Click the Filter tab and then Add Filter button.

  4. Specify the following filter criterion:

    • Field: Created Date

    • Operator: greater or equal

    • Value: Last Days (30)

  5. Click Save.

  6. Launch Full Synchronization for the new filter to take effect.

ctm control panel new filtering offline objects example

Filtering Offline Orders Created in Specified Period and Specified Stage

In this example, you need to synchronize only Offline Orders, which are created not earlier than in the current month plus Offline Orders in stage On-Hold disregarding their creation date:

  • In CT Mobile Control Panel

  • In CT Mobile Control Panel 2.0

  1. Create the same filter as described in the previous example.

  2. In the Query Editor window, add additional criteria:

    • Field: Stage

    • Operator: Equals

    • Value: On-Hold

  3. Enable the Filter Logic.

  4. In the field below, type 1 or 2.

  5. Click Save in the Query Editor window and on the Offline objects page.

  6. Launch Full Synchronization for the new filter to take effect.

ct mobile last month on hold filter

  1. Create the same filter as described in the previous example.

  2. On the Filter tab, click Add Filter to add additional criteria:

    1. Field: Stage

    2. Operator: equal

    3. Value: On-Hold

  3. Switch logic to OR.

  4. Click Save.

  5. Launch Full Synchronization for the new filter to take effect.

ctm control panel new filtering offline objects example2
``