Hi Ahmed and Appgini'rs
When I insert a look up field in a table, I have the option to
- inherit permissions, OR
- do an advanced query
Problem is, I want to only records that
- a field called ADDRESS with a value > 0, AND
- a field called USERNAME with a value that == the logged in username
Can I do that?
Advanced wuery for look up
Re: Advanced wuery for look up
Any thoughts anyone?
Re: Advanced wuery for look up
Out of my knowledge that is not possible, as you cannot access the logged in username at the moment that advanced query.
Any help offered comes with the best of intentions. Use it at your own risk. In any case, please make a backup of your existing environment before applying any changes.
Re: Advanced wuery for look up
Hi
in a quick test my "advanced query" was stored in two files:
/admin/incFunctions.php
and
/ajax_combo.php
This would be my point of intervention: Instead of returning the advanced SQL built that SQL in place and grabbing the current user. Sound possible to me.
Olaf
in a quick test my "advanced query" was stored in two files:
/admin/incFunctions.php
and
/ajax_combo.php
This would be my point of intervention: Instead of returning the advanced SQL built that SQL in place and grabbing the current user. Sound possible to me.
Olaf
Some postings I was involved, you might find useful:
Multi Path Upload (MPU) / dynamic upload folder; 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
Multi Path Upload (MPU) / dynamic upload folder; 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
Re: Advanced wuery for look up
Thanks @olaf. Will try to modify those files from hooks