How to change the view of foreign keys from number to the name in the collection | Directus | Page 1

fresh holly Feb 9, 2023, 11:54 AM

#

I'm using v9.22.3.
In the table view I can't choose the name of a partner key, but only PK.
Maybe some one know what is wrong, because previously everything was ok

sharp ether Feb 9, 2023, 11:56 AM

#

Try to reset the preset

fresh holly Feb 9, 2023, 12:01 PM

#

@sharp ether not sure I got how to do this

sharp ether Feb 9, 2023, 12:02 PM

#

It's on directus_presets table

fresh holly Feb 9, 2023, 12:16 PM

#

@sharp ether by reseting you meant delete and create again?

sharp ether Feb 9, 2023, 12:16 PM

#

yeaah, delete a preset and reselect your column on table layout

fresh holly Feb 9, 2023, 12:24 PM

#

@sharp ether it doesnt help unfortunately, because in preset I also cant see the dropdown with all fields from foreign collection

fresh holly Feb 9, 2023, 1:05 PM

#

@vivid gale can you please look at this?

rugged nacelle Feb 9, 2023, 3:22 PM

#

Please don't randomly ping users!

#

You need to adjust the display setting of this field, in Settings -> Data Model

fresh holly Feb 9, 2023, 5:31 PM

#

@rugged nacelle I'm sorry, I won't do this again.
your solution doesn't work. 'Partner' column(on the screenshot) is a foreign key and behind the name of the column there is no grey dot which indicates that it is a FK. Also in '+' this column isn't a dropdown so I can't see all fields related to the FK.

In Display settings I can add a template to the each row, but I need to have an opportunity to add 'foreign' columns to the collection view

Maybe you can suggest something else? Because I don't understand what to change in Setting(nothing works)

rugged nacelle Feb 9, 2023, 6:37 PM

#

fresh holly <@437606273635188760> I'm sorry, I won't do this again. your solution doesn't wo...

No problemo!
I see, that's indeed a bit strange... Would you be able to share your collection set-up?

fresh holly Feb 9, 2023, 7:24 PM

#

@rugged nacelle sure,
is this enough? do you need something else?

bright kernel Feb 10, 2023, 9:31 AM

#

whats inside your display?

fresh holly Feb 10, 2023, 9:35 AM

#

#

I have tried to chose both but no affect

#

@bright kernel is it possible that some default settings went wrong?

#

if I choose Related Values and then Field Name, I will be able to name, but not all fileds from Foreign Collection

rugged nacelle Feb 10, 2023, 10:01 AM

#

Thanks for the screenshots! I wasn't able to reproduce this on my end.

#

Is "am_accordion" a group?

#

Have already tried to restart the instance?

fresh holly Feb 10, 2023, 10:18 AM

#

yes, am_accordion is a group, but nothing changes if I drag the field out fro it
I will try to restart, thanks a lot
I will let you know if it helps

fresh holly Feb 10, 2023, 4:01 PM

#

@rugged nacelle
to cut the long story short - directus_relations table were empty
suppose it happend while migrating directus image

rugged nacelle Feb 10, 2023, 4:02 PM

#

Huh, okay 🙈 So you've been able to resolve this now?

fresh holly Feb 10, 2023, 4:03 PM

#

yeah, I just populated needed rows manually
thanks for your help)

rugged nacelle Feb 10, 2023, 4:04 PM

#

Okay, great! I'm very glad it's working now 👌

#

You're welcome! And thanks for reporting back!

#

If you're able to reproduce this and you're sure that this has been caused by an issue from Directus' side, please open a bug report over here: https://github.com/directus/directus/issues

#

Otherwise, I assume it was a one-time problem and therefore consider it resolved

#How to change the view of foreign keys from number to the name in the collection