Merry Xmas and Happy New Year All,(tu)
I feel like this might be a stupid question, but I have heard it said that the only stupid questions are the ones that are not asked.
So, is there a simple way of setting the default search order for a table to one specific or specific multiple columns?
Examples might be :-
1) Last name then First name.
or
2) County then City.
I know that the Dadabik administrator can cause initial display to be in a specific single order on one field by appending single field sort order parameters in the address bar.
so
../index.php?table_name=mytable&function=search&records_per_page=500
would become
../index.php/?table_name=mytable&function=search&records_per_page=500 &where_clause=&page=0&order=city&order_type=ASC
to order them by a City field in ascending order.
However, this is not easily accessible as a method for me because I have the login process to go through first and the initial results for my single table are displayed automatically after that.
I also know that the person viewing can click a specific field title once or twice to sort the results by that field in Ascending and Descending orders respectively.
But either way described only works for a single field.
So there are two questions really.
Both cases involving a user login first of all.
Any help greatly appreciated.
Kind Regards,
Simon
I feel like this might be a stupid question, but I have heard it said that the only stupid questions are the ones that are not asked.
So, is there a simple way of setting the default search order for a table to one specific or specific multiple columns?
Examples might be :-
1) Last name then First name.
or
2) County then City.
I know that the Dadabik administrator can cause initial display to be in a specific single order on one field by appending single field sort order parameters in the address bar.
so
../index.php?table_name=mytable&function=search&records_per_page=500
would become
../index.php/?table_name=mytable&function=search&records_per_page=500 &where_clause=&page=0&order=city&order_type=ASC
to order them by a City field in ascending order.
However, this is not easily accessible as a method for me because I have the login process to go through first and the initial results for my single table are displayed automatically after that.
I also know that the person viewing can click a specific field title once or twice to sort the results by that field in Ascending and Descending orders respectively.
But either way described only works for a single field.
So there are two questions really.
- How to set a default search order to a single specific field?
- How to set a sort order based upon two fields if indeed this is possible?
Both cases involving a user login first of all.
Any help greatly appreciated.
Kind Regards,
Simon