latest artem SELECT FROM SELECT collaboration_id created_at created_by

1
2
3
4
5
6
7
// latest artem
SELECT r.* FROM (SELECT collaboration_id,created_at,created_by,finished_at AS completed_at,definition_id,from_mosaic,is_simulation,instance_id AS id,name,type,version,file,OBJECT_VALUES(resources_executed) as resources_executed,CASE WHEN status.failed THEN "failed" WHEN status.terminated THEN "terminated" WHEN status.completed THEN "completed" WHEN status.suspended THEN "suspended" ELSE "running" END AS status,status AS status_raw,terminated,OBJECT_LENGTH(tokens) as tokens,updated_at,updated_by,OBJECT_VALUES(activities) as activities,tenant FROM default t WHERE REGEXP_LIKE(META(t).id, 'instances:.*')) r WHERE 1 AND tenant IN ['nextapi'] ORDER BY META(default).id LIMIT 10
13.62s
// latest artem without order by
SELECT r.* FROM (SELECT collaboration_id,created_at,created_by,finished_at AS completed_at,definition_id,from_mosaic,is_simulation,instance_id AS id,name,type,version,file,OBJECT_VALUES(resources_executed) as resources_executed,CASE WHEN status.failed THEN "failed" WHEN status.terminated THEN "terminated" WHEN status.completed THEN "completed" WHEN status.suspended THEN "suspended" ELSE "running" END AS status,status AS status_raw,terminated,OBJECT_LENGTH(tokens) as tokens,updated_at,updated_by,OBJECT_VALUES(activities) as activities,tenant FROM default t WHERE REGEXP_LIKE(META(t).id, 'instances:.*')) r WHERE 1 AND tenant IN ['nextapi'] LIMIT 10
119.47ms