How do I apply a filter to a select statement?

Holli Graham shared this question 7 years ago
Answered

I've tried every combination I can think of, but nothing is working. I have a variable that I'm carrying over from a previous screen, and I'm trying to then set another variable on page load on another screen based on that first variable from a data master. In essence, doing a simple select SQL statement... SELECT ColumnB FROM DataMaster WHERE ColumnA = VariableA. I'm trying to do this using a calculated set value on page load. I've tested it without the filter, and I get all the values. I've also test the variable, and it shows up on that page as well, so I know it's being carried over. The following image has been my best guess. Thanks for your help.


001d535d49bd55f97c872dd939b33081

Comments (5)

photo
1

I've been fooling with this for a while. Suddenly, that expression is working now. I have no idea why it wasn't working earlier.

photo
1

Guess I can't answer my own question? I don't see anywhere to mark this as answered.

photo
1

Good to know you solve it. You're becoming an expert on Prototyper so fast!

photo
1

Thanks for the screenshot; I've been trying to figure this out for about an hour : )

photo
1

:)