Jon Barnes
Kilo Sage

I would use a database view with a left outer join for this. Basic steps for this: Create a new dB view.

Add sys_user table first and give it an order of 100. Set the prefix as ”usr”.

Add u_title_list table second with an order of 200. Make this one a left join by checking the left join box. If it isn’t on the form you can set it from the list view. Set the prefix on this table as “ttl”.

Set the where clause on the u_title_list table record as. ttl_u_title = usr_title.

Now, once that is added, you have created your functioning DB view. If you go to the new view and click Try It in the related links, you will see the tables joined together.

Finally you can use the filters to add a query like this: Title (ttl_u_title) Is Empty AND Title (usr_title) Is Not Empty. Let me know if that works for you.

View solution in original post