Searching within CRXDE (AEM)

In CRXDE there is a good search tool.  Go to Tools - Query

    Type: SQL2
    Path: / <or a sub path to limit the search if you want to>
    Text: <The text to search on>

Click Generate to a search that looks something like this,

    SELECT * FROM [nt:base] AS s WHERE CONTAINS(s.*, 'asdf')

This is a default search, click Execute to run it.

If you want to search for a particular value you can manually alter the search and click Execute.  A search for all the cq:commerceProvider values that equal 'geometrixx' is done as follows,

    SELECT * FROM [nt:base] AS s WHERE CONTAINS(s.[cq:commerceProvider], 'geometrixx')