HELP ME! I want to use JQL in command line

Hao Bui June 20, 2019

I am using Export function of QMetry for Jira for get Test Case information. I export data by command line. I want to filter the test case result only contain TestCase. I try use JQL clause but the error is appear. I not sure about syntax correct. Could you help me about syntax?

Capture.PNG

2 answers

0 votes
Reshma Padkil June 20, 2019

Hi @Hao Bui ,

Please get in touch with  QMetry Support with exact JQL that you are using. We will be happy to help you.

0 votes
brbojorque
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
June 20, 2019

Hi @Hao Bui , can you provide the exact JQL you are trying to execute?

Hao Bui June 20, 2019

I run the command line as below, please take a look:

java -cp ImportExport-1.7.5.jar com.infostretch.importExportUtility.cliController.Main user@example.com   --my email

<removed> -- my token

<removed> --my api key

https://example.atlassian.net --my host

C:\Export\QTM_2019-06-20_Export.xlsx --my path 

issuetype IN ("TestCase") -- my JQL

PHW --my project key

Best.

Hao.

Reshma Padkil June 20, 2019

@Hao Bui ,

Yes, the JQL is wrong. It should be - issuetype in ("Test Case").

"Test Case" issue type has space.

Like Hao Bui likes this
bryan bojorque
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
June 20, 2019

Hi @Hao Bui , first of all you posted all of your credential in public. Please regenerate your API key and Token so no one can exploit it.

I don't see nothing wrong with the JQL.

My question is your issuetype "Test Case" or "TestCase" either way if both do not exists it would have resulted to issuetype does not exists.

Maybe fix the error reporting to the actual error being displayed in the search page.

It seems to be that there is an escaping issue here, the error is a bit weird to me.

Like # people like this
Earl McCutcheon
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
June 20, 2019

Hi @Hao Bui ,

I removed the Token and sensitive content from your post above as this information is publicly visible in this forum and has been exposed for the last 9 hours and anyone with the information can access and modify your data from the API impersonating your account.

I would recomend going to https://id.atlassian.com/manage/api-tokens and revoking the original API token, and creating a new one, to avoide any unwanted users from accessing the data.

Regards,
Earl

Like Hao Bui likes this
Hao Bui June 20, 2019

Thanks all, It is only fake Token and API Key

Like Earl McCutcheon likes this
Earl McCutcheon
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
June 21, 2019

Hey  @Hao Bui ,

Good to hear and thanks for the confirmation on that part whenever we see something that looks like it could be a security leak we try to jump on it asap.

Regards,
Earl

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events