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
