How to get last month issues

[upendra vemula]

I want to have filter to get last month issues, i mean, now we are in May, I wan to get the issues which captured in Apr, Do you have function like Created = LastMonth() ? 

[BRAgnar]

Hi, Qentin.
Note that organizations do not contain issues, they contain customers. As so you will have to look for the relationship between the tables to check what members are part of an organization and then find the issues created by these customers. It would be something like this (Postgres syntax):

select o."NAME", concat(pro.pkey,'-',ji.issuenum) from "AO_54307E_ORGANIZATION" o
join "AO_54307E_ORGANIZATION_MEMBER" om on om."ORGANIZATION_ID" = o."ID"
join jiraissue ji on ji.reporter = om."USER_KEY"
join project pro on pro.id = ji.project
where o."NAME" = 'Organization name';