Sorting Relationships

[mikep]

I am trying to sort the records in my relationship tabs. I tried the following statement

SELECT * from Progress_Notes where Client_ID='$Client_ID' ORDER BY Client_ID DESC, Date DESC

but it didn't work. I'm assuming ORDER BY clauses are not supported in Xataface relationships.

How do you go about sorting records in a relationship?

Thank you,
Mike

[shannah]

Yes. You should not include an order by clause in a relationship definition. Sorting is done at a higher level. E.g. click on the column headings in your relationship tabs. You'll notices that it adds something like -related:sort={column name} to the url.

-Steve

[mikep]

Hi,

I tried adding this to my index.php

if ( !isset($_REQUEST['-sort']) and @$_REQUEST['-relationship']=='Table_Name' ){
$_REQUEST['-sort'] = $_GET['-sort'] = 'Client_ID desc, Date desc';
}

But it didn't seem to work. Where and how can I modify the link for this relationship?

Thanks,
Mike

[shannah]

For relationships, it doesn't use the -sort parameter. It uses the -related:sort parameter.
If you click on a relationship tab and then sort the records by clicking on a column header you'll see what this parameter looks like in the query string.

[mikep]

Ah, thanks. I was only looking at the link for the relationship tab.


Mike