I have a table 'jurisdiction' with columns 'code' (string) and 'name' (string).
I have a second table 'detail' which has a column 'test' that is specified as a multi-value selectbox whose data source as 'Use values from another wpDataTable'. I've specified the 'Configure relation' to be:
Source wpDataTable: jurisdiction
Display value: name
Store value: code
So I expect that this allows me to have a multi-value selectbox available when editing column 'test' in table 'detail' and store the value(s) that is one or more 'code' value selected from the dropdown into field 'test'?
Problem 1
It appears that even if my 'code' entries are unique I must choose 'wdt_id' as the store value? If this is a limitation of the system then I understand (but it is not very flexible).
Problem 2
More worryingly when I drop and create the column 'test' and specify its type as 'multi-line selectbox' I see that the Editor Input Type is identified correctly as 'Multi-value selectbox'
I then try to set up the values for the column as a foreign key by clicking on 'Configure Relation' and at this point the 'Use values from another wpDataTable' dialog appear with a spinning circle and never stops - which I believe to be a bug. This does not happen if I specify a list of values rather than a table (but this is not what I want)
I have now spent nearly two days trying to figure Problem 2 out and would really appreciate some help or a refund.
There is a explanation in our documentation how to use Foreign key on this link.
You will find that the only limitation is that the only possible editor input type for such columns is the single-value selectbox, as the options are limited with what the remote table contains.
When you configure relations like is describe in our documentation you should not have any problems. There is some issue with that modal if you are using Firefox. Can you do that in Chrome and see do you still have issue with this modal?
I have a table 'jurisdiction' with columns 'code' (string) and 'name' (string).
I have a second table 'detail' which has a column 'test' that is specified as a multi-value selectbox whose data source as 'Use values from another wpDataTable'. I've specified the 'Configure relation' to be:
Source wpDataTable: jurisdiction
Display value: name
Store value: code
So I expect that this allows me to have a multi-value selectbox available when editing column 'test' in table 'detail' and store the value(s) that is one or more 'code' value selected from the dropdown into field 'test'?
Problem 1
It appears that even if my 'code' entries are unique I must choose 'wdt_id' as the store value? If this is a limitation of the system then I understand (but it is not very flexible).
Problem 2
More worryingly when I drop and create the column 'test' and specify its type as 'multi-line selectbox' I see that the Editor Input Type is identified correctly as 'Multi-value selectbox'
I then try to set up the values for the column as a foreign key by clicking on 'Configure Relation' and at this point the 'Use values from another wpDataTable' dialog appear with a spinning circle and never stops - which I believe to be a bug.
This does not happen if I specify a list of values rather than a table (but this is not what I want)
I have now spent nearly two days trying to figure Problem 2 out and would really appreciate some help or a refund.
Many thanks
Alan Simmonds
Hi Alan,
Thank you for your purchase.
There is a explanation in our documentation how to use Foreign key on this link.
You will find that the only limitation is that the only possible editor input type for such columns is the single-value selectbox, as the options are limited with what the remote table contains.
When you configure relations like is describe in our documentation you should not have any problems. There is some issue with that modal if you are using Firefox. Can you do that in Chrome and see do you still have issue with this modal?
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables