Hola, necesito que el "Display value" que muestra un "Use values from another wpDataTable" sean varios valores de una consulta que proviene de dos tablas diferentes, concretamente los valores "entidad" y "fecha"
SELECT WXwhIto_wpdatatable_24.`entidad`, WXwhIto_wpdatatable_14.`fecha` FROM WXwhIto_wpdatatable_14 LEFT JOIN WXwhIto_wpdatatable_24 ON WXwhIto_wpdatatable_14.`entidad` = WXwhIto_wpdatatable_24.`wdt_ID`
Sólo puedo seleccionar un valor para "Display value" y necesito que aparezcan dos.
Please note that the official support language is English, and we have to use Google Translator to try and understand other languages. Since a lot can be lost in translation, we apologize in advance if we misunderstood some segments of your message, and we also ask you to please translate your future messages to English.
Thank you for your understanding.
I am sorry to disappoint you, but this is not possible with any of our current Plugin's capabilities.
At the moment, it is as you found - our Foreign Key Column feature can only work for a 1 to 1 relation.
In your use-case, you need a more 'custom' relation which is something like " 1 to many" relation.
It is not possible to achieve that with our Foreign Key Built-in feature, since you can only choose 1 Store Value and 1 Display Value.
This is why we have that limited to a "Single Value selectbox", while for some other editable Columns ( which are not Foreign Key) you can have "multiSelectBox".
At this time, we don't have a built-in feature to achieve this, but you can suggest it to our developers - they will do their best to make a solution in the future.
to see if someone may be already suggested this feature. If you can't see it, feel free to add your suggestion there, and as more people vote, the feature will move higher on the priority list.
You can certainly follow our changeLog page if you'd like ( it is also available in the plugin dashboard), where we state any changes/new features/bug fixes during updates;
and our newsletter, so you're informed about new features, bug fixes, freebies, etc.
-
2. If you use SQL JOIN function in our SQL Tables - you will not be able to edit that data.
Hola, necesito que el "Display value" que muestra un "Use values from another wpDataTable" sean varios valores de una consulta que proviene de dos tablas diferentes, concretamente los valores "entidad" y "fecha"
SELECT WXwhIto_wpdatatable_24.`entidad`,
WXwhIto_wpdatatable_14.`fecha`
FROM WXwhIto_wpdatatable_14
LEFT JOIN WXwhIto_wpdatatable_24
ON WXwhIto_wpdatatable_14.`entidad` = WXwhIto_wpdatatable_24.`wdt_ID`
Sólo puedo seleccionar un valor para "Display value" y necesito que aparezcan dos.
¿Es posible?, gracias
Hi Jose,
Please note that the official support language is English, and we have to use Google Translator to try and understand other languages. Since a lot can be lost in translation, we apologize in advance if we misunderstood some segments of your message, and we also ask you to please translate your future messages to English.
Thank you for your understanding.
I am sorry to disappoint you, but this is not possible with any of our current Plugin's capabilities.
At the moment, it is as you found - our Foreign Key Column feature can only work for a 1 to 1 relation.
In your use-case, you need a more 'custom' relation which is something like " 1 to many" relation.
It is not possible to achieve that with our Foreign Key Built-in feature, since you can only choose 1 Store Value and 1 Display Value.
This is why we have that limited to a "Single Value selectbox", while for some other editable Columns ( which are not Foreign Key) you can have "multiSelectBox".
At this time, we don't have a built-in feature to achieve this, but you can suggest it to our developers - they will do their best to make a solution in the future.
Please feel free to search on our suggestions page,
to see if someone may be already suggested this feature. If you can't see it, feel free to add your suggestion there, and as more people vote, the feature will move higher on the priority list.
You can certainly follow our changeLog page if you'd like ( it is also available in the plugin dashboard), where we state any changes/new features/bug fixes during updates;
and our newsletter, so you're informed about new features, bug fixes, freebies, etc.
-
2. If you use SQL JOIN function in our SQL Tables - you will not be able to edit that data.
As we pointed out in this Editing Documentation.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables