Hacker News Reader

Oh, that's an old version tag. Keep an eye out for a new version in a few hours, the app should offer you a chance to update.

Regarding FK's we let you filter or group by any attribute on either the table you're working with or any attribute on an FK in that table. Are you using the sample DB or your own?

View on HN

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...

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