I have a column which has a foreign key stored which points to a different table. For this column, the value NULL is allowed.
If I edit an entry of this table using wpDataTables, the value of this column is changed from NULL to 0. How can I change this so the value doesn't get changed?
The column settings are:
column type: string
Possible values for column: use values from another wpdatatable (foreign key)
Hi,
I have a column which has a foreign key stored which points to a different table. For this column, the value NULL is allowed.
If I edit an entry of this table using wpDataTables, the value of this column is changed from NULL to 0. How can I change this so the value doesn't get changed?
The column settings are:
column type: string
Possible values for column: use values from another wpdatatable (foreign key)
allow empty value: true
editor input type: single-value selectbox
cannot be empty: false
predefined values: (none selected)
Hi Johannes,
Thank you for your purchase.
Can you please tell me which table ID is it and the column name that you try to edit.
Best regards.
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
Hi Bogdan,
the column no longer exists at the moment due to a change of requirements. Sorry.
I cannot reproduce the issue with another table, so I guess we can close this.
Thank you anyways.