SubQueryDTO

Container that holds various number of search conditions and subQueries connected with the chosen operator.

Sub Type Property: "_type" : "SubQuery"

Fields

Type
Name
Description
Optional
Default Value
String  
entityName
The entity name of the query.
false
 
QueryOperatorType  
operator
Enum to define the operator of the query.
false
 
Boolean  
useExist
Flag to indicate if search execution should use the SQL 'EXISTS' operator.
true
false
Boolean  
useOuterJoin
Flag to indicate if search execution should perform an outer join.
true
false
Boolean  
optionalQuery
Flag to indicate if this subQuery is optional.
true
false
Boolean  
subQueryInSearchResult
Flag to indicate if the fields of the query should be included into search result.
true
false
String  
hint
The ORACLE hint.
true
null
LuceneConditionDTO  
luceneCondition
The lucene condition of the query.
true
null
List
ISubQueryDTO
subQueries
The list of subQueries.
false
 

Example

{
	"_type" : "SubQuery",
	"entityName" : "Activity",
	"operator" : "AND",
	"relationName" : null,
	"useExist" : false,
	"useOuterJoin" : false,
	"optionalQuery" : false,
	"subQueryInSearchResult" : false,
	"hint" : null,
	"luceneCondition" : {
		"query" : "Test",
		"searchOption" : "FUZZY_WILDCARD",
		"documentField" : "CONTENT"
	},
	"subQueries" : [
		{
			"_type" : "Condition",
			"attributeName" : "Subject.Activity",
			"searchResultField" : true,
			"listKey" : true,
			"defaultSearchValue" : false,
			"singleFieldSearchIdentifier" : false,
			"useCoalesce" : false,
			"function" : {
				"_type" : "Wildcard",
				"operator" : "START_WITH",
				"not" : false,
				"value" : {
					"_type" : "String",
					"value" : "Del",
					"writable" : true,
					"readable" : true,
					"status" : null
				}
			}
		}
	]
}