Versions Compared

Old Version 1

changes.mady.by.user Sofia Canario

Saved on

compared with

New Version Current

changes.mady.by.user Luis Sousa

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
languagesql
SELECT pe.property_key,p.pkey* 
FROM propertyentry pe 
JOIN project p ONon pe.entity_id = p.id 
WHERE pe.property_key = 'jira.archiving.projects'
AND p.pkey IN ('ABC','PREM'); -- Replace with your project keys