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

dylanf over 10 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

Parents

0 dylanf over 10 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

Reply

0 dylanf over 10 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

Children

No Data