# JCR query to get all documents path based on document type and path and which are published documents only

**URL:** <https://community.bloomreach.com/t/jcr-query-to-get-all-documents-path-based-on-document-type-and-path-and-which-are-published-documents-only/3981>\
**Category:** Content SaaS\
**Tags:** academy-content-paas\
**Created:** [June 13, 2023, 1:14pm UTC](https://community.bloomreach.com/t/jcr-query-to-get-all-documents-path-based-on-document-type-and-path-and-which-are-published-documents-only/3981 "2023-06-13T13:14:58Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Bhargava](https://avatars.discourse-cdn.com/v4/letter/b/77aa72/32.png) [@Bhargava](https://community.bloomreach.com/u/Bhargava)\
**Post date:** [June 13, 2023, 1:14pm UTC](https://community.bloomreach.com/t/jcr-query-to-get-all-documents-path-based-on-document-type-and-path-and-which-are-published-documents-only/3981/1 "2023-06-13T13:14:58Z")

</div>

Hi Team,

can anyone give the query to get all documents path based on document type and path and which are published documents only.

---

<div class="post-metadata">

**Author:** ![jeroen.hoffman](https://yyz1.discourse-cdn.com/flex027/user_avatar/community.bloomreach.com/jeroen.hoffman/32/43_2.png) [@jeroen.hoffman](https://community.bloomreach.com/u/jeroen.hoffman)\
**Post date:** [June 15, 2023, 8:08am UTC](https://community.bloomreach.com/t/jcr-query-to-get-all-documents-path-based-on-document-type-and-path-and-which-are-published-documents-only/3981/2 "2023-06-15T08:08:54Z")

</div>

Hi,  
For the delivery side, the hippo:availability property can be used, as in  
`//element(*, mynamespace:mydoctype)[@hippo:availability='live']`

Cheers, Jeroen

---

<div class="post-metadata">

**Author:** ![Bhargava](https://avatars.discourse-cdn.com/v4/letter/b/77aa72/32.png) [@Bhargava](https://community.bloomreach.com/u/Bhargava)\
**Post date:** [June 16, 2023, 5:52am UTC](https://community.bloomreach.com/t/jcr-query-to-get-all-documents-path-based-on-document-type-and-path-and-which-are-published-documents-only/3981/3 "2023-06-16T05:52:42Z")

</div>

Thank u @jeroen.hoffman