How to select single field from Data Master?

Lindsay Beckworth shared this problem 11 months ago
Known

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!

Comments (5)

photo
2

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 expression (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:

92b4a6c0b86ec56b9bdf3970417e7c16

..

.

2.) Prototype Layout:

bda38a92e4b26571d2011b559d8c7d59

..

.

3.) Button Action:

44e066915d5085184207311582558759

..

.

4.) Button Action Detail:

6d9a7c0453453c28829852810e015b0e

..

.

5.) Button Action Expression - Inputs Highlighted:

f1d9115df2f437f83f90591150018b98

..

.

6.) Button Action Expression - Data Master and Data Master Attributes Highlighted:

4dd3df5a36f30b22966dd6451817febc

..

.

7.) Search 1:

b304b42d8d422e5178df67759125ea99

.

.

.

8.) Search 2 (Different Last Name and Last Four from Search 1):

efd4f75f2bf3724234ed8af58a247bec

.

.

.

9.) Search 3 (Same Last Name, but Different Last Four from Search 1):

d0bce1ffeb43a6f1cd9545ae7e484265

photo
1

Thank you so much for your contribution!


Best,

photo
1

Sure!

photo
photo
1

Thank you very much for your help! Happy Turkey Day! =)

photo
2

To you too! Happy to help.

photo