• State Not Answered
  • Replies 27 replies
  • Subscribers 7 subscribers
  • Views 5626 views
  • Users 0 members are here
Related Discussions
Home » Discussions » AI and Rules

Having trouble with a cascading dropdown. Basically, I have an editable grid tha

judym598
Certified Senior Developer
Having trouble with a cascading dropdown. Basically, I have an editable grid that has 3 dropdowns. The user selects a user from the first dropdown, assigns a role to the user with the second dropdown and assigns an area of expertise with the third dropdown. I got the rule to work with the first 2 dropdowns, but the choices presented with the third dropdown are dependent on the user selected in the first one. I have a query rule that brings back a list of expertises based on the userId. So I created a local!selectedUserId variable to use in my query rule that displays the dropdown list and added an a!save statement to update that local variable with the selected user id. But I get an error when I access this form because the query rule cannot find a userId. Here's the error I'm getting and I've attached my updated rule for the grid.
Expression evaluation error in rule 'ips_getexpertisebyuserid' (called by rules 'ips_assignuserrolesgr...

ips_assignUserRolesGrid_new.txt

OriginalPostID-170455

OriginalPostID-170455

  Discussion posts and replies are publicly visible

Parents
  • 0
    Certified Senior Developer
    You are correct with your assumption. expertiseId is of type integer and expertise is of type text. The query rule basically gets all data where 'userId = userId' and sorts by expertise. The actual data type has an id (a/I), userId, expertiseId, and expertise. So userId 4 may have 3 records (areas of expertise) in the table whereas userId 6 may have 2 areas of expertise. All users have at least 1 record in the table. Does that help?
Reply
  • 0
    Certified Senior Developer
    You are correct with your assumption. expertiseId is of type integer and expertise is of type text. The query rule basically gets all data where 'userId = userId' and sorts by expertise. The actual data type has an id (a/I), userId, expertiseId, and expertise. So userId 4 may have 3 records (areas of expertise) in the table whereas userId 6 may have 2 areas of expertise. All users have at least 1 record in the table. Does that help?
Children
No Data
© 2024 Appian. All rights reserved.
We want to hear from you! Submit a review on Gartner or G2.