Hi Luca, Thanks for your reply!
My category graph looks like that: Level 1: (#17:0_ROOT_Categorie)-['E_CH']->(#17:1_1.Category) (#17:0_ROOT_Categorie)-['E_CH']->(#17:2_2.Category) (#17:0_ROOT_Categorie)-['E_CH']->(#17:3_3.Category) (#17:0_ROOT_Categorie)-['E_CH']->(#17:4_4.Category) ... Level 2: (#17:1_1.Category)-['E_CH']->(#17:11_1.1.Category) (#17:1_1.Category)-['E_CH']->(#17:12_1.2.Category) (#17:1_1.Category)-['E_CH']->(#17:13_1.3.Category) (#17:1_1.Category)-['E_CH']->(#17:14_1.4.Category) ... Level 3: (#17:11_1.1.Category)-['E_CH']->(#17:111_1.1.1.Category) (#17:11_1.1.Category)-['E_CH']->(#17:112_1.1.2.Category) (#17:11_1.1.Category)-['E_CH']->(#17:113_1.1.3.Category) (#17:11_1.1.Category)-['E_CH']->(#17:114_1.1.4.Category) ... and so on... 4 levels deep and 4 categories per level I have assigned one to 10 categories to each of my 500 documents: (#23:1_1.Doc)-['E_Category']->(#17:111_1.1.1.Category) (#23:1_1.Doc)-['E_Category']->(#17:2_2.Category) (#23:1_1.Doc)-['E_Category']->(#17:113_1.1.3.Category) ... (#23:50_50.Doc)-['E_Category']->(#17:4_4.Category) (#23:50_50.Doc)-['E_Category']->(#17:11_1.1.Category) ... (#23:500_500.Doc)-['E_Category']->(#17:4_4.Category) (#23:500_500.Doc)-['E_Category']->(#17:112_1.1.2.Category) (#23:500_500.Doc)-['E_Category']->(#17:11_1.1.Category) (#23:500_500.Doc)-['E_Category']->(#17:114_1.1.4.Category) ... and so on, 500 documents. I want to select the number of documents which have assigned the given category and all child categories of the given category without duplicates. So with given ROOT category (#17:0) i expect to get 500 documents as result with my query but i got 1364 as mentioned above. -- --- 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.
