Hi Phil, It's the query that never ends...!
I looked over your schema and data, and maybe I misunderstood you or came up with my own interpretation, but in my mind each tag was its own instance 'owned' by a particular person. I would expect that a person could create his own custom tags from maybe common derived types that could be used for general queries about tags or each tag could have some kind of type identifier. This solves all your stated queries and avoids having to have links on the tagged and taggedwith edges themselves (which will prevent them from being lightweight edges). In your relational model, the PersonResourceTag serves as the 'instance' data. I'm curious what you decide to do. Good luck (and let me know)! -Colin Orient Technologies The Company behind OrientDB On Thursday, March 19, 2015 at 12:56:55 AM UTC-5, Phil wrote: > > Hi Colin, > I've put together a quick test of this and it does indeed return Bob even > if he did not apply the Red tag to Resource1. > Attached are 2 files: > 1) I run test_db_schema.sql as an argument to the console.sh script to > create the database and schema. > 2) I then start the console, connect to the database then copy and paste > the contents of test_db_data.sql into the console after issuing the 'script > sql' command. I don't know why but I couldn't use the let statement from > within a file. > > I have included your query at the end of the script and the Bob record is > returned even if he didn't tag Resource1 with Red. > -Phill > > > -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
