AEM asset query for replication status.

[Anuj31005349h74z]

Is there a way to jcr query or sql query all the assets by the replication status? For example something like this.

type=dam:Asset
path=/content/dam
property=replication/isActivated
property.value=true

[Mahedi_Sabuj · Accepted solution]

You need to use jcr:content/cq:lastReplicationAction property to filter by the replication status. 

type=dam:Asset
path=/content/dam
property=jcr:content/cq:lastReplicationAction
property.value=Activate