× If you expect answers you should describe your problem and give as much information's as possible. (SQL-Structure, Template Code, Joomla Version ...) Please read this before posting: joodb.feenders.de/support.html

Sort Data Set Value in Table Catalog View

More
5 years 7 months ago - 5 years 7 months ago #4880 by megat
Hi

I can't find any thread similar to my question, if ever existed before, sorry if it's redundant..

I'm using this great component for displaying a staff directory from a database

So, i have this kind of value of data set, for example

Name
Position
Department

My project require me to display the table by department, which can be done by Group Select, but additionally, i need to sort them based on Position as well, from Director, Manager, Senior Executive, Junior Executive and Intern

I'm using the Group Select in url post, can i just put data row id so that the table will list the staff in the selected department sorted by their ID position, e.g 321,323,345,367

Let's say if the whole department have 50 staffs, but i just need to list the top 5 managers first while the other staffs should be fine to be randomly displayed

what is the syntac i should add in my post url?

Does this even possible? how to?

Let me know if my question is not clear yet

Please advise, thanks!
Last edit: 5 years 7 months ago by megat.

Please Log in to join the conversation.

Moderators: Dirkjoest