Lookup Table Filter

[richard]

It would be nice to filter the lookup table drop down and limit the list to only a group or user.

[jsetzer]

(+1)

It would be even more flexible to have a PHP-hook for lookups which would allow us to return any array of { id, text }-entries with completely free options for sorting, filtering etc..

Having this, we could even fetch any items from remote web API's or any other local or remote data provider, as long as the returned id's match up with the parent lookup table's primary keys.

Additionally, such a feature would allow us to freely populate option lists by code (which are now modeled like A;;B;;C or populated through .csv file).

[a.gneady]

It would be nice to filter the lookup table drop down and limit the list to only a group or user.

To make sure I understand your request, lookup fields currently allow you to filter contents by editing the SQL query (by clicking the advanced button under the lookup field tab in AppGini). Also, you can limit lookup contents to only the items accessible to the current user by checking the option 'Inherit access permissions'. So, is your suggestion describing a different case not covered by those two options?

It would be even more flexible to have a PHP-hook for lookups which would allow us to return any array of { id, text }-entries with completely free options for sorting, filtering etc..

Thanks for this suggestion Jan. Makes a lot of sense. I added it to my backlog now.

[D Oliveira]

is there a way to include memberID in a custom query through appgini directly(advanced feature)? WHERE membership_users.memberID = self.ID ?

It would be nice to filter the lookup table drop down and limit the list to only a group or user.

To make sure I understand your request, lookup fields currently allow you to filter contents by editing the SQL query (by clicking the advanced button under the lookup field tab in AppGini). Also, you can limit lookup contents to only the items accessible to the current user by checking the option 'Inherit access permissions'. So, is your suggestion describing a different case not covered by those two options?

It would be even more flexible to have a PHP-hook for lookups which would allow us to return any array of { id, text }-entries with completely free options for sorting, filtering etc..

Thanks for this suggestion Jan. Makes a lot of sense. I added it to my backlog now.

[jsetzer]

I've never seen such a replacement in the code which evaluates custom queries. So, I'm afraid there isn't.

[richard]

I do understand about

Code: Select all

and will do.  I will give these answers a shot.  I did realize it would be better in my case to limit the list to group and not individual but I will give it a try. Thanks so much

[fdissait]

Hello AppGini team.
About working on lookup table filter, is it possible to set in programming options of the filter, the facility to automatically <Enter> when the list contains ONE data.
Doing so we economize a mouse click
I try to obtain that on a lookup field entered by barcode reading ... tried various options, no way.
See picture joined

François