ormSearch

Searches for given text in specific properties or entities.

ormSearch('query_text', 'entityName') ormSearch('query_text', 'entityName', fields) ormSearch('query_text', 'entityName', fields, optionMap); → returns struct

This function requires Adobe ColdFusion 10 and up.  Not supported on Lucee, etc.

ormSearch Argument Reference

query_text
Required

The text to be searched for or a complete Lucene query.In the case of ORMSearch('query_text', 'entityName'), only Lucene query is supported. For details of Lucene query, see http://lucene.apache.org/core/old_versioned_docs/versions/3_0_0/queryparsersyntax.html

entityName
Required

Name of the entity to be searched.

fields
Required

Fields in which search has to be performed. This can be an array of strings. If you are performing a Lucene query, you need not specify this field. In other words, if you do not specify this value, a Lucene query is performed. Field name is case-sensitive.

optionMap
Required

Extra options that can be passed while executing Lucene query. The options are: Sort, Offset, maxResults

Examples sample code invoking the ormSearch function

ORM search based on Lucene query.

ormSearch('FirstName:ch*','Employee'); 
 ormSearch('ch*','Employee',['FirstName']); 
 objs = ormSearch('FirstName:ch*','Employee',[],{sort='salary',maxresults=5,offset=2});

ORM search on multiple entities.

ormSearch('john*','DeveloperEntity,UserEntity',['firstname']);

ORM search on all subentities based on Lucene query

ormSearch('john*','EmployeeEntity',['FirstName']);

ORM search in relationships

ormSearch('CategoryID.CategoryName:In*','cproducts',[]);

Fork me on GitHub