Description
This page allows you to add criteria to a selection query.
Page Preview
Page Flow Diagram
Click the diagram to manipulate and zoom. Traverse the diagram using Click-and-Drag motions. Fullscreen
Fields
LabelTypeDescriptionMandatory
NameCRITERIA_NAMEThe name of the criteria.No
ValueCRITERIA_VALUEThe value of the criteria. For fixed queries, this will be used as part of the query. For dynamic queries, the values are used for validation purposes only.No
Display NameCRITERIA_DISPLAY_NAMEThe display name of the criteriaNo
Display ValueCRITERIA_DISPLAY_VALUEThe display value of the criteriaNo
SQL Details
LabelTypeDescriptionMandatory
SQL DetailsSELECTION_QUERY_SQL_TEXTNo
Criteria
LabelTypeDescriptionMandatory
Links and Actions
Page Level Actions
LabelDescription
Add CriteriaClick the Add Criteria link to add selection criteria.
BackClick the Back link to return to the New Selection Query screen.
CancelClick the Cancel link to dismiss the page.
FinishClick the Finish link to complete the selection query creation.
Validate QueryClick the Validate Query link to validate the selection query.
Row Level Actions
LabelDescription
EditPress the Edit button to modify the criteria details.
DeletePress the Delete button to delete the criteria details.
Messages
When page is loaded
MessageMessage CatalogConfigurableConfigurable Validation Reference ID
An entity identifier cannot be null.LinkNo
An entity identifier cannot be null.LinkNo
An Exception occurred as the timeout has been reached and the transaction has been rolled back.LinkNo
An Exception occurred as the timeout has been reached and the transaction has been rolled back.LinkNo
A row identifier cannot be null.LinkNo
A row identifier cannot be null.LinkNo
More than entity of type '%1s' with key value '%2s' found in the cache.LinkNo
More than entity of type '%1s' with key value '%2s' found in the cache.LinkNo
No database access is allowed at this point.LinkNo
No database access is allowed at this point.LinkNo
No row manager set which contains the optimistic lock.LinkNo
No row manager set which contains the optimistic lock.LinkNo
When page is submitted
MessageMessage CatalogConfigurableConfigurable Validation Reference ID
A display name must be specified.LinkNo
A display value must be specified.LinkNo
A name must be specified.LinkNo
An entity identifier cannot be null.LinkNo
An error has occurred validating the selection query: %1sLinkNo
An Exception occurred as the timeout has been reached and the transaction has been rolled back.LinkNo
A query must be specified.LinkNo
A query name must be specified.LinkNo
A query type must be specified.LinkNo
A row identifier cannot be null.LinkNo
A value must be specified.LinkNo
If the query type is dynamic a page name for manual case search must be specified.LinkNo
If the query type is dynamic a page name for random case generation must be specified.LinkNo
Manual Search must not be entered when query type is Fixed.LinkNo
More than entity of type '%1s' with key value '%2s' found in the cache.LinkNo
No database access is allowed at this point.LinkNo
No row manager set which contains the optimistic lock.LinkNo
Random Generation must not be entered when query type is Fixed.LinkNo
Selection Query is valid.LinkNo
SQL text must be specified.LinkNo
The login ID %1s does not map to a user name.LinkNo
The SQL query must contain an INTO clause.LinkNo
Related Entities
Technical Information
Page IDSelectionQuery_addCriteria
LocationC:\Users\david\dev\src\esystems-inc\Curam_V8_IS\webclient\components\core\SelectionQuery\Maintain\SelectionQuery_addCriteria.uim
Page Load InterfaceSelectionQuery.listSelectionQueryCriteria, SelectionQuery.readSelectionQuery
Page Submit InterfaceSelectionQuery.validateOrUndoQuery
Linked From PagesEnter Criteria (SelectionQuery_addCriteria), Add Criteria (SelectionQuery_createCriteriaFromCreate), New Selection Query (SelectionQuery_createSelectionQuery)