2. PHPRunner General questions
  3. [SOLVED] Automatically hide foreign key fields in detail tables
This topic is locked
[SOLVED]

Automatically hide foreign key fields in detail tables

 		4/22/2024 9:44:10 AM
PHPRunner General questions
mbintex author

Hi at all,

give is for example a notes table that is via foreign keys related to addresses, buildings and flats.

The notes list is showing the note itself in the foreign key so that one know to which this note is related.

When the notes are shows as detail tables of course the foreign key field "Building" is not necessary when viewed from the Building master page.

Is there an easy way to programmatically hide the foreign key fields in the details list if the master page is present? And only hiding the corresponding foreign key, not all? How would I use getMasterRecord for this?

Or would it be better to have x list pages for the notes like notes_adress, notes_building etc. and delete the foreign key field there?
Sergey Kornilov admin 4/24/2024

This should be possible in general and results returned by getMasterRecord() function will give you an indication if details table is open in standalone mode or in the details mode.

However, we highly recommend avoiding this kind of use. Do not open the same table in both details and standalone mode, it may lead to some issues that will be extremely difficult to debug and fix. The recommended approach is to create a custom view of the details table and separate standalone and details modes.

mbintex author 4/24/2024

I am not using the same table in details and standolone mode.

I just don´t want to see the foreign key field of the master table when the details are shown.

getMasterRecord() gives me data from the master, but not the table name itself. I would have to know if the master is table a or b for hiding the corresponding foreign keys.
Sergey Kornilov admin 4/26/2024

Again, you are trying to build something the way that potentially is a source of an error like using the same table as details twice. Using a custom view here is a safer approach.

I do not have a complete information but you can probably read the master table name from the URL.
mbintex author 4/26/2024
but you can probably read the master table name from the URL

if getMasterRecord isn´t giving me the table name of the Master than this is probably the way to go. Thanks.