Query to list macros that are used in pages which are not updated for the past two years

[Nandakumar A]

Hi Folks,

I'm looking for a postgres select query to filter out the list of macros and the pages that uses a particular macro. The filter condition for the selection queries should be 

1. pages that are not updated in the past two years

And it would be great if the results are grouped based on the macros

[Nicolai Sibler]

Welcome to the Community @Nandakumar A!

You may combine 2 queries:

The pages with a specific macro with the pages not modified in a time range.

Hope that helps!

Regards,

Nicolai