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.
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.
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 ??
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You don't need the CLI to run a query :)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.