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.

ORMSearchOffline Argument Reference

query_text
Required

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

Name of the entity to be searched.

fieldss_to_be_selected
Required

Fields to be returned as keys in the resultant struct.

fields
Required

Fields in which search has to be performed.

optionMap

extra options

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