Hi, I'm trying to figure out how to create a facet on an entity b

dylanf over 11 years ago

Hi,

I'm trying to figure out how to create a facet on an entity backed record that is based on the existence or non-existence of a date for a specific record field, but I'm not having any luck in doing this using = null() and <> null(), respectively, in my facet options.

Any assistance would be greatly appreciated....

Discussion posts and replies are publicly visible

0 dylanf over 11 years ago

also tried = todatetime(null()), but that didn't work either.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Tim Nguyen
Appian Employee
over 11 years ago

Could you double check if that value of the specific record field is empty, or that it actually has some value in it?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 dylanf over 11 years ago

I'm fairly certain it's null. I added this expression to the record dashboard:

a!textField(
label: "CompletionDate",
readOnly: true,
value: if(isnull(rf!ProcessInstanceCompleted),"Null","Not Null")

for records where the value in our database is null, that expression renders as "Null" on the record dashboard page and "Not Null" when there is a value.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 dylanf over 11 years ago

Tim, or anyone else, any thoughts here?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel