In http://localhost:4502/libs/cq/search/content/querydebug.html, they work fine. Even in crxde query options they work fine. Via code, when exceuted , doesnt work. Index related errors seen in logs. Created custom indexes as well and getting picked up as well, but that doesn't seem to be the problem.
The issue seems to be the way in which querybuilder predicates[mentioned in #1 and #2 below] are being tried.
property2 to property7. All of them are different properties present under metadata.
#1 and #2 were variations I was trying out at my end, to achieve the end result. Probably I was not too clear.
Basically the motive is to list all assets having a specific property present as part of "jcr:content/metadata/dita_class" property and look for logged-in user value in any of the 6 metadata properties.