Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Select
- (Select cube_id
- From (Select
- value->>'cube_id' as cube_id
- From jsonb_array_elements(c.layer)) As v) As category_characteristics_v2
- from charts c
- -- inner join tables t on t.id like c.layers
- Where c.id='5f7d3264-30d3-4463-af75-5270ab370281'
- SELECT c.layer->>'cube_id'
- from charts c
- -- inner join tables t on t.id like c.layers
- where c.id='5f7d3264-30d3-4463-af75-5270ab370281';
- Select
- f.*
- c.layer->'rows'->-1->'args'->-1->>'cube_id' AS layer
- From charts c
- Inner Join tables t on t.id =(c.layer->'rows'->-1->'args'->-1->>'cube_id')::int
- Inner Join steps s on s.table_name=t.table_name
- Inner Join flows f on s.flow_id=f.id
- -- Inner Join dashboards d on d.
- where c.id='9d4bc4b4-881b-4993-85b9-11b071a5ddc0'
- select
- *
- from dashboards c
- where id='85a3c2eb-b617-4157-93f7-ae2c32a8218f'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement