Hi,
as there (sometimes) seems to be a problem with ajax caching (dependent lookup fields not updated on master change; viewtopic.php?f=2&t=3491 ) or 'data-loss' in lookups ( viewtopic.php?t=2955 ),
I suggest adding the option to AG at the application level, at single table level and at field level to disable ajax caching.
This would enable fixing such (and similar) problems by definition in AG and without overwriting the fixes done by hand.
pbötcher suggested two methods here viewtopic.php?t=2955 , so introducing such a feature on field level, AG could simply comment the lines as pbötcher does in the ajax-cahce file.
At table level jsetzer's suggestion at viewtopic.php?t=2955 could help simply ignoring the file by renaming it or not creating it in the first place.
At application level, either all codelines could be commented or the file-creation of the ajax-cache files simply skipped.
I am not sure, why the problem occured (for me), but it was there and it actually led to data corruption, as the child lookup did not match the available options in the master lookup anymore.
Olaf
Option to disable ajax caching for app, table, field
Option to disable ajax caching for app, table, field
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: Option to disable ajax caching for app, table, field
Hmm ... I'll study this issue and all the links you pointed to and act accordingly. Thanks for reporting this, Olaf.
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
- Mass Update plugin: Update multiple records at once and improve your workflow efficiency.
- Check our other plugins and get a generous discount of up to 30% when buying 2 or more plugins.