Expand query result in Node Browser

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

cyrose22

Hi guys,

How to expand the query result in the node browser? it says showing first 100 only? can anyone help me on this? And on the select query, what values will be use for the IN_TREE parameter? '

Example: SELECT * FROM cmis:document WHERE IN_TREE('5e9ad63d-a342-4cfd-a018-014e1d9e3905'). Will I choose any of these workspace to get to the right folder? which one? parent or reference? (Please see photo below) and 

I just want only to display thse pdf file items only. Can someone help me on this? (Please see photo below)

P.S

Im new here and Im confused on this node browser query. Sorry for the inconvenience.

Thanks

afaust

See my response in your original question regarding the IN_TREE selector.

There is no way to expand the number of results in the node browser beyond the 100 items limitation. The purpose of the tool is to test queries and use queries to find a limited number of results from an administrator's perspective, i.e. to check the state of a specific node. As such you should probably refine your query to restrict the number of results a bit further.

Otherwise I would advise you to use the JavaScript Console addon to do any kind of more elaborate query + analysis operations.