This content has been marked as final. Show 2 replies
I like to keep it simple, so I would do two separate queries, one on startup to populate the combobox, and then the second one triggered off the combobox's change event that gets the details for the datagrid.
Assuming we're not talking about a crazy amount of data in the datagrid, the lag will not be very noticeable to users when they are waiting for the DG to be populated from a server request.
Thanks for that Matt. I haven't had much luck in getting it to work with multiple queries and passing items back to PHP to query the DB as a where clause.
I did come across this
And i have found I could get this to work to create a datagrid with a combobox filter on each column.
However the comboboxes are populated from an array in the app, not sure if this is a very efficient way to do it as the some lists can be nearly 200 long.
What I'm after doing now is to have the comboboxes, filter depending on what is shown in the other boxes. So the columns are a "group code" [cbIL], "Org Code" [cbTC], "Org Name" [cbDP], and "Module" [cmMD]. Each Group Code can have several Organisations assigned to it, but an Org is only in one group. Each Org has multiple modules assigned to it.
What I have found with the way I have done this so far is that You can filter by Org Name, but are then able to select any of the other Org Codes. It would be good say if you select a Group Code, only the Org Codes and Org Names that are assigned to that group will then be visible in the other comboboxes.
Is this going to be easily done with what I have done so far?
Am I really heading in the wrong direction with this?
Can anyone recommend any online resources to help me with the live query route?