How to select single field from Data Master?
I have a small Data Master:
fullName
lastName
lastFour
I want to store the full name as a variable.
Basically:
SELECT fullName FROM DataMaster WHERE lastName == lastNameInput && lastFour == lastFourInput
I'm currently not sure how to do this. Help would be very much appreciated!
Hi Lindsay,
To do what you're asking, you would create an event attached to a button (or whatever element you are using to trigger the search). The event would be an "On Tap" "Set Value" event that would take the value of your select a single "fullName") and assign it to whatever you want to set it to (e.g. a text box, a variable, etc.). The event expression would be a "Calculated" expression, and it's set up pretty much how your SELECT statement above is constructed, it just needs to be in the correct JIM syntax, which is what I'm assuming you're looking for.
Below are screenshots of how I would build the expression. There are also screenshots showing the results of a few test searches. I've also attached the prototype used for these screenshots. To run the prototype, simply change the ".rar" extension to ".vp". It is not a compressed file.
Hope this helps!
..
.
1.) Customers Data Master:
..
.
2.) Prototype Layout:
..
.
3.) Button Action:
..
.
4.) Button Action Detail:
..
.
5.) Button Action Expression - Inputs Highlighted:
..
.
6.) Button Action Expression - Data Master and Data Master Attributes Highlighted:
..
.
7.) Search 1:
.
.
.
8.) Search 2 (Different Last Name and Last Four from Search 1):
.
.
.
9.) Search 3 (Same Last Name, but Different Last Four from Search 1):
Hi Lindsay,
To do what you're asking, you would create an event attached to a button (or whatever element you are using to trigger the search). The event would be an "On Tap" "Set Value" event that would take the value of your select a single "fullName") and assign it to whatever you want to set it to (e.g. a text box, a variable, etc.). The event expression would be a "Calculated" expression, and it's set up pretty much how your SELECT statement above is constructed, it just needs to be in the correct JIM syntax, which is what I'm assuming you're looking for.
Below are screenshots of how I would build the expression. There are also screenshots showing the results of a few test searches. I've also attached the prototype used for these screenshots. To run the prototype, simply change the ".rar" extension to ".vp". It is not a compressed file.
Hope this helps!
..
.
1.) Customers Data Master:
..
.
2.) Prototype Layout:
..
.
3.) Button Action:
..
.
4.) Button Action Detail:
..
.
5.) Button Action Expression - Inputs Highlighted:
..
.
6.) Button Action Expression - Data Master and Data Master Attributes Highlighted:
..
.
7.) Search 1:
.
.
.
8.) Search 2 (Different Last Name and Last Four from Search 1):
.
.
.
9.) Search 3 (Same Last Name, but Different Last Four from Search 1):
Thank you very much for your help! Happy Turkey Day! =)
Thank you very much for your help! Happy Turkey Day! =)
Replies have been locked on this page!