Possible to write a JQL Query that references the creation date of Organization

[James K_]

Hello,

We are trying to give more attention to new customers that have opened a limited number of support tickets.  To do this we'd like to create a JQL query (ideally informing a report), based on customers that are under a certain threshold old that have opened a certain number of tickets.  Is it possible to write a query that looks up the age of certain values (such as organization)?  The query would ideally return the number of customers that are X (or less) days old with Y (or less) number of submitted tickets.

If this isn't possible based on the customer organization field, does anyone have any suggestions on how to accomplish something similiar?

Thanks,
James

[Alex Koxaras _Relational_ · Accepted solution]

Hi @James K_ 

To my knowledge, the date of customer organization creation is not somewhere accessible to us (if stored anywhere). In addition to that, JQL searches for issues and other fields related to issues. The date to which an organization is created is not stored on an issue. Therefore you couldn't write any JQL to bring the customers. JQL yields only issues results.