Lookup Table Filter
Lookup Table Filter
It would be nice to filter the lookup table drop down and limit the list to only a group or user.
Re: Lookup Table Filter
(+1)
It would be even more flexible to have a PHP-hook for lookups which would allow us to return any array of
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).
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).
Kind regards,
<js />
My AppGini Blog:
https://appgini.bizzworxx.de/blog
You can help us helping you:
Please always put code fragments inside
AppGini 24.14 Revision 1665 + all AppGini Helper tools
<js />
My AppGini Blog:
https://appgini.bizzworxx.de/blog
You can help us helping you:
Please always put code fragments inside
[code]...[/code]
blocks for better readabilityAppGini 24.14 Revision 1665 + all AppGini Helper tools
Re: Lookup Table Filter
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?
Thanks for this suggestion Jan. Makes a lot of sense. I added it to my backlog now.
AppGini plugins to add more power to your apps:
- DataTalk is an innovative AppGini plugin based on ChatGPT that allows you to interact with your AppGini database using natural language questions, without writing any SQL. Check the demo video
- Check our other plugins and get a generous discount of up to 30% when buying 2 or more plugins.
- Need personalized consulting on your specific app and customizations? Book an online call with me here.
- D Oliveira
- AppGini Super Hero
- Posts: 353
- Joined: 2018-03-04 09:30
- Location: David
Re: Lookup Table Filter
is there a way to include memberID in a custom query through appgini directly(advanced feature)? WHERE membership_users.memberID = self.ID ?
a.gneady wrote: ↑2023-03-25 19:32To 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?
Thanks for this suggestion Jan. Makes a lot of sense. I added it to my backlog now.
Re: Lookup Table Filter
I've never seen such a replacement in the code which evaluates custom queries. So, I'm afraid there isn't.
Kind regards,
<js />
My AppGini Blog:
https://appgini.bizzworxx.de/blog
You can help us helping you:
Please always put code fragments inside
AppGini 24.14 Revision 1665 + all AppGini Helper tools
<js />
My AppGini Blog:
https://appgini.bizzworxx.de/blog
You can help us helping you:
Please always put code fragments inside
[code]...[/code]
blocks for better readabilityAppGini 24.14 Revision 1665 + all AppGini Helper tools
Re: Lookup Table Filter
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
Re: Lookup Table Filter
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
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
- Attachments
-
- ONE data, no need to click or enter ....
- Capture d'écran 2024-01-16 202911.jpg (45.04 KiB) Viewed 1401 times