Adviata Ashrama

Namaste,

We are also facing the same issue. When updating data from the data explorer of WP-data-access, it is taking blank value as an empty string and not as NULL. Due to this, it does not allow us to update the record.

There are foreign Key constraints to avoid any empty Strings.

Here is my question:
How can we enter ‘NULL’ value using data explorer ?

Namaste Kim,

Sorry to bother you again.

You’re right. The error doesn’t always show up but it does appear quite often. The dataset is sourced from a view having approx. 19000 rows.

Unfortunately, I was not able to follow the troubleshooting guide but I am confident that the error is due to loading all rows at once.
How can we reduce the server load ?
Is there an option to load fewer rows in each request ?

Can you please suggest any other solution along those lines ?

Namaskar,

There are one standard table where few columns are hyperlinked.
We have set dynamic hyperlinks using Data explorer of WP Data access

Example:
Hyperlink for Title Column:
$$title$$

Hyperlink for Author column:
$$author_name$$

These columns are then selected in the Data publisher section like this:
wpda_hyperlink_0,wpda_hyperlink_1,subject,wpda_hyperlink_2,wpda_hyperlink_3

Allow ordering and sorting feature is also checked while saving the data publisher.

Thank you ! Thank you !
It worked ??