Loading the task…
In purchase-event parcels, items normally holds an array of order lines. The data is messy, though, and QUERY, the archive AI mentor, wants the events where the key exists but contains something else.
What to return:
- event_id — the event ID
- items_type — the type of the items value
Keep in mind:
- the operator payload -> 'items' fetches the value of a key
- jsonb_typeof names the value type
- consider any events
- include only events where the items key is present but its value is not an array
- skip events that have no items key at all
Sort by event_id ascending.
Sign in to see submission history
Sign inSign in to use AI Mentor
Sign in