[SOLVED] How List all assets (of a type) from Webcenter Sites

How List all assets (of a type) from Webcenter Sites

I want print or export all Pages that haven't fill a concrete attribute, but I want make a "debug" CSElement that print all elements of indicate type (in this case -> Page) with all attributes, any can help me with this?

Solution

You can query the table Page and PageAttribute to get what you want. Use tag ics:sql like this for example:

 <%
 String your_query = "select * from Page,PageAttribute";
 String result_list= "";
 %>
 <ics:sql sql='<%= your_query %>' table="Page,PageAttribute" listname="result_list"/> 

 <ics:if condition='<%=ics.GetList("result_list")!=null && ics.GetList("result_list").hasData()%>'><ics:then>
        <ics:listloop listname="result_list">
              <ics:listget listname="result_list" fieldname="name" output="result"/>
              <% result_list+= " '"+ics.GetVar("result")+"' ,"; %>
        </ics:listloop>
</ics:then></ics:if>