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


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/.


Required: Yes
Name of the entity to be searched.


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


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


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


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.


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