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
17 replies
Subscribers
11 subscribers
Views
9599 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Data and Records
I have a Record Related Action Visibility question. I am querying off of a Data
brianc
over 8 years ago
I have a Record Related Action Visibility question. I am querying off of a Data Store Entity, and pulling in a field called Status (Type: Text). I am trying to use this Status field to evaluate the Visibility for the Related Action. Example: if( rf!status = "Complete", true, false). I have tried multiple variations of this if statement (toboolean(if( rf!status = "Complete", true, false)) - if( rf!status = "Complete", true(), false()) and many others. Nothing seems to be evaluating to true, causing the visibility of the related action not to appear. I have tried evaluating with a Boolean field I am pulling from the Data Store Entity, and it seems to be working fine. Is there anyway to evaluate a text field to allow visibility to work for a related action?
OriginalPostID-154938
OriginalPostID-154938
Discussion posts and replies are publicly visible
0
Tim
Certified Lead Developer
over 8 years ago
I will assume you've confirmed the related action will appear with the standard visibility setting to rule out security or start form issues? Other than that simply rf!status="Completed" should be sufficient to return a Boolean for your condition.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
brianc
over 8 years ago
Correct Tim. I have confirmed that the related action will show up if visibility =true(). I have also tried the simple expression of rf!status ="Completed", and this did not set the visibility to true even though status was Completed.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
hrishikeshd
over 8 years ago
Ideally expression (rf!status = "Complete") should work, additional if block is not required, since equality operator in itself returns a boolean
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Tim
Certified Lead Developer
over 8 years ago
Have you checked the quality of your data? Could the underlying status field contain any whitespace?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
brianc
over 8 years ago
The quality of the data has been checked. There are no whitespaces. The value coming from Status is "Completed" and I am comparing it to "Completed".
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
saravanana
over 8 years ago
Try to maintain constants for storing as well retrieve status field. So that you can avoid text comparison. And , no need if, = returns true or false.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
hrishikeshd
over 8 years ago
Another point to check is whether the loggedInUser trying to view the related action, must not be having security privileges on the process model underlying the related action.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
brianc
over 8 years ago
Saravanana I am actually using constants to do the compare, I put the text value so people reading would know the value I was pulling.
I have tested viewing the related action with a single user when visibility is =true() and with the expression. The user could see the related action when visibility was set to true, but not with the expression.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
saravanana
over 8 years ago
If you are using constant, only reason visibility fails would be all records status would be not complete.. we used text comparison in Related Action visibility.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
brianc
over 8 years ago
Saravanana may you provide a screenshot of your working text comparison?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
>