function like 'JOIN' in filter

Question

Hi,

I have 2 project. In first project, there are vehicle info issues and the second project has vehicle's problem issues and 2 project have vehicle number. I want to create report both info vehicle and how many vehicle has problem issue. If i develop software, i will join vehicle's number of 2 project. But i cannot do this in jira. Can you help about this situation?

Jack Nolddor [Sweet Bananas] · Answer

Having a common field to identify a vehicle you can query... All vehicles and their problems:

(project = "Vehicle Info" AND type = "Vehicle") OR (project = "Vehicle Problems" and type = "Problem") ORDER BY license_number, createdDate DESC

I suggest you to link somehow vehicles and their problems for better traceability.
Epic --> Story
Issue Linking
Parent --> Subtasks
Issue Picker Field (using 3er party apps like EasyLinks)

Gamze Ercan Kaya · Answer

Also there is no relation like parent child.