I have an expression that outputs the string from a custom field, E1. I have a reader that reads a custom object with two object groups, role and group, with 4 object records. I would like to compare the output of E1 to see if there is a match to any of the 4 object record role entries. If there is a match I would like to output the group entry of the matching object record something like this: E2(if E1.result == R1.role, output R1.group as E2.result) Is this possible or is there an easier way to accomplish this?
Question
create an expression to compare output
+3+3Is there a way to take E1.result and match it to a custom object record entry object group, role in this case, to find a match? If there is a match with E1.result in any of the role object records, take that object record’s 2nd value, group int his case, and output a string of the matching value.
custom object:
| id | role | group |
| 1 | A | # |
| 2 | B | $ |
E1.result = B
E1 matches value B in role column, row id 2
output string $ from row id 2, group column.
E2.result = $
Is this possible?
+14phongshader wrote:
Is there a way to take E1.result and match it to a custom object record entry object group, role in this case, to find a match? If there is a match with E1.result in any of the role object records, take that object record’s 2nd value, group int his case, and output a string of the matching value.
custom object:
| id | role | group |
| 1 | A | # |
| 2 | B | $ |
E1.result = B
E1 matches value B in role column, row id 2
output string $ from row id 2, group column.
E2.result = $
Is this possible?
CO Reader are always exakt value. there are no contains.
Is it the custom field a free text field and if the requester types in the word foo you like to check the custom object ?
Reply
Join the Community
Already have an account? Login.
Sign in to the Community
No account yet? Create an account.
Social Login
Login with LinkedInor use your username
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.