Advertisement
GLASHATAY_007

acgz_processes

Jun 24th, 2024
760
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Select
  2. (Select cube_id
  3.     From (Select
  4.                     value->>'cube_id' as cube_id
  5.                 From jsonb_array_elements(c.layer)) As v) As category_characteristics_v2
  6. from charts c
  7. -- inner join tables t on t.id like c.layers
  8. Where c.id='5f7d3264-30d3-4463-af75-5270ab370281'
  9.  
  10.  
  11. SELECT  c.layer->>'cube_id'
  12. from charts c
  13. -- inner join tables t on t.id like c.layers
  14. where c.id='5f7d3264-30d3-4463-af75-5270ab370281';
  15.  
  16. Select
  17.     f.*
  18.     c.layer->'rows'->-1->'args'->-1->>'cube_id' AS layer
  19. From charts c
  20. Inner Join tables t on t.id =(c.layer->'rows'->-1->'args'->-1->>'cube_id')::int
  21. Inner Join steps s on s.table_name=t.table_name
  22. Inner Join flows f on s.flow_id=f.id
  23. -- Inner Join dashboards d on d.
  24. where c.id='9d4bc4b4-881b-4993-85b9-11b071a5ddc0'
  25.  
  26.  
  27.  
  28. select
  29.     *
  30. from dashboards c
  31. where id='85a3c2eb-b617-4157-93f7-ae2c32a8218f'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement