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


(?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.