Advanced wuery for look up

[jmcgov]

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?

[jmcgov]

Any thoughts anyone?

[pbottcher]

Out of my knowledge that is not possible, as you cannot access the logged in username at the moment that advanced query.

[jmcgov]

Out of my knowledge that is not possible, as you cannot access the logged in username at the moment that advanced query.

OK, thank you.
I winder if I could create a hook routine that would find and replace the query - do you know where it is stored?

[onoehring]

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

[jmcgov]

Thanks @olaf. Will try to modify those files from hooks