Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,293,499
Community Members
 
Community Events
165
Community Groups

Cannot correctly set the path to my local repository

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

1 answer


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

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Posted in Jira Service Management

Jira Service Management Documentation Opportunities

Hello everyone, Hope everyone is safe! A few months ago we posted an article sharing all the new articles and documentation that we, the AMER Jira Service Management team created. As mentioned ...

190 views 0 5
Join discussion

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you