search_api_schema

space: "Project OSIO"
d69a3d70-3233-46bc-bb53-08d9155b40a5

owner
ae68a343-c866-430c-b6ce-a36f0b38d8e5

collaborator
ae68a343-c866-430c-b6ce-a36f0b38d8e5

iteration : Sprint 1
a7238559-935c-414c-8555-306b3b3d3ba6

iteration : Sprint 2
056949f3-2bd6-4a78-8e40-391ba15af6b9

area: planner
08f2d36e-908f-4f0a-90fa-536592bb196a

area: platform
450d9744-24f5-480b-a3bf-6b9b2d48696b


WI-1
status: new, area: planner, iteration: sprint 2


WI-2
status: closed, area: platform, iteration: sprint 2


WI-3
status: closed, area: planner, iteration: sprint 1


WI-4
status: closed, area: planner, iteration: sprint 1


WI-5
status: closed, area: planner, iteration: sprint 1


WI-6
status: closed, area: platform, iteration: sprint 1



From DB
postgres=# select space_id, fields->>'system.iteration' as iteration, fields->>'system.area' as area, fields->>'system.state' as state from work_items order by fields->>'system.iteration';
               space_id               |              iteration               |                 area                 | state  
--------------------------------------+--------------------------------------+--------------------------------------+--------
 d69a3d70-3233-46bc-bb53-08d9155b40a5 | 056949f3-2bd6-4a78-8e40-391ba15af6b9 | 08f2d36e-908f-4f0a-90fa-536592bb196a | new
 d69a3d70-3233-46bc-bb53-08d9155b40a5 | 056949f3-2bd6-4a78-8e40-391ba15af6b9 | 450d9744-24f5-480b-a3bf-6b9b2d48696b | closed
 d69a3d70-3233-46bc-bb53-08d9155b40a5 | a7238559-935c-414c-8555-306b3b3d3ba6 | 08f2d36e-908f-4f0a-90fa-536592bb196a | closed
 d69a3d70-3233-46bc-bb53-08d9155b40a5 | a7238559-935c-414c-8555-306b3b3d3ba6 | 08f2d36e-908f-4f0a-90fa-536592bb196a | closed
 d69a3d70-3233-46bc-bb53-08d9155b40a5 | a7238559-935c-414c-8555-306b3b3d3ba6 | 08f2d36e-908f-4f0a-90fa-536592bb196a | closed
 d69a3d70-3233-46bc-bb53-08d9155b40a5 | a7238559-935c-414c-8555-306b3b3d3ba6 | 450d9744-24f5-480b-a3bf-6b9b2d48696b | closed
(6 rows)

postgres=# 




Query 1
Show all work items from this space
{"space":"d69a3d70-3233-46bc-bb53-08d9155b40a5"}

http://localhost:8080/api/search?filter[expression]={"space":"d69a3d70-3233-46bc-bb53-08d9155b40a5"}



Query 2
Get work items where area=planner && iteration=sprint1
{"$AND":[{"space":"d69a3d70-3233-46bc-bb53-08d9155b40a5"},{"area":"08f2d36e-908f-4f0a-90fa-536592bb196a"},{"iteration":"a7238559-935c-414c-8555-306b3b3d3ba6"}]}

http://localhost:8080/api/search?filter[expression]={"$AND":[{"space":"d69a3d70-3233-46bc-bb53-08d9155b40a5"},{"area":"08f2d36e-908f-4f0a-90fa-536592bb196a"},{"iteration":"a7238559-935c-414c-8555-306b3b3d3ba6"}]}



Query 3
Get new OR resolved work items
{"$AND":[{"space":"d69a3d70-3233-46bc-bb53-08d9155b40a5"},{"$OR":[{"state":"new"},{"state":"resolved"}]}]}
http://localhost:8080/api/search?filter[expression]={"$AND":[{"space":"d69a3d70-3233-46bc-bb53-08d9155b40a5"},{"$OR":[{"state":"new"},{"state":"resolved"}]}]}


Query 4
get all work items which are NOT in sprint 1
{"$AND":[{"space":"d69a3d70-3233-46bc-bb53-08d9155b40a5"},{"iteration":"a7238559-935c-414c-8555-306b3b3d3ba6","negate":true}]}
http://localhost:8080/api/search?filter[expression]={"$AND":[{"space":"d69a3d70-3233-46bc-bb53-08d9155b40a5"},{"iteration":"a7238559-935c-414c-8555-306b3b3d3ba6","negate":true}]}