How can I use values from another wpdatatable for filtering?
If I define another table in "Possible values for column", this values are not displayed in a table filter. Instead "Read from table on page load" values are displayed.
By default you should be able to see the values from the foreign key column. The column name from the original table should be different from the column name of the foreign key table as well to avoid conflicts.
How can I use values from another wpdatatable for filtering?
If I define another table in "Possible values for column", this values are not displayed in a table filter. Instead "Read from table on page load" values are displayed.
Hi Miroslav
Please check if the origin headers are the same for both tables - they should be different.
If you go to the column settings in the top left corner you will see origin header.
If "store value" or "display value" header is the same as in the table you want to configure the foreign key it will not function properly.
Do let us know if you need any further assistance.
Thank you for your response.
The headrs are different. See screenshot below.
What values are displayed in the filter if another table is set for possible column values?
Are this valus from other table or the values stored already in the table?
Hi Miroslav
By default you should be able to see the values from the foreign key column. The column name from the original table should be different from the column name of the foreign key table as well to avoid conflicts.