Hi Markus,

Thank you for your interest in wpdatatables.

Unfortunately at the moment that is not possible with built-in features of plugin. We have this feature on our road map and it will be implemented in one of the next updates.

Thank you for your suggestion. We carefully follow customers requirements and try to implement most of them if they appear in requests from time to time, so we will add to our idea list and look into some possible solutions on plugin side in the future.

We constantly strive to make our product better, and deliver the most value for our end users - so please share your feedback on what features you need in next versions link.

Best regards.

Hello Markus.

I'm glad to tell you that we implemented single-cell shortcodes in the meantime.

Please check out our documentation and feel free to ask if you have any questions or concerns.

Hi again Markus.

The column ID from your screenshot is "roles":

The row ID should be 134

So, try this:

[wpdatatable_cell table_id=18 row_id="134" column_key="roles"]

Hi Markus,

Could you please clarify some additional details of your use-case for us, it seems we maybe did not fully understand exactly what you wish to present in this single cell value?

On your Screenshots, we can see you have an SQL Query based Table, and you are using the "group by" statement, which might be part of the issue, but also in the Table itself on your Screenshots, we do not see any cell value as "224", and if we understand you are trying to present some total number of Customers that are logged into a Portal, with result of 224?

Can you tell us do you have that result (224) somewhere in a Table cell - did you maybe create a Formula Column or a Calculation Function as SUM?

If we can also get remote access to check your Table back-end, but please show us more details how you are calculating to draw the total number of Customers on your Table?

Please provide me a temporary WP-admin (administrator) user for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue. 

We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course, we do not provide login data to third parties. 

You can write credentials here just check PRIVATE Reply so nobody can see them except us.

Thank you.

Hi Markus,

My apology, i re-read everything, so if you just need to load the number 134 from the Column 

 Anzahl :

In that case, can you try the Single Cell Shortcode like this :

[wpdatatable_cell table_id=18 row_id="134" column_key="Anzahl"]

Let us know if that works - If not, please clarify if we understood, do you need to draw that value "134" from Column Anzahl, or do you need to draw some Total/calculated number from other part of your Table.

If you show us any screenshots or a Video that has any sensitive Data, just make sure to check the reply as PRIVATE, for safety reasons.

Thank you.

Hi Markus,

Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.

-

I think the quickest will be if i can take a look at your back-end configuration for this table, please?

Please provide me a temporary WP-admin (administrator) user for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue. 

We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course, we do not provide login data to third parties. 

You can write credentials here just check PRIVATE Reply so nobody can see them except us.

And point me to the Table ID.

Thank you.

Hello Markus.

Milos is out sick, so I'll take over this ticket. Please give me some time to go over your correspondence and test everything. I'll get back to you as soon as I can.

Hi again Markus.

We were able to find the correct single-cell shortcode. It's this:

[wpdatatable_cell table_id=2 column_key="Anzahl" column_id="id" column_id_value="9" sort="1"]

Since there's no row_id, a custom column needs to be used.

It's mentioned in our documentation, example 2:

• table_id – is the ID of your DataTable
• column_key – is the name of the column from which the single-cell value will be pulled (origin header* of the column)
• column_id – is the name of the column that contains unique values (origin header* of the column - in your case "id")
• column_id_value – is the value from column_id column (in your case - "9")
• sort – by default it is set to “1” (sorting table is automatically enabled). If you need to fetch data from a source without sorting, you will provide the value “0”

* origin header – you can see it in the wpDataTables configuration page when you open the column settings panel by clicking on the “Column settings” button  or by clicking the “Column list” button above the table from where you can open column configuration for each column.