Will someone help me figure out how to write conditions for this case?
I have a model (ModelA) with a lookup field called Staff__c.
I have a model (SelectedStaff) which will either be empty (if no staff is selected) or have one row.
I want ModelA to return records where Staff__c=null when the SelectedStaff model is empty, and Staff__c=(SelectedStaff)(Id) when it's not empty.
I'm struggling to write conditions to do that. Help?
I have a model (ModelA) with a lookup field called Staff__c.
I have a model (SelectedStaff) which will either be empty (if no staff is selected) or have one row.
I want ModelA to return records where Staff__c=null when the SelectedStaff model is empty, and Staff__c=(SelectedStaff)(Id) when it's not empty.
I'm struggling to write conditions to do that. Help?
Matt Sones, Champion
-
31,702 Points
Posted 1 year ago
mB Pat Vachon, Champion
-
42,926 Points
Matt Sones, Champion
-
31,702 Points
Ah.
I'm just going to use Staff__c = "" filterable default on for ModelA, and run a model actions on query of the SelectedStaff model to set the value and query ModelA. The only downside here is that I can't have skuid 'remember' the selected staff... it has to start off empty.
I'm just going to use Staff__c = "" filterable default on for ModelA, and run a model actions on query of the SelectedStaff model to set the value and query ModelA. The only downside here is that I can't have skuid 'remember' the selected staff... it has to start off empty.
Matt Sones, Champion
Otherwise, I have no idea.
mB Pat Vachon, Champion
Matt Sones, Champion