JIRA CLI runfromsql error

Question

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 · Answer

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

Prakash Ganeshan · Answer

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.

Prakash Ganeshan · Answer

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 ??