Hello.

I recently bought your Plugin. Looks great, but I have a problem.

Previously I used DBVIEW and had a query to select the number of records within ranges of years

Year      Number

<1982           2

1982-1985   5

etc..

I use this query:

SELECT "<1982" AS Lidsinds
, COUNT(meta_value) AS Aantal
FROM wp_usermeta
WHERE meta_key = 'lidsinds' and substr(meta_value,7,4) BETWEEN 0 AND 1981
GROUP BY Lidsinds
UNION ALL
SELECT "1982-1985" AS Lidsinds
, COUNT(meta_value) AS Aantal
FROM wp_usermeta
WHERE meta_key = 'lidsinds' and substr(meta_value,7,4) BETWEEN 1982 AND 1985
GROUP BY Lidsinds
UNION ALL
SELECT "1986-1990" AS Lidsinds
, COUNT(meta_value) AS Aantal
FROM wp_usermeta
WHERE meta_key = 'lidsinds' and substr(meta_value,7,4) BETWEEN 1986 AND 1990
GROUP BY Lidsinds

etc...

I works fine.

With wpDatatables this is not possible. I get the error:

cannot calculate position of (meta_value) within UNION SELECT user_id,'<1982', COUNT(meta_value) FROM wp_usermeta WHERE meta_key = 'lidsinds' and substr(meta_value,7,4) BETWEEN 0 AND 1981 GROUP BY Lidsinds

Please help.

Best regards, Kees

Hi Milan.

I use tabel wp_usermeta with fields: meta_key="Lidsinds" and meta_value is a date in string format. 

The selection is:

SELECT "<1982" AS Lidsinds
, COUNT(meta_value) AS Aantal
FROM wp_usermeta
WHERE meta_key = 'lidsinds' and substr(meta_value,7,4) BETWEEN 0 AND 1981
GROUP BY Lidsinds
UNION ALL
SELECT "1982-1985" AS Lidsinds
, COUNT(meta_value) AS Aantal
FROM wp_usermeta
WHERE meta_key = 'lidsinds' and substr(meta_value,7,4) BETWEEN 1982 AND 1985
GROUP BY Lidsinds
UNION ALL
SELECT "1986-1990" AS Lidsinds
, COUNT(meta_value) AS Aantal
FROM wp_usermeta
WHERE meta_key = 'lidsinds' and substr(meta_value,7,4) BETWEEN 1986 AND 1990
GROUP BY Lidsinds
UNION ALL
SELECT "1991-1995" AS Lidsinds
, COUNT(meta_value) AS Aantal
FROM wp_usermeta
WHERE meta_key = 'lidsinds' and substr(meta_value,7,4) BETWEEN 1991 AND 1995
GROUP BY Lidsinds
UNION ALL
SELECT "1996-2000" AS Lidsinds
, COUNT(meta_value) AS Aantal
FROM wp_usermeta
WHERE meta_key = 'lidsinds' and substr(meta_value,7,4) BETWEEN 1996 AND 2000
GROUP BY Lidsinds
UNION ALL
SELECT "2001-2005" AS Lidsinds
, COUNT(meta_value) AS Aantal
FROM wp_usermeta
WHERE meta_key = 'lidsinds' and substr(meta_value,7,4) BETWEEN 2001 AND 2005
GROUP BY Lidsinds
UNION ALL
SELECT "2006-2010" AS Lidsinds
, COUNT(meta_value) AS Aantal
FROM wp_usermeta
WHERE meta_key = 'lidsinds' and substr(meta_value,7,4) BETWEEN 2006 AND 2010
GROUP BY Lidsinds
UNION ALL
SELECT "2011-2016" AS Lidsinds
, COUNT(meta_value) AS Aantal
FROM wp_usermeta
WHERE meta_key = 'lidsinds' and substr(meta_value,7,4) BETWEEN 2011 AND 2016
GROUP BY Lidsinds

It should produce:

Hope this is enough information. For the time being A created a view in phpadmin and call that one in wpDataTables

By the way. I tested everything in a local wordpress instance. Sometimes after saving, nothing happend and I had to open or create the datatable again to proceed.   

I created a datatable today in my productive site and after saving the site opened an empty screen and I could not do anything anymore. My wp-admin was also unavailable. I tried to rename the plugin directory in filezilla,  but this was not possible. I thing the plugin had the directory locked. Does this sound familiar.

best regards, Kees Bond.

Hi Milan.

I found another issue. When I edit a line from a table, the text "Edit Entry" at the top is not translated. And at the bottom the text "Apply and new " is not translated too. I would prefer to use "Opslaan" instead of "Ok". See attachments

Best regards, Kees