AnsweredAssumed Answered

How can you search for blank (or not blank) fields?

Question asked by bmccarthy on May 20, 2014
Hello!
I have a a few modules that I need to be able to perform a search on to find blank (or fields that are not blank). 

For instance, I have a One-to-Many relationship (Accounts -> Accounts) that let's me know if an account was referred by another account. I'd like to be able to search for all accounts that are not blank (aka, were referred by someone) or vice versa (accounts that were not referred by anyone). 

How can I accomplish this feat? 

I know it's not available with CE, but I'm okay with editing the code if someone can provide me with some direction. 

Thanks!

Outcomes