Skip to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Sorting by a VL using a CDML -dso_xml URI Query

Featured Replies

Hi,

Using CDML on the URI to return XML, I would like to know if it is possible within CDML to do a find and sort the results by a Value List rather than a normal sort field (-sortfield).

This is available in the FileMaker client of course but I cannot find out if it is available as part of CDML. Otherwise, will I have to move the VL out into its own table and add a sort order numeric field to this new table (file)?

Any ideas?

Thanks,

Joseppi.

I'm not sure why there would be a difference between sorting on a field and the sort order of a ValueList based on that field!

Good Luck.

Garry

  • Author

I think I need to use the -sortOrder flag after -sortField and stipulate Custom and the VL I wish to sort by.

I'm in the process of trying to get it working.

CDML eh eh eh.

Cheers,

Joseppic.

  • Author

I got it working, the URI just needs the following added:

-SortOrder=custom=<your VL name>

-SortField=<the field to be sorted on>

Now things come out in the right order.

Have good days.

Joseppic.

Create an account or sign in to comment

Important Information

By using this site, you agree to our Terms of Use.

Account

Navigation

Search

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.