AnsweredAssumed Answered

Table relationship with an empty value

Question asked by ericjlindholm on Oct 23, 2015
Latest reply on Nov 9, 2015 by Mike_Mitchell

I have a Event::Cwarnings field that is a calculation based on different things like event status in relationship to the end date.  for example, if the event is over and not invoiced or paid, returns a warning that says "not invoiced."

 

If there are no warnings and the field is empty.

 

I want to create a table relationship with the user homepage where

 

User::User ID = Event::Account Manager

AND

(?unknown field representing a non value?) does not equal Event::cWarnings

 

I was able to do this with User::User ID = Event::Account Manager and filtering the portal but the performance is lacking because there are many event records to filter.

 

Thanks!

Outcomes