Sorting by a VL using a CDML -dso_xml URI Query

[joseppic]

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.

[Garry Claridge]

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

[joseppic]

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.

[joseppic]

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.