Guest User

Untitled

a guest
Jan 21st, 2019
74
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.54 KB | None | 0 0
  1. Вытащил filters и получил
  2.  
  3. select * from (select * from jsonb_populate_recordset(null::tp_filters, (select '{"title": "Отчёт1", "filters": [{"name": "Дата с", "value": "30.01.1999", "property": "datebeg"}, {"name": "Дата по", "value": "31.01.1999", "property": "dateend"}], "selection": [{"name": "Код", "index": 0, "orderby": null, "property": "Id", "isvisible": true}, {"name": "Наименование", "index": 1, "orderby": 1, "property": "Name", "isvisible": false}]}'::jsonb->'filters'))as filter) as prop
Add Comment
Please, Sign In to add comment