AndreB.'s Replies | WordPress.org

Forum Replies Created

Viewing 3 replies - 1 through 3 (of 3 total)

Forum: Plugins
In reply to: [WP Data Access – App Builder for Tables, Forms, Charts, Maps & Dashboards] Sum specific rows

Thread Starter AndreB.
(@andreb-1)

2 years, 9 months ago

Hi @kimmyx,

I had an syntax error. Now the code working perfect. It works with GROUP_CONCAT.

Thanks alot

Forum: Plugins
In reply to: [WP Data Access – App Builder for Tables, Forms, Charts, Maps & Dashboards] Sum specific rows
Thread Starter AndreB.
(@andreb-1)

2 years, 9 months ago
@kimmyx

I tried it with GROUP_CONCAT (). After pressing the Execute button, however, nothing happens.
The original code looks like this:
```
SELECT	zkzCrojUwoocommerce_order_items.order_id as 'Order_id'
,		zkzCrojUwoocommerce_order_itemmeta.meta_value as 'Vorname'
FROM	zkzCrojUwoocommerce_order_items
INNER JOIN zkzCrojUwoocommerce_order_itemmeta ON zkzCrojUwoocommerce_order_itemmeta.order_item_id = zkzCrojUwoocommerce_order_items.order_item_id
WHERE	(zkzCrojUwoocommerce_order_itemmeta.meta_key = 'vorname')
```
The Concat code looks like this:
```
SELECT	zkzCrojUwoocommerce_order_items.order_id as 'Order_id'
,		GROUP_CONCAT(zkzCrojUwoocommerce_order_itemmeta.meta_value) as 'Vorname'
FROM	zkzCrojUwoocommerce_order_items
INNER JOIN zkzCrojUwoocommerce_order_itemmeta ON zkzCrojUwoocommerce_order_itemmeta.order_item_id = zkzCrojUwoocommerce_order_items.order_item_id
WHERE	(zkzCrojUwoocommerce_order_itemmeta.meta_key = 'vorname')
```
Forum: Plugins
In reply to: [WP Data Access – App Builder for Tables, Forms, Charts, Maps & Dashboards] Sum specific rows
Thread Starter AndreB.
(@andreb-1)

2 years, 9 months ago
@kimmyx

I don’t want to combine two columns together, but rows.
After all, CONCAT can only combine columns.

I’ve read that it’s supposed to work with XML Path. However, I haven’t been able to do it yet.
- This reply was modified 2 years, 9 months ago by AndreB..

Viewing 3 replies - 1 through 3 (of 3 total)