How to get the list of TCM ID of a page from all the publications at content delivery?

Question

I need the list of all the references present across all the publications for a page.

I am getting this information using PageURLCriteria: PageURLCriteria criteria= new PageURLCriteria("%" + URL, Criteria.LIKE);

It works well, if the URL is "/test/index.jsp" or "/some/index.jsp" where I get all the exact references of index.jsp from other publications.

Problem comes when I have the URL pattern as "/index.jsp" where query returns the results in thousands as it search all the "/index.jsp" from all the publications.

I have the TCM Id of my page, cant I get the list of TCM Id for this page present in other publications too?

Or any other way through which I get the references of page in other publication.

Also, I want to achieve it usiug broker query through content delivery API, I know ODATA can provide me that but somehow I can't use that.

Thanks

Answer 1

It's not clear what you want to achieve with the queries, but taking into account the information that you provide, if you want to obtain the list of pages with same id (in this example is 46, change as your needs) in vatrious publications, the way is as follows, using the ItemReferenceCriteria:

<%
//Create query
    Query myQuery = new Query();
    Criteria myCriteria = null;
    //Page Id = 46
    ItemReferenceCriteria itemReferenceCriteria = new ItemReferenceCriteria(46);
    //Page Type
    ItemTypeCriteria itemTypeCriteria = new ItemTypeCriteria(64);
    AndCriteria andCriteria = new AndCriteria(itemReferenceCriteria, itemTypeCriteria);
    myQuery.setCriteria(andCriteria);

    String[] itemURIs = myQuery.executeQuery();
    for (int i = 0; i < itemURIs.length; i++) {
        %>
        <p><%=itemURIs[i]%></p>
        <%
    } 
%>

The result is the uri's of the pages with same ID.