Query Packager

AEM-Commons 설치 필요

 

AEM-Commons > Content Packagers

http://localhost:4502/miscadmin#/etc/acs-commons/packagers

 

NEW > Query Packager

 

Query Packager

 

Query Packager - Edit

 

Query : 

select * from [dam:Asset] as da where isdescendantnode(da, '/content/dam') and da.[jcr:content/jcr:lastModified] >= cast('1999-01-01T00:00:00.000+09:00' as date) and da.[jcr:content/jcr:lastModified] < cast('1999-12-31T11:00:00.000+09:00' as date)
and da.[jcr:content/cq:lastReplicationAction]='Activate'


[Content]
select * from [cq:Page] as da where isdescendantnode(da, '/content/[project]') and da.[jcr:content/cq:lastModified] >= cast('1999-01-01T00:00:00.000+09:00' as date) and da.[jcr:content/cq:lastModified] < cast('1999-12-31T11:00:00.000+09:00' as date)

[DAM Assets]
select * from [dam:Asset] as da where isdescendantnode(da, '/content/dam/[project]') and da.[jcr:content/jcr:lastModified] >= cast('1999-01-01T00:00:00.000+09:00' as date) and da.[jcr:content/jcr:lastModified] < cast('1999-12-31T11:00:00.000+09:00' as date)

[Tag]
select * from [cq:Tag] as da where isdescendantnode(da, '/etc/tags/[project]') and da.[jcr:created] >= cast('1999-01-01T00:00:00.000+09:00' as date) and da.[jcr:created] < cast('1999-12-31T11:00:00.000+09:00' as date)

 

쿼리 작성 후 [Preview] 로 확인 가능

 

[Create Package] 실행시 해당 조건에 맞는 리스트가 Filter로 추가된 패키지가 생성됨

 

패키지 매니저에서 빌드 진행