useradmin search is not working in aem 6.4 for a particular keyword

[rahulj23509711]

We have upgraded our application from AEM 6.2 to AEM 6.4. On page localhost:4502/useradmin on AEM 6.4, the search is not working for a particular keyword which is "corporate".

AEM 6.2 gives some results for the same keyword. If I try to search the exact usergroup name e.g. corporate-site-admin; it gives that unique usergroup as a result.

	AEM 6.2	AEM 6.4
Search with keyword "corporate"
Search with keyword "corporate-site-admins"

However there is another user called activity-service. When I try to search keyword activity it gives activity-service in one of the results.

Issue is somehow only for corporate keyword.

[arunpatidar]

Hi,

Can you check:

1. Weather hide user/group is enabled?

2. make sure the keyword are correct(no white space)

3. check corporate user and group properties in JCR against activity-service user

[Peter_Puzanovs · Accepted solution]

Dear Rahul,

Thank you very much for this question, this works on my local AEM 6.4 with no problems..

When you are running user search, AEM should execute following query:

select [jcr:path], [jcr:score], * from [rep:User] AS a WHERE CONTAINS(*, 'corporate') UNION select [jcr:path], [jcr:score], * from [rep:User] AS a WHERE CONTAINS(*, 'corporate*') UNION select [jcr:path], [jcr:score], * from [rep:Group] AS a WHERE CONTAINS(*, 'corporate') UNION select [jcr:path], [jcr:score], * from [rep:Group] AS a WHERE CONTAINS(*, 'corporate*') order by lower([rep:principalName])

This would naturally fall into authorizables(/oak:index/authorizables)

Could you please verify in http://localhost:4502/libs/granite/operations/content/diagnosistools/queryPerformance.html  which query get's invoked for the term corporate in your local machine(example screenshot attached).

Could you please click on http://localhost:4502/l  to check index consistency on your local machine, button located on your top left side of the screen?

Could you please click on http://localhost:4502/system/console/jmx/org.apache.jackrabbit.oak%3Aname%3DLucene+Index+statistics%...​ and verify /oak:index/authorizables with true is giving correct results?

Does it report anything suspicious?

Regards,

Peter