ORMSearchOffline

Performs search on the indexed properties but returns only the stored fields.For this function to work, specify indexStore=true on the properties on which you want to perform the search.

ORMSearchOffline(query_text, entityName, fields_to_be_selected);ORMSearchOffline(query_text, entityName, fields_to_be_selected, fields);ORMSearchOffline(query_text, entityName, fields_to_be_selected, fields, optionMap); → returns A struct that contains an array of structs, maxTotalRecord, fields_to_bo_selected as keys

This function requires Adobe ColdFusion. Not supported on Lucee, OpenBD, etc.

Argument Reference for the ORMSearchOffline function

query_text

Required: Yes
The text to be searched for or a complete Lucene query.For details of Lucene query, see http://lucene.apache.org/core/old_versioned_docs/versions/.

entityName

Required: Yes
Name of the entity to be searched.

fieldss_to_be_selected

Required: Yes
Fields to be returned as keys in the resultant struct.

fields

Required: Yes
Fields in which search has to be performed.

optionMap

Required: No

extra options

Required: No
can be passed while executing Lucene query. The options can be: sort, offset, maxResults

Examples sample code invoking the ORMSearchOffline function


Tag Syntax

ORMSearchOffline('FirstName:'ch*','Employee',['id','firstname']); 

Tag Syntax

In the following example, offline search is performed on the property FirstName and first name and last name are returned as keys in the resultant struct.

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

Tag Syntax

In this example, the resultObj in the query is an array of structs. The individual structs contain all the selected fields (passed as third parameter).

<cfset resultObj =ORMSearchOffline('Java Rocks', 'Book', [bookId, summary, Author.name, title],[title, short_summary])> 

Fork me on GitHub