Multiple MQL writes in one query envelope?
-
-
I am trying to use the Query Editor to do multiple MQL Writes in a single 'query' envelope. (I'd like to try and avoid using 'queries')Firstly, is this even possible? Using the following mql, I've tried various alternatives of colon and square bracket, but can't seem to find a way which works. Where am I going wrong?{ "query":[ { "id" : "/guid/9202a8c04000641f80000000001ead71", "type" : { "connect" : "insert", "id" : "/royalty/chivalric_order_member" } }, { "id" : "/guid/9202a8c04000641f8000000000630b8e", "type" : { "connect" : "insert", "id" : "/royalty/chivalric_order_member" } }, { "id" : "/guid/9202a8c04000641f80000000007e0325", "type" : { "connect" : "insert", "id" : "/royalty/chivalric_order_member" } } ] }
-
A list of mqlwrite directives should work - it worked in the old query editor, and our MQL documentation has an example of it. Can you submit a bug regarding this?
-
Correct -- this previously worked and doesn't any more. This is a bug and Jason and David are aware of it, but it's good to have more use cases/examples of people being caught by it.
-
Oops, that's a bug in the query editor. It should be fixed now. You'd need to shift-reload to get the browser to load the latest code of query editor. Try again and let us know if it works or doesn't.
-
Still not working - this time it correctly identifies the above mql as a write, but returns the error /api/status/error/mql/type, "Type /type/object does not have property query".
I've created CLI-8201 in JIRA.
-
It doesn't understand the envelope, so if you remove the outer { "query" : ... } and just keep the array, like so
it should work. It just did for me.
-
Great just worked - thanks for your help.
-