Dear All, Here I'll explain how to Restrict the Operators like starts with/ends with ... in ADF criteria Query VO.
The ADF Faces af:query component neatly binds to an ADF bc View criteria defined in the model.
In the default advanced mode, the query panel allows end users to select a suitable operator to apply to the query fields. The default list of these operators (of type JboCompOper) is populated based on the field's data type and ADF is rather intelligent with this feature - for example:
a) for an LOV based field, it displays an LOV if you select the Equals operator but changes to a text field when you choose the Starts-with operator...
b) It shows you two fields if you select the between operator.
In my case I'll show you the default Behavior Firstly.
The ADF Faces af:query component neatly binds to an ADF bc View criteria defined in the model.
In the default advanced mode, the query panel allows end users to select a suitable operator to apply to the query fields. The default list of these operators (of type JboCompOper) is populated based on the field's data type and ADF is rather intelligent with this feature - for example:
a) for an LOV based field, it displays an LOV if you select the Equals operator but changes to a text field when you choose the Starts-with operator...
b) It shows you two fields if you select the between operator.
In my case I'll show you the default Behavior Firstly.
Now If Yo want to restrict the Operator then Go to particular VO select the Search Field and write the below code inside the <ViewAttribute> </ViewAttribute> tag.
<ViewAttribute
Name="Ename"
PrecisionRule="true"
EntityAttrName="Ename"
EntityUsage="EmpEO"
AliasName="ENAME">
<CompOper
Name="Starts with"
Oper="STARTSWITH"
ToDo="-1"
MinCardinality="0"
MaxCardinality="0">
</CompOper>
<CompOper
Name="Ends with"
Oper="ENDSWITH"
ToDo="-1"
MinCardinality="0"
MaxCardinality="0">
</CompOper>
<CompOper
Name="Does not Contain"
Oper="DOESNOTCONTAIN"
ToDo="-1"
MinCardinality="0"
MaxCardinality="0">
</CompOper>
<CompOper
Name="Less Than"
Oper="<"
ToDo="-1"
MinCardinality="0"
MaxCardinality="0">
</CompOper>
<CompOper
Name="Less Than Or Equal to"
Oper="<="
ToDo="-1"
MinCardinality="0"
MaxCardinality="0"></CompOper>
<CompOper
Name="Does not Equal"
Oper="<>"
ToDo="-1"
MinCardinality="0"
MaxCardinality="0"></CompOper>
<CompOper
Name="Greater than"
Oper=">"
ToDo="-1"
MinCardinality="0"
MaxCardinality="0"></CompOper>
<CompOper
Name="Greater than or equal to"
Oper=">="
ToDo="-1"
MinCardinality="0"
MaxCardinality="0"></CompOper>
<CompOper
Name="Between"
Oper="BETWEEN"
ToDo="-1"
MinCardinality="0"
MaxCardinality="0"></CompOper>
<CompOper
Name="Not Between"
Oper="NOTBETWEEN"
ToDo="-1"
MinCardinality="0"
MaxCardinality="0"></CompOper>
<CompOper
Name="Is Blank"
Oper="ISBLANK"
ToDo="-1"
MinCardinality="0"
MaxCardinality="0"></CompOper>
<CompOper
Name="Is Not Blank"
Oper="ISNOTBLANK"
ToDo="-1"
MinCardinality="0"
MaxCardinality="0"></CompOper>
</ViewAttribute>
Here I am restricting the operators for EmpName field.
After Using this code you will find the below Output.
So this is the small code Which you need to change, Thanks All.
No comments:
Post a Comment