Postgres 11

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

Help with an interesting Postgres question: Why isn't an Index Only Scan used on a partition accessed via the parent table?.

CREATE TABLE mytable (
    data text
);

INSERT INTO mytable VALUES
('[{"type": "text", "values": ["General"], "valueType": "string", "fieldType": "text", "value": ["General"], "customFieldId": "ee", "name": "customer_group"},{"type": "text", "values": ["Vienna"], "valueType": "string", "fieldType": "text", "value": ["Vienna"], "customFieldId": "eU", "name": "customer_city"},{"type": "text", "values": ["Mario"], "valueType": "string", "fieldType": "text", "value": ["Mario"], "customFieldId": "eZ", "name": "first_name"}, {"type": "text", "values": ["2019-06-30"], "valueType": "date", "fieldType": "text", "value": ["2019-06-30"], "customFieldId": "ea", "name": "created_at_date"}]'),
('[{"type": "text", "values": ["General"], "valueType": "string", "fieldType": "text", "value": ["General"], "customFieldId": "ee", "name": "customer_group"},{"type": "text", "values": ["Berlin"], "valueType": "string", "fieldType": "text", "value": ["Berlin"], "customFieldId": "eU", "name": "customer_city"},{"type": "text", "values": ["Otto"], "valueType": "string", "fieldType": "text", "value": ["Otto"], "customFieldId": "eZ", "name": "first_name"}, {"type": "text", "values": ["2019-06-28"], "valueType": "date", "fieldType": "text", "value": ["2019-06-28"], "customFieldId": "ea", "name": "created_at_date"}]');

SELECT * FROM mytable
2 rows affected



data


[{"type": "text", "values": ["General"], "valueType": "string", "fieldType": "text", "value": ["General"], "customFieldId": "ee", "name": "customer_group"},{"type": "text", "values": ["Vienna"], "valueType": "string", "fieldType": "text", "value": ["Vienna"], "customFieldId": "eU", "name": "customer_city"},{"type": "text", "values": ["Mario"], "valueType": "string", "fieldType": "text", "value": ["Mario"], "customFieldId": "eZ", "name": "first_name"}, {"type": "text", "values": ["2019-06-30"], "valueType": "date", "fieldType": "text", "value": ["2019-06-30"], "customFieldId": "ea", "name": "created_at_date"}]

[{"type": "text", "values": ["General"], "valueType": "string", "fieldType": "text", "value": ["General"], "customFieldId": "ee", "name": "customer_group"},{"type": "text", "values": ["Berlin"], "valueType": "string", "fieldType": "text", "value": ["Berlin"], "customFieldId": "eU", "name": "customer_city"},{"type": "text", "values": ["Otto"], "valueType": "string", "fieldType": "text", "value": ["Otto"], "customFieldId": "eZ", "name": "first_name"}, {"type": "text", "values": ["2019-06-28"], "valueType": "date", "fieldType": "text", "value": ["2019-06-28"], "customFieldId": "ea", "name": "created_at_date"}]


SELECT
    elems.*,
    data
FROM
    mytable,
    json_array_elements(data::json) elems


value
data


{"type": "text", "values": ["General"], "valueType": "string", "fieldType": "text", "value": ["General"], "customFieldId": "ee", "name": "customer_group"}
[{"type": "text", "values": ["General"], "valueType": "string", "fieldType": "text", "value": ["General"], "customFieldId": "ee", "name": "customer_group"},{"type": "text", "values": ["Vienna"], "valueType": "string", "fieldType": "text", "value": ["Vienna"], "customFieldId": "eU", "name": "customer_city"},{"type": "text", "values": ["Mario"], "valueType": "string", "fieldType": "text", "value": ["Mario"], "customFieldId": "eZ", "name": "first_name"}, {"type": "text", "values": ["2019-06-30"], "valueType": "date", "fieldType": "text", "value": ["2019-06-30"], "customFieldId": "ea", "name": "created_at_date"}]

