I have a table dim_date which has a guid as it’s primary key and a date field.
I have set the date field up as entity name.
I have another table with a field, date_uuid, which references dim_date.
However, when setting up display values for the date_uuid field, I cannot select the date field?
I can only select fields in dim_data of type numeric or string?
Hi, not sure if its related but it reminds me of this issue:
entity and foreign key fields are not usable anymore in metabase query builder as fields. And sadly this behaviour does not get refreshed after you remove the join
I am not sure this is the same? By the way, my tables are not set up wth foreign key constraints in the database (postgresql) - the foreign key relationship is only defined in metabase.