Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
4 replies
Subscribers
10 subscribers
Views
1900 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Data and Records
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....
OriginalPostID-110585
OriginalPostID-110585
Discussion posts and replies are publicly visible
0
dylanf
over 10 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 10 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 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
0
dylanf
over 10 years ago
Tim, or anyone else, any thoughts here?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel