Cannot correctly set the path to my local repository

[Manjunatha K R]

Hi,

The below query is working if I use path not like *Table.java and path not like *Oper.java.

But if I want to get query results for path like *Table.java and path like *Oper.java => I am not getting any results.

Is something wrong with my query used?

select revisions from dir "/" where (author in ("aharish", "aharsha", "ajays", "akalirajan", "arajashekar", "arihantrk", "parun", "arunv", "atomson", "avineet", "bbinil", "bjayakumar", "bjayavardhan", "bmahaaboob", "caparna", "cdhiren", "schandra", "schitransh", "dbteam", "pdebasish", "dkushan", "pgovindu", "gpratheej", "gprithviraj", "gpriya", "gsiddharth", "gsrinivasa", "gsunilkumar", "gsureshkumar", "gvikas", "jgeorge", "gjhaunu", "tjyothi", "kgunjan", "kgandhi", "ksathish", "kshanmuganathan", "ksuresh", "lsubramanyam", "mamit", "mkrishnan", "umohd", "mreddy", "mswathi", "namit", "rnaveen", "kneeraj", "no_author", "npariath", "nsantu", "gparamesh", "prasadmv", "proy", "psharadavani", "psheroo", "pvelayudhan", "nraghu", "rkrishna", "rshanker", "rbabu", "rdeepti", "rkamat", "rlakshmi", "rmurugan", "rsaravind", "rshankar", "rvijaya", "sanubhav", "djsateesh", "scheedel", "sdogra", "sjiji", "skiran", "smanjusha", "srajasekaran", "sseema", "ssmitha", "ssomsubhra", "ssrivardhan", "mvsudhakara", "supadya", "snazir", "tanuradha", "themanta", "trhythm", "supananda", "uprema", "vigneshwaran", "vpatel", "azameer") and path like *Table.java and path like *Oper.java and on branch EMS_POC_9_0_MAIN and date in [2017-12-31T18:30:00.00Z, 2018-01-29T18:29:59.00Z]) order by date desc group by changeset return path, author, date, linesAdded

[Michael Walker]

Hi Manju,

I know that you have reached out to support directly and that we have addressed this question for you already but I would like to go ahead and answer here as well to provide the community the answers that we have found to possibly help others with this issue.

This ended up being a format/syntax issue in the way that the query is built. When running a query that has "path like *Table.java and path like *Opera.java", the query sees these and tries to find all files that include BOTH of these criteria rather than one or the other. The proper syntax is as follows:

... where (path like *Table.java or path like *Oper.java), and ...

Hopefully this helps any others that encounter this issue.

Best Regards