Jira has its own query language called JQL. Also, Jira is Turing-complete.
Have a nice day!

Can it run Doom?

@cafecortado with 5 frames per day, maybe 🤔

Well, Turing-complete is a terrible low standard. After all, can I build a Turing machine in?

I mean, sure. More powerful than a push down automaton? Can recognize a language in which #a = #b = #c in any possible order?

Now, that's not such a high bar for anything that should be usable for normal humans.

@TrayKnots we only care because Turing-completeness means huge attack surface

Also a fun fact: just like SQL, it was designed for regular people (not programmers).

Can't wait for the title "Jira engineer"

@BordedDev chatgpt, create landing page about AI meets JQL

*laughs in instant 1B+ valuation*

@kiki I'm sure it will do perfect.

@chatgpt show me the jql to fetch every ticket status and assignee

@retoor
Sure! Here's an example of a JQL query that can fetch every ticket status and assignee:

```
project = "YOUR_PROJECT_NAME" AND status = NOT "Closed"
```

Replace `"YOUR_PROJECT_NAME"` with the name of your actual project. This query will fetch all tickets in your project that are not closed, and will display the status and assignee for each ticket. Feel free to modify the query to fit your specific needs. Let me know if you need any further assistance!

@kiki check the sql skills of my chatbot @ https://snek.molodetz.nl. Email is not required, just make a dump account.

It totally understand all joins of tables by having descriptive column names. All it has is the sql schema. I did not implement functions myself.

It freaking answers everything. See screenshot, it knew that he had to do a count in message table and should do grouping to get it and join usertable. The column names and table names do not need exact naming. If I would ask for accounts it works too.

With fancy syntax highlighting + indented :)

@kiki check to what weird things it responds not matching schema at all.

Proof that you're a database bot! That such convo leads to a sql query.

next: jira is a self-contained AI and we don't have to visit jira anymore, it just does the jira by itself

@jestdotty Don't forget your favourite repo integration and maybe now the middle managers can spin themselves into oblivion

@jestdotty project management / scrum master will not be automated because there's not much to automate.