Advertisement
Guest User

Untitled

a guest
Jun 17th, 2019
58
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.55 KB | None | 0 0
  1. SELECT meta(bn).id as _ID, meta(bn).cas as _CAS, bn.name
  2. FIRST t FOR t IN properties WHEN t.id = “1111” END as property
  3. FROM bucket-name as bn
  4. WHERE ANY t IN attributes SATISFIES t.id = “1111” END
  5.  
  6. [
  7. {
  8. "_CAS": 0000,
  9. "_ID": "1111",
  10. "name": "my name",
  11. "property": {
  12. "id": "1111",
  13. "name": "my property name"
  14. }
  15. }
  16. ]
  17.  
  18. [
  19. {
  20. "_CAS": 0000,
  21. "_ID": "1111",
  22. "name": "my name",
  23. "property": [
  24. {
  25. "id": "1111",
  26. "name": "my property name"
  27. }
  28. ]
  29. }
  30. ]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement