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
3 replies
Subscribers
5 subscribers
Views
1190 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Reports
106290 - no subject - Hi,\nPlease find below the code snippet.
phanibabuk
over 10 years ago
Hi,
Please find below the code snippet.
a!gridTextColumn(
label: "Active",
data: if(
isnull(
local!data.isActive
),
"",
index(
local!data,
"isActive",
{}
)
),
field: "isActive"
)
Error:
Invalid index: Cannot index property 'isActive' of type Text into null value of type List of Variant.
How can I fix this issue? Any inputs are highly appreciated....
OriginalPostID-106290
Discussion posts and replies are publicly visible
0
phanibabuk
over 10 years ago
The datatype of "isActive" is boolean in db.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
thanigaivelr
over 10 years ago
Can you do null check on local!data instead of checking on local!data.isActive?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
sikhivahans
over 10 years ago
Hi phanibabuk, Few things to note here are:
1. As you are using index(), there is no need for explicit null handling. index(local!data,"isActive",{}) will do it for you.
2. The error which you are seeing might be the outcome of two possible reasons as following:
a. Your code renders single null ("") if local!data.isActive is null. You are trying to assign a single null value to multiple type field.
b. The field 'isActive' might not exist with the same name. Cross check the cdt once.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel