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
10 replies
Subscribers
9 subscribers
Views
5812 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
General
Hi, I have been working on CDT null checks. My CDT has two attributes
iainf
over 12 years ago
Hi,
I have been working on CDT null checks. My CDT has two attributes: ID and email (one to many).
I query the table on the ID. I then do an isNull check.
Sometimes I get "true" because the query returns this sort of object: ("").
Sometimes it simply fails because the query returns this sort of object: (ID = "", Email = "").
Can anyone tell me when I can expect to see this: (""), and when I can expect to see this: (ID = "", Email = "").
This is important because in testing I found the rule was working and after deployment it was not.
I know that the correct thing to do is to do the isNull check on the primary attribute of the CDT; what I'm after here is an explanation of the apparantly unpredictable behaviour.
Thanks
Iain...
OriginalPostID-63485
OriginalPostID-63485
Discussion posts and replies are publicly visible
Parents
0
revat.anandsongkit
Appian Employee
over 12 years ago
If calling a query rule which produces an empty result -
Non-multiple: [ID="", Email=""]. If you do an isNull check on this, it will return False and length = 1. What you could check is if a specific field is null e.g. isnull(pv!cdt.ID)
Multiple: pv! = empty list. isnull(pv!) = False but length(pv!) = 0.
What I would suggest is to create a simple model that runs through both of these use cases...I think it will help a lot if you see it for yourself. Also, have a look at these two links:
forum.appian.com/.../Informational_Functions
and
forum.appian.com/.../Array_Functions
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
revat.anandsongkit
Appian Employee
over 12 years ago
If calling a query rule which produces an empty result -
Non-multiple: [ID="", Email=""]. If you do an isNull check on this, it will return False and length = 1. What you could check is if a specific field is null e.g. isnull(pv!cdt.ID)
Multiple: pv! = empty list. isnull(pv!) = False but length(pv!) = 0.
What I would suggest is to create a simple model that runs through both of these use cases...I think it will help a lot if you see it for yourself. Also, have a look at these two links:
forum.appian.com/.../Informational_Functions
and
forum.appian.com/.../Array_Functions
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data