{"type": "text", "values": ["Vienna"], "valueType": "string", "fieldType": "text", "value": ["Vienna"], "customFieldId": "eU", "name": "customer_city"}
[{"type": "text", "values": ["General"], "valueType": "string", "fieldType": "text", "value": ["General"], "customFieldId": "ee", "name": "customer_group"},{"type": "text", "values": ["Vienna"], "valueType": "string", "fieldType": "text", "value": ["Vienna"], "customFieldId": "eU", "name": "customer_city"},{"type": "text", "values": ["Mario"], "valueType": "string", "fieldType": "text", "value": ["Mario"], "customFieldId": "eZ", "name": "first_name"}, {"type": "text", "values": ["2019-06-30"], "valueType": "date", "fieldType": "text", "value": ["2019-06-30"], "customFieldId": "ea", "name": "created_at_date"}]

{"type": "text", "values": ["Mario"], "valueType": "string", "fieldType": "text", "value": ["Mario"], "customFieldId": "eZ", "name": "first_name"}
[{"type": "text", "values": ["General"], "valueType": "string", "fieldType": "text", "value": ["General"], "customFieldId": "ee", "name": "customer_group"},{"type": "text", "values": ["Vienna"], "valueType": "string", "fieldType": "text", "value": ["Vienna"], "customFieldId": "eU", "name": "customer_city"},{"type": "text", "values": ["Mario"], "valueType": "string", "fieldType": "text", "value": ["Mario"], "customFieldId": "eZ", "name": "first_name"}, {"type": "text", "values": ["2019-06-30"], "valueType": "date", "fieldType": "text", "value": ["2019-06-30"], "customFieldId": "ea", "name": "created_at_date"}]

{"type": "text", "values": ["2019-06-30"], "valueType": "date", "fieldType": "text", "value": ["2019-06-30"], "customFieldId": "ea", "name": "created_at_date"}
[{"type": "text", "values": ["General"], "valueType": "string", "fieldType": "text", "value": ["General"], "customFieldId": "ee", "name": "customer_group"},{"type": "text", "values": ["Vienna"], "valueType": "string", "fieldType": "text", "value": ["Vienna"], "customFieldId": "eU", "name": "customer_city"},{"type": "text", "values": ["Mario"], "valueType": "string", "fieldType": "text", "value": ["Mario"], "customFieldId": "eZ", "name": "first_name"}, {"type": "text", "values": ["2019-06-30"], "valueType": "date", "fieldType": "text", "value": ["2019-06-30"], "customFieldId": "ea", "name": "created_at_date"}]

{"type": "text", "values": ["General"], "valueType": "string", "fieldType": "text", "value": ["General"], "customFieldId": "ee", "name": "customer_group"}
[{"type": "text", "values": ["General"], "valueType": "string", "fieldType": "text", "value": ["General"], "customFieldId": "ee", "name": "customer_group"},{"type": "text", "values": ["Berlin"], "valueType": "string", "fieldType": "text", "value": ["Berlin"], "customFieldId": "eU", "name": "customer_city"},{"type": "text", "values": ["Otto"], "valueType": "string", "fieldType": "text", "value": ["Otto"], "customFieldId": "eZ", "name": "first_name"}, {"type": "text", "values": ["2019-06-28"], "valueType": "date", "fieldType": "text", "value": ["2019-06-28"], "customFieldId": "ea", "name": "created_at_date"}]

{"type": "text", "values": ["Berlin"], "valueType": "string", "fieldType": "text", "value": ["Berlin"], "customFieldId": "eU", "name": "customer_city"}
[{"type": "text", "values": ["General"], "valueType": "string", "fieldType": "text", "value": ["General"], "customFieldId": "ee", "name": "customer_group"},{"type": "text", "values": ["Berlin"], "valueType": "string", "fieldType": "text", "value": ["Berlin"], "customFieldId": "eU", "name": "customer_city"},{"type": "text", "values": ["Otto"], "valueType": "string", "fieldType": "text", "value": ["Otto"], "customFieldId": "eZ", "name": "first_name"}, {"type": "text", "values": ["2019-06-28"], "valueType": "date", "fieldType": "text", "value": ["2019-06-28"], "customFieldId": "ea", "name": "created_at_date"}]

