Date fields not displayed on custom remapping

[lbalves]

Note: I didn't find an opened issue documenting this bug.

• Your browser and the version: Chrome 64.0.3282.186 (Official Build) (64-bit)
• Your operating system: OSX 10.13.3
• Your databases: MySQL and PostgreSQL (but can be reproduced on Sample Dataset as well)
• Metabase version: 0.28.0
• Metabase hosting environment: Linux EC2
• Metabase internal database: H2

As stated by the docs, "Foreign key remapping lets you swap out a foreign key’s values with the values of any other field in the connected table.". But date fields are not displayed on the FK's field list. That way, I can not select them.

Steps to reproduce the error using Sample Dataset:

1. Go to Metabase Admin
2. Select the "Sample Dataset" database
3. Select "Orders" table
4. Scroll to "User ID" field and click on the gear for advanced config
5. On "Display values" section, ensure "Use foreign key" is selected and try to find "" on the field's list (only string, numeric and location fields are displayed).
6. Go back to table's listing, select "People" table and check that there are date fields like "Birth Date" and "Created At"

⬇️ Please click the 👍 reaction instead of leaving a +1 or update? comment

[salsakran]

why do you want to display a date instead of an FK?

[lbalves]

@salsakran In my particular case, I'm working on a BI database (not a production database). There, I have a date's dimension table and a transaction's fact table. For each transaction I have a date FK pointing to the date table. In that scenario, I want to display the transaction date instead of the date ID. Is that clear?

[lp-lima]

I'm in the very same situation. Very interested on this.

[lp-lima]

I'm also having trouble with Time fields, in MySQL. Unlike "Date" fields, they will show up in the list, but, after selected, nothing changes - the original value is still shown. Is this worth another issue?

[luiizfenix]

+1 on this, im on mysql and have a table for dates, i dont want to display the date id, i need it to show the actual date but still it doesnt show date/time fields on custom remmaping.

Please check on this, if this is a bug, or else it can be a feature request.

Hope someone pay attention to this.

Best Regards,

[kafran]

I'm also facing the same problem. I have a fact table and a date dimension and I can't show the Date type column value from the dimension, only the String and the Number types are showed on.

I'm Running MetaBase 0.32.4; does someone knows if this was fixed already?

[SebastianDonhauser]

I'm Running MetaBase 0.32.4; does someone knows if this was fixed already?

Hi, same problem with Metabase v0.35.4. It would be really great if this will be fixed in one of the next versions.