Hacker News Reader

Maybe I'm an idiot, but here's me selecting from a customer table. Customers have a FK to 'address' via ship_address_id. I want to filter on address.state, but can't figure out how to do it. 'state' is not an available field in the filters and I can't seem to drill into any of the FK entities.

Screenshot: https://s3.amazonaws.com/uploads.hipchat.com/57670/394271/Wt...

View on HN

it looks like the field isn't marked as an FK in our semantic model. Could you go the admin, and click on "Metadata" and check to see what "special type" that field is marked at? If it's not "Foreign Key" you can set it to that and see if you can filter by linked fields.

What type database are you pointing this to? Do you have FKs/constraints set?

Reply on news.ycombinator.com