Hacker News Reader

Bug report -- hitting 'Help' in the OSX app leads to: http://www.metabase.com/docs/v0.12.0-test, which 404s

I was trying to figure out how to get it to walk a FK/do a join so I could filter based on the name of the foreign entity instead of the ID.

View on HN

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?

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