May 18, 200421 yr 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.
May 19, 200421 yr 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
May 19, 200421 yr 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.
May 19, 200421 yr 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