hi, i am working on recreating tree from database table,
what i need to do is to select all items where parentIndex is null
so in mysql i can do : SELECT * FROM `treemenu` WHERE parentIndex IS NULL
how should query look like in jpa to get same results ?
"SELECT t FROM TreeMenu t WHERE t.parentIndex IS NULL" gives me 'unknown state or association field [parentIndex]'