{"type": "text", "values": ["Otto"], "valueType": "string", "fieldType": "text", "value": ["Otto"], "customFieldId": "eZ", "name": "first_name"}
[{"type": "text", "values": ["General"], "valueType": "string", "fieldType": "text", "value": ["General"], "customFieldId": "ee", "name": "customer_group"},{"type": "text", "values": ["Berlin"], "valueType": "string", "fieldType": "text", "value": ["Berlin"], "customFieldId": "eU", "name": "customer_city"},{"type": "text", "values": ["Otto"], "valueType": "string", "fieldType": "text", "value": ["Otto"], "customFieldId": "eZ", "name": "first_name"}, {"type": "text", "values": ["2019-06-28"], "valueType": "date", "fieldType": "text", "value": ["2019-06-28"], "customFieldId": "ea", "name": "created_at_date"}]

{"type": "text", "values": ["2019-06-28"], "valueType": "date", "fieldType": "text", "value": ["2019-06-28"], "customFieldId": "ea", "name": "created_at_date"}
[{"type": "text", "values": ["General"], "valueType": "string", "fieldType": "text", "value": ["General"], "customFieldId": "ee", "name": "customer_group"},{"type": "text", "values": ["Berlin"], "valueType": "string", "fieldType": "text", "value": ["Berlin"], "customFieldId": "eU", "name": "customer_city"},{"type": "text", "values": ["Otto"], "valueType": "string", "fieldType": "text", "value": ["Otto"], "customFieldId": "eZ", "name": "first_name"}, {"type": "text", "values": ["2019-06-28"], "valueType": "date", "fieldType": "text", "value": ["2019-06-28"], "customFieldId": "ea", "name": "created_at_date"}]


SELECT
    elems ->> 'name' AS column_name,
    elems -> 'value' ->> 0 AS value,
    data
FROM
    mytable,
    json_array_elements(data::json) elems


column_name
value
data


customer_group
General
[{"type": "text", "values": ["General"], "valueType": "string", "fieldType": "text", "value": ["General"], "customFieldId": "ee", "name": "customer_group"},{"type": "text", "values": ["Vienna"], "valueType": "string", "fieldType": "text", "value": ["Vienna"], "customFieldId": "eU", "name": "customer_city"},{"type": "text", "values": ["Mario"], "valueType": "string", "fieldType": "text", "value": ["Mario"], "customFieldId": "eZ", "name": "first_name"}, {"type": "text", "values": ["2019-06-30"], "valueType": "date", "fieldType": "text", "value": ["2019-06-30"], "customFieldId": "ea", "name": "created_at_date"}]

customer_city
Vienna
[{"type": "text", "values": ["General"], "valueType": "string", "fieldType": "text", "value": ["General"], "customFieldId": "ee", "name": "customer_group"},{"type": "text", "values": ["Vienna"], "valueType": "string", "fieldType": "text", "value": ["Vienna"], "customFieldId": "eU", "name": "customer_city"},{"type": "text", "values": ["Mario"], "valueType": "string", "fieldType": "text", "value": ["Mario"], "customFieldId": "eZ", "name": "first_name"}, {"type": "text", "values": ["2019-06-30"], "valueType": "date", "fieldType": "text", "value": ["2019-06-30"], "customFieldId": "ea", "name": "created_at_date"}]

first_name
Mario
[{"type": "text", "values": ["General"], "valueType": "string", "fieldType": "text", "value": ["General"], "customFieldId": "ee", "name": "customer_group"},{"type": "text", "values": ["Vienna"], "valueType": "string", "fieldType": "text", "value": ["Vienna"], "customFieldId": "eU", "name": "customer_city"},{"type": "text", "values": ["Mario"], "valueType": "string", "fieldType": "text", "value": ["Mario"], "customFieldId": "eZ", "name": "first_name"}, {"type": "text", "values": ["2019-06-30"], "valueType": "date", "fieldType": "text", "value": ["2019-06-30"], "customFieldId": "ea", "name": "created_at_date"}]

created_at_date
2019-06-30
[{"type": "text", "values": ["General"], "valueType": "string", "fieldType": "text", "value": ["General"], "customFieldId": "ee", "name": "customer_group"},{"type": "text", "values": ["Vienna"], "valueType": "string", "fieldType": "text", "value": ["Vienna"], "customFieldId": "eU", "name": "customer_city"},{"type": "text", "values": ["Mario"], "valueType": "string", "fieldType": "text", "value": ["Mario"], "customFieldId": "eZ", "name": "first_name"}, {"type": "text", "values": ["2019-06-30"], "valueType": "date", "fieldType": "text", "value": ["2019-06-30"], "customFieldId": "ea", "name": "created_at_date"}]

customer_group
General
[{"type": "text", "values": ["General"], "valueType": "string", "fieldType": "text", "value": ["General"], "customFieldId": "ee", "name": "customer_group"},{"type": "text", "values": ["Berlin"], "valueType": "string", "fieldType": "text", "value": ["Berlin"], "customFieldId": "eU", "name": "customer_city"},{"type": "text", "values": ["Otto"], "valueType": "string", "fieldType": "text", "value": ["Otto"], "customFieldId": "eZ", "name": "first_name"}, {"type": "text", "values": ["2019-06-28"], "valueType": "date", "fieldType": "text", "value": ["2019-06-28"], "customFieldId": "ea", "name": "created_at_date"}]

customer_city
Berlin
[{"type": "text", "values": ["General"], "valueType": "string", "fieldType": "text", "value": ["General"], "customFieldId": "ee", "name": "customer_group"},{"type": "text", "values": ["Berlin"], "valueType": "string", "fieldType": "text", "value": ["Berlin"], "customFieldId": "eU", "name": "customer_city"},{"type": "text", "values": ["Otto"], "valueType": "string", "fieldType": "text", "value": ["Otto"], "customFieldId": "eZ", "name": "first_name"}, {"type": "text", "values": ["2019-06-28"], "valueType": "date", "fieldType": "text", "value": ["2019-06-28"], "customFieldId": "ea", "name": "created_at_date"}]

first_name
Otto
[{"type": "text", "values": ["General"], "valueType": "string", "fieldType": "text", "value": ["General"], "customFieldId": "ee", "name": "customer_group"},{"type": "text", "values": ["Berlin"], "valueType": "string", "fieldType": "text", "value": ["Berlin"], "customFieldId": "eU", "name": "customer_city"},{"type": "text", "values": ["Otto"], "valueType": "string", "fieldType": "text", "value": ["Otto"], "customFieldId": "eZ", "name": "first_name"}, {"type": "text", "values": ["2019-06-28"], "valueType": "date", "fieldType": "text", "value": ["2019-06-28"], "customFieldId": "ea", "name": "created_at_date"}]

created_at_date
2019-06-28
[{"type": "text", "values": ["General"], "valueType": "string", "fieldType": "text", "value": ["General"], "customFieldId": "ee", "name": "customer_group"},{"type": "text", "values": ["Berlin"], "valueType": "string", "fieldType": "text", "value": ["Berlin"], "customFieldId": "eU", "name": "customer_city"},{"type": "text", "values": ["Otto"], "valueType": "string", "fieldType": "text", "value": ["Otto"], "customFieldId": "eZ", "name": "first_name"}, {"type": "text", "values": ["2019-06-28"], "valueType": "date", "fieldType": "text", "value": ["2019-06-28"], "customFieldId": "ea", "name": "created_at_date"}]


SELECT 
    MAX(value) FILTER (WHERE column_name = 'customer_group') AS customer_group,
    MAX(value) FILTER (WHERE column_name = 'customer_city') AS customer_city,
    MAX(value) FILTER (WHERE column_name = 'first_name') AS first_name,
    MAX(value) FILTER (WHERE column_name = 'created_at_date') AS created_at_date
FROM (
    SELECT
        elems ->> 'name' AS column_name,
        elems -> 'value' ->> 0 AS value,
        data
    FROM
        mytable,
        json_array_elements(data::json) elems
) s
GROUP BY data


customer_group
customer_city
first_name
created_at_date


General
Vienna
Mario
2019-06-30

General
Berlin
Otto
2019-06-28

value	data
{"type": "text", "values": ["General"], "valueType": "string", "fieldType": "text", "value": ["General"], "customFieldId": "ee", "name": "customer_group"}	[{"type": "text", "values": ["General"], "valueType": "string", "fieldType": "text", "value": ["General"], "customFieldId": "ee", "name": "customer_group"},{"type": "text", "values": ["Vienna"], "valueType": "string", "fieldType": "text", "value": ["Vienna"], "customFieldId": "eU", "name": "customer_city"},{"type": "text", "values": ["Mario"], "valueType": "string", "fieldType": "text", "value": ["Mario"], "customFieldId": "eZ", "name": "first_name"}, {"type": "text", "values": ["2019-06-30"], "valueType": "date", "fieldType": "text", "value": ["2019-06-30"], "customFieldId": "ea", "name": "created_at_date"}]
{"type": "text", "values": ["Vienna"], "valueType": "string", "fieldType": "text", "value": ["Vienna"], "customFieldId": "eU", "name": "customer_city"}	[{"type": "text", "values": ["General"], "valueType": "string", "fieldType": "text", "value": ["General"], "customFieldId": "ee", "name": "customer_group"},{"type": "text", "values": ["Vienna"], "valueType": "string", "fieldType": "text", "value": ["Vienna"], "customFieldId": "eU", "name": "customer_city"},{"type": "text", "values": ["Mario"], "valueType": "string", "fieldType": "text", "value": ["Mario"], "customFieldId": "eZ", "name": "first_name"}, {"type": "text", "values": ["2019-06-30"], "valueType": "date", "fieldType": "text", "value": ["2019-06-30"], "customFieldId": "ea", "name": "created_at_date"}]
{"type": "text", "values": ["Mario"], "valueType": "string", "fieldType": "text", "value": ["Mario"], "customFieldId": "eZ", "name": "first_name"}	[{"type": "text", "values": ["General"], "valueType": "string", "fieldType": "text", "value": ["General"], "customFieldId": "ee", "name": "customer_group"},{"type": "text", "values": ["Vienna"], "valueType": "string", "fieldType": "text", "value": ["Vienna"], "customFieldId": "eU", "name": "customer_city"},{"type": "text", "values": ["Mario"], "valueType": "string", "fieldType": "text", "value": ["Mario"], "customFieldId": "eZ", "name": "first_name"}, {"type": "text", "values": ["2019-06-30"], "valueType": "date", "fieldType": "text", "value": ["2019-06-30"], "customFieldId": "ea", "name": "created_at_date"}]
{"type": "text", "values": ["2019-06-30"], "valueType": "date", "fieldType": "text", "value": ["2019-06-30"], "customFieldId": "ea", "name": "created_at_date"}	[{"type": "text", "values": ["General"], "valueType": "string", "fieldType": "text", "value": ["General"], "customFieldId": "ee", "name": "customer_group"},{"type": "text", "values": ["Vienna"], "valueType": "string", "fieldType": "text", "value": ["Vienna"], "customFieldId": "eU", "name": "customer_city"},{"type": "text", "values": ["Mario"], "valueType": "string", "fieldType": "text", "value": ["Mario"], "customFieldId": "eZ", "name": "first_name"}, {"type": "text", "values": ["2019-06-30"], "valueType": "date", "fieldType": "text", "value": ["2019-06-30"], "customFieldId": "ea", "name": "created_at_date"}]
{"type": "text", "values": ["General"], "valueType": "string", "fieldType": "text", "value": ["General"], "customFieldId": "ee", "name": "customer_group"}	[{"type": "text", "values": ["General"], "valueType": "string", "fieldType": "text", "value": ["General"], "customFieldId": "ee", "name": "customer_group"},{"type": "text", "values": ["Berlin"], "valueType": "string", "fieldType": "text", "value": ["Berlin"], "customFieldId": "eU", "name": "customer_city"},{"type": "text", "values": ["Otto"], "valueType": "string", "fieldType": "text", "value": ["Otto"], "customFieldId": "eZ", "name": "first_name"}, {"type": "text", "values": ["2019-06-28"], "valueType": "date", "fieldType": "text", "value": ["2019-06-28"], "customFieldId": "ea", "name": "created_at_date"}]
{"type": "text", "values": ["Berlin"], "valueType": "string", "fieldType": "text", "value": ["Berlin"], "customFieldId": "eU", "name": "customer_city"}	[{"type": "text", "values": ["General"], "valueType": "string", "fieldType": "text", "value": ["General"], "customFieldId": "ee", "name": "customer_group"},{"type": "text", "values": ["Berlin"], "valueType": "string", "fieldType": "text", "value": ["Berlin"], "customFieldId": "eU", "name": "customer_city"},{"type": "text", "values": ["Otto"], "valueType": "string", "fieldType": "text", "value": ["Otto"], "customFieldId": "eZ", "name": "first_name"}, {"type": "text", "values": ["2019-06-28"], "valueType": "date", "fieldType": "text", "value": ["2019-06-28"], "customFieldId": "ea", "name": "created_at_date"}]
{"type": "text", "values": ["Otto"], "valueType": "string", "fieldType": "text", "value": ["Otto"], "customFieldId": "eZ", "name": "first_name"}	[{"type": "text", "values": ["General"], "valueType": "string", "fieldType": "text", "value": ["General"], "customFieldId": "ee", "name": "customer_group"},{"type": "text", "values": ["Berlin"], "valueType": "string", "fieldType": "text", "value": ["Berlin"], "customFieldId": "eU", "name": "customer_city"},{"type": "text", "values": ["Otto"], "valueType": "string", "fieldType": "text", "value": ["Otto"], "customFieldId": "eZ", "name": "first_name"}, {"type": "text", "values": ["2019-06-28"], "valueType": "date", "fieldType": "text", "value": ["2019-06-28"], "customFieldId": "ea", "name": "created_at_date"}]
{"type": "text", "values": ["2019-06-28"], "valueType": "date", "fieldType": "text", "value": ["2019-06-28"], "customFieldId": "ea", "name": "created_at_date"}	[{"type": "text", "values": ["General"], "valueType": "string", "fieldType": "text", "value": ["General"], "customFieldId": "ee", "name": "customer_group"},{"type": "text", "values": ["Berlin"], "valueType": "string", "fieldType": "text", "value": ["Berlin"], "customFieldId": "eU", "name": "customer_city"},{"type": "text", "values": ["Otto"], "valueType": "string", "fieldType": "text", "value": ["Otto"], "customFieldId": "eZ", "name": "first_name"}, {"type": "text", "values": ["2019-06-28"], "valueType": "date", "fieldType": "text", "value": ["2019-06-28"], "customFieldId": "ea", "name": "created_at_date"}]

column_name	value	data
customer_group	General	[{"type": "text", "values": ["General"], "valueType": "string", "fieldType": "text", "value": ["General"], "customFieldId": "ee", "name": "customer_group"},{"type": "text", "values": ["Vienna"], "valueType": "string", "fieldType": "text", "value": ["Vienna"], "customFieldId": "eU", "name": "customer_city"},{"type": "text", "values": ["Mario"], "valueType": "string", "fieldType": "text", "value": ["Mario"], "customFieldId": "eZ", "name": "first_name"}, {"type": "text", "values": ["2019-06-30"], "valueType": "date", "fieldType": "text", "value": ["2019-06-30"], "customFieldId": "ea", "name": "created_at_date"}]
customer_city	Vienna	[{"type": "text", "values": ["General"], "valueType": "string", "fieldType": "text", "value": ["General"], "customFieldId": "ee", "name": "customer_group"},{"type": "text", "values": ["Vienna"], "valueType": "string", "fieldType": "text", "value": ["Vienna"], "customFieldId": "eU", "name": "customer_city"},{"type": "text", "values": ["Mario"], "valueType": "string", "fieldType": "text", "value": ["Mario"], "customFieldId": "eZ", "name": "first_name"}, {"type": "text", "values": ["2019-06-30"], "valueType": "date", "fieldType": "text", "value": ["2019-06-30"], "customFieldId": "ea", "name": "created_at_date"}]
first_name	Mario	[{"type": "text", "values": ["General"], "valueType": "string", "fieldType": "text", "value": ["General"], "customFieldId": "ee", "name": "customer_group"},{"type": "text", "values": ["Vienna"], "valueType": "string", "fieldType": "text", "value": ["Vienna"], "customFieldId": "eU", "name": "customer_city"},{"type": "text", "values": ["Mario"], "valueType": "string", "fieldType": "text", "value": ["Mario"], "customFieldId": "eZ", "name": "first_name"}, {"type": "text", "values": ["2019-06-30"], "valueType": "date", "fieldType": "text", "value": ["2019-06-30"], "customFieldId": "ea", "name": "created_at_date"}]
created_at_date	2019-06-30	[{"type": "text", "values": ["General"], "valueType": "string", "fieldType": "text", "value": ["General"], "customFieldId": "ee", "name": "customer_group"},{"type": "text", "values": ["Vienna"], "valueType": "string", "fieldType": "text", "value": ["Vienna"], "customFieldId": "eU", "name": "customer_city"},{"type": "text", "values": ["Mario"], "valueType": "string", "fieldType": "text", "value": ["Mario"], "customFieldId": "eZ", "name": "first_name"}, {"type": "text", "values": ["2019-06-30"], "valueType": "date", "fieldType": "text", "value": ["2019-06-30"], "customFieldId": "ea", "name": "created_at_date"}]
customer_group	General	[{"type": "text", "values": ["General"], "valueType": "string", "fieldType": "text", "value": ["General"], "customFieldId": "ee", "name": "customer_group"},{"type": "text", "values": ["Berlin"], "valueType": "string", "fieldType": "text", "value": ["Berlin"], "customFieldId": "eU", "name": "customer_city"},{"type": "text", "values": ["Otto"], "valueType": "string", "fieldType": "text", "value": ["Otto"], "customFieldId": "eZ", "name": "first_name"}, {"type": "text", "values": ["2019-06-28"], "valueType": "date", "fieldType": "text", "value": ["2019-06-28"], "customFieldId": "ea", "name": "created_at_date"}]
customer_city	Berlin	[{"type": "text", "values": ["General"], "valueType": "string", "fieldType": "text", "value": ["General"], "customFieldId": "ee", "name": "customer_group"},{"type": "text", "values": ["Berlin"], "valueType": "string", "fieldType": "text", "value": ["Berlin"], "customFieldId": "eU", "name": "customer_city"},{"type": "text", "values": ["Otto"], "valueType": "string", "fieldType": "text", "value": ["Otto"], "customFieldId": "eZ", "name": "first_name"}, {"type": "text", "values": ["2019-06-28"], "valueType": "date", "fieldType": "text", "value": ["2019-06-28"], "customFieldId": "ea", "name": "created_at_date"}]
first_name	Otto	[{"type": "text", "values": ["General"], "valueType": "string", "fieldType": "text", "value": ["General"], "customFieldId": "ee", "name": "customer_group"},{"type": "text", "values": ["Berlin"], "valueType": "string", "fieldType": "text", "value": ["Berlin"], "customFieldId": "eU", "name": "customer_city"},{"type": "text", "values": ["Otto"], "valueType": "string", "fieldType": "text", "value": ["Otto"], "customFieldId": "eZ", "name": "first_name"}, {"type": "text", "values": ["2019-06-28"], "valueType": "date", "fieldType": "text", "value": ["2019-06-28"], "customFieldId": "ea", "name": "created_at_date"}]
created_at_date	2019-06-28	[{"type": "text", "values": ["General"], "valueType": "string", "fieldType": "text", "value": ["General"], "customFieldId": "ee", "name": "customer_group"},{"type": "text", "values": ["Berlin"], "valueType": "string", "fieldType": "text", "value": ["Berlin"], "customFieldId": "eU", "name": "customer_city"},{"type": "text", "values": ["Otto"], "valueType": "string", "fieldType": "text", "value": ["Otto"], "customFieldId": "eZ", "name": "first_name"}, {"type": "text", "values": ["2019-06-28"], "valueType": "date", "fieldType": "text", "value": ["2019-06-28"], "customFieldId": "ea", "name": "created_at_date"}]