XF 1.3 IS NOT NULL Query?

[bluepaw]

Is there a way to run the equivalent of an IS NOT NULL query on the search users page for custom fields? Am trying to find all users who have a value of something in the field.

Also if that is possible, can this same query be used in performing trophy awards?

I've searched and am unable to locate any thing that would do what I'm looking for.

 

[Mike]

You would need to write and run the queries directly against the DB.