Hello Everybody, Has anyone had success creating a facet that filters

Jin Pheh

Certified Associate Developer

over 9 years ago

Hello Everybody,

Has anyone had success creating a facet that filters results based on a null value? I've found three previous forum posts on the subject but none of them have any solutions or workarounds (The solution in the first post doesn't work outside of a limited dataset where all possible values are known)
forum.appian.com/.../e-77621
forum.appian.com/.../e-112582
forum.appian.com/.../e-110585...

Discussion posts and replies are publicly visible

Parents

0 Jason Ruvinsky
Certified Senior Developer
over 9 years ago

Our work-around is to create a view in the database that either has a column with an indicator when the field is null, or puts a string value in the field. Then we would base the entity-backed record type off this view, rather than the table.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Jason Ruvinsky
Certified Senior Developer
over 9 years ago

Our work-around is to create a view in the database that either has a column with an indicator when the field is null, or puts a string value in the field. Then we would base the entity-backed record type off this view, rather than the table.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data