charlesgodwin

Everything I included in the first email should be inside the outer braces.

try this. I deleted one nest of brackets

  “language”: {
     “processing”: “Loading the Diary Entries”,
“loadingRecords”: “Loading the Diary Entries”
  }

Yup. There many strings you can change. They are shown here.
https://datatables.net/reference/option/language

You can set them in publications Advanced options. Here’s an example from one of my publications

	"language": {
		 "infoFiltered": "",
		 "loadingRecords" : "Loading page....",
		 "processing": "Processing... This could take a while.",
		 "infoEmpty": "Select a search value first.",
		 "zeroRecords" :"No records to display. Modify or define search value(s)."
	 }

• This reply was modified 2 years, 4 months ago by charlesgodwin.

Thanks. I’ll start research. But… If you’re looking for an enhancement, this is one that sticks to the core of the product.

Thanks @kimmyx The first link you provide suggests that there is a default dropdown view of values in table for a column. That’s all I’m looking for. I can’t find a way to define it. I found this to illustrate what I’m looking for.

Add condition on Data location and Condition of Equals or Not and you’ll see Values becomes a drop down. If it isn’t a quick answer, let me know, and I’ll get busy doing more research.

• This reply was modified 2 years, 4 months ago by charlesgodwin.
• This reply was modified 2 years, 4 months ago by charlesgodwin.

WPDA, PHP and MySql have issues with some special characters. I deal with it by avoiding anything except A-Z (both cases) and ‘_’ (underscore)

Try changing your select count(ID) to select count(ID) as count_ID
and your column in publication to count_ID

• This reply was modified 2 years, 4 months ago by charlesgodwin.

I can’t find 5.2 documentation. Switch to 5.7 or 8.0, for your own sanity.

Thanks again. I found your solution too restrictive for our purpose (not displaying enough text for normal cases). But you pointed me in the right direction.

We are using this, and injecting it with Code Manager, another fabulous Passionate Programmer offering.

#master_catalogue14 .description{
  overflow:hidden;
  display: -webkit-box;
  -webkit-line-clamp: 6;
  -webkit-box-orient: vertical;
}

Thanks @kimmyx

If it works I’ll inject it code-manager. ??

I wonder if you aren’t expecting too much of WPDA? There is another excellent plugin named Gravity Forms. It has some excellent add ins that interact with MySQL.

you could create a form, pre-populate it with data, validate the form data with the pre-existing data (called conditional expressions) and then, if the form is correct it will update your databases and optionally send emails to any number of recipients. It is very powerful and manages “fill-in the form” well

It’s not free but well worth the license fee for building great front-ends. It can even collect payment.

https://www.gravityforms.com/

I have posted my python cleanup tool here.

I have a command line tool that does a bunch of things to sanitize a CSV file for MySQL loading. strip blank columns and rows, column name fixup etc.
One of the things it does is splits the CSV file into 200,000 rows per file.

If I find the time I may publish it as a gist (github) file. It’s written in python.

It’s also supported by MariaDB https://mariadb.com/kb/en/events/

I think it will only run SQL statements.

MySQL also supports an EVENT type which can run on a schedule. It can be multiple SQL statements.

https://dev.mysql.com/doc/refman/8.0/en/event-scheduler.html

You could consider VIRTUAL … generated fields. They don’t take space but produce results for viewing.
Here’s the documentation

Here’s an example I use to provide an alternative value for a column. I don’t search it but I display it. This is just a code fragment as example. You cloud generate a display column with CSS for each condition.

description` text,
short_description varchar(255) GENERATED ALWAYS AS (
(
case
when isnull(description) then ‘N/A’
when (char_length(description) = 0) then ‘N/A’
when (char_length(description) < 255) then description
else concat(substr(description, 1, 238), ‘…See details’)
end
)
) VIRTUAL`

• This reply was modified 2 years, 11 months ago by charlesgodwin.

Have you considered making a view from your query and using it in your publication? I don’t know your query so I can’t recommend a district solution.