References are not working

[RafaelKa]

Hello Rens,

i tried to use selfreferenced Model.
persisting the model works fine, but i can not get the Models with findByParent(findByIdentifier('f49cb66745e5f0458ae108f2ff0ba163')).

{
   "_id": "f49cb66745e5f0458ae108f2ff0ba163",
   "_rev": "1-fe3deee4eec055d172cdb20bc651a9c7",
   "type": "THM.Products.Domain.Model.Product",
   "doctrine_metadata": {
       "indexed": true,
       "indexes": [
           "title",
           "parent"
       ],
       "associations": [
           "parent",
           "children"
       ]
   },
   "title": "Produkt 001",
   "properties": null,
   "parent": null,
   "children": [
   ]
}

{
   "_id": "f49cb66745e5f0458ae108f2ff0c1652",
   "_rev": "1-a4a68157c12c0f02991e688d9f4d866b",
   "type": "THM.Products.Domain.Model.Product",
   "doctrine_metadata": {
       "indexed": true,
       "indexes": [
           "title",
           "parent"
       ],
       "associations": [
           "parent",
           "children"
       ]
   },
   "title": "Kindprodukt001 von 001",
   "properties": null,
   "parent": "f49cb66745e5f0458ae108f2ff0ba163",
   "children": [
   ]
}

I need only Products without parent: also root products only.
To find out what is wrong i tried example from above.

Do you know, if some issues with self referencing on CouchDB ODM are available?

[radmiraal]

nope, I'm not aware of such issues, maybe it helps to do: findByParent('f49cb66745e5f0458ae108f2ff0ba163').

otherwise I wouldn't know, never used self referencing with this package

[RafaelKa]

Hmmm,

it is!

How to find all Products where parent is null?

also findByParent(NULL); does not work.
is there some trick to do that?

[radmiraal]

when I need to do more advanced queries I always create my own views. You can do so by putting them in a folder like:

Migrations/CouchDB/DesignDocuments//views//

You have to put a map.js there, and can add a reduce.js. If you then run a ./flow migrate:designs it should add the design documents & views to couch