Jira, Postgres, R scripting query if else statement?

Question

I am querying Jira with an R Script. I get the data, and put that data into temporary Postgres tables.

I then use postgres sql to modify the data and then put it into a more permanent table, or tables.

However here is my problem. I can't run a if else, or case then statement, modify and return data with my statement? I can run a query that works, but I have over 3500 rows of data. When I run it with this query it only returns 1700+ rows, and skips the null rows. I want to return all rows even if it is null.

Here Is the query:

,(regexp_matches(split_part("Linked Issues"::TEXT,',', 1), '[0-9]+\.?[0-9]*'))[1]::numeric AS LinkedIssueID

I tried to put a case statement around it, but it would not let me make a return like that.

Thank you ahead of time.

Michael A Orozco · Answer

I found someone to help me. We had to add some replace( regex stuff to it, and it worked.

Nic Brough -Adaptavist- · Answer

We can't help you with that - you've not told us what you have got set up in your database, and we're not R coders.

(If you are talking about writing data into Jira's database, then stop and redesign your project - you should never write to a Jira database)

Michael A Orozco · Answer

Actually I was talking about the specifics of how I am getting the data. What I am really needing is a way to modify the data in postgres using postgres sql.