Filter on relation solution?

Data Service
1

Hi I have the following schema.

image_2021-03-20_040831
image_2021-03-20_0408311208×792 70.3 KB

How do I filter only Cities from “tblCity” based on the objectId in “tblState”?

For example tblState.objectId = ‘TX’

I read this previous thread and is this something you are working on?

Unfortunately this didn’t worked in your Data Browser SQL Window.

sql_where_on_relation_1
sql_where_on_relation_13482×614 107 KB

Is it possible to just build a 2 table Data View with tblState and tblCity and run a dynamic filter on tblState.objectId ? Thanks!

2

I think I figured out the best workaround would be to never try to modify a objectId with a custom value since as a general rule you’re never supposed to expose any primary key to the world. I guess this is the case even if I have a Zip Code table and initially wanted to have the objectID also be the actual Zip Code.