3 ms·
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
by numlocked 11y ago
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/WtZq4q72DOqKyO5/upload.png https://s3.amazonaws.com/uploads.hipchat.com/57670/394271/Wt...
- salsakran 11y agoit 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?
- deleted 11y ago[deleted]