Searching entities through custom attribute value.

If you need to search Users who has particular custom attribute value .Using liferay expando API ,this can be acheived easly as follows.

String attrValue ="IT";

 

String attributeName ="user-department-name";

 

String tableName = ExpandoTableConstants.DEFAULT_TABLE_NAME;

 

long classNameId = ClassNameLocalServiceUtil.getClassNameId(User.class);

 

 

List<ExpandoValue> expandoValues =ExpandoValueLocalServiceUtil.getColumnValues(companyId, classNameId, tableName, attributeName, attrValue, -1,-1);

 

 

for(ExpandoValue expandoValue:expandoValues)

 

  try {

      long userId = expandoValue.getClassPK();

      User user  =UserLocalServiceUtil.getUser(userId);

  }

  catch(NoSuchUserException nsue) {

 

   _log.error("No Such User Exist");

  }

}

 

 

[Suyash Bhalekar]

Thanks Sushil

[James Falkner]

Wow, how did I not see this!! Thanks Sushil, super helpful!

[Aravinth Kumar]

Thanks sushil.It worked for me.