JIRA CLI runfromsql error

[Prakash Ganeshan]

I am running the below query from JIRA CLI.  I am getting result of the query along with some error.

I am using JIRA 6.3.11, CLI 3.0.0 and oracle database.

Below is the CLI command I am running.

jira --action runFromSql --sql "select count(*) from jiraissue" --host "hostname" --driver "oracle" --database "databasename" --dbUser "username" --dbPassword "password"

I am getting the result of the query along with the error message.

Run: --cOUNT(*) "169347"

Error: Unknown flag 'cOUNT(*)'.
Error: Unexpected argument: 169347
Error: Parameter 'action' is required.

Client error: 1 actions failed

Please help me to fix this error.

[Bob Swift]

runFromSql is used to run a specific CLI action for each row from the result set. What action where you intending to run for your scenario? Your query isn't producing a valid action and so your are getting an error trying run it. Examples as a simply example.

[Prakash Ganeshan]

Hi Bob Swift, I am trying to get the count of the issues in my jira instance and I am trying to run query in DB to get the count. Please let me know how do I change the command ??

[Prakash Ganeshan]

I don't want to run any CLI action for the value returned by the query, My query just retuns the number of tickets (169347 in my case) and I dont want to run any CLI actions on this value.

[Bob Swift]

You don't need the CLI to run a query :)