Hi
It would be desirable to be able to have variables (PHP or AppGini) that could be used in "Advanced Lookup Options" In this way we could customize our queries. ej:
'select * from table_name where date = ' + 'hereMyVar' + 'rest of my query'
hereMyVar would be fully defined by either jQuery or PHP code.
Run time variables in DV & TV
Re: Run time variables in DV & TV
Hi,
yes, I agree, that this would be a great feature.
Olaf
yes, I agree, that this would be a great feature.
Olaf
Some postings I was involved, you might find useful:
SingleEdit - Prevent concurrent edits on records; Field Permissions; Column-Value-Based-Permissions; Custom (error) message; Audit Log; Backup your database; Two Factor Authentication; Block brute force (failed) logins; Add 2nd SAVE CHANGES button; Place a search on details view
SingleEdit - Prevent concurrent edits on records; Field Permissions; Column-Value-Based-Permissions; Custom (error) message; Audit Log; Backup your database; Two Factor Authentication; Block brute force (failed) logins; Add 2nd SAVE CHANGES button; Place a search on details view
Re: Run time variables in DV & TV
Actually, I'd prefer a hook.customize our queries
Reason: if we had variables in Advanced Query Editor, we would have to generate code on any small change and even if our SQL query was buggy. That's annoying, if you ask me. It takes minutes every time.
But if we had PHP hooks for lookup queries, we could evaluate request parameters, check permissions or fetch any other data we need and then return a SQL command or even an array { id, text }.
From my perspective this would be...
- easier to implement for BigProf
(just afunction_exists
evaluation) - backward compatible
(nothing changes if hook does not exist) - easy to use for us
(hey, it's PHP) - faster in development
(because we don't need to re-generate code each time) - better to test
(we just have to change code and then open dropdown control, which will automatically fetch data from the server, using our latest changes) - super-flexible and much more powerful than a handfull static variables
(because we can decide what to return)
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.10 Revision 1579 + 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.10 Revision 1579 + all AppGini Helper tools