This tag is used to define a report criterion.
Attributes
| Name | Description | Values |
|---|
| criteriatype (deprecated from R16.2) | The criterion type. | 0,1,2,single |
| label | The criterion label. | Any |
| extralabel | The criterion extra label. | Any |
| tooltip (deprecated from R16.2) | The criterion tool tip. | Any |
| hibernatefield (deprecated from R16.2) | The criterion hibernate field. | Any |
| entitytablename | The criterion entity table name. | Any |
| entityfieldname | The criterion entity field name. | Any |
| displaytable (deprecated from R16.2) | The criterion display table. | Any |
| displaylabel (deprecated from R16.2) | The criterion display label. | Any |
| displayfield (deprecated from R16.2) | The criterion display field. | Any |
| fieldtype | The criterion field type. Specified only if componentType is inputText | FTXSTRING. FTXINTEGER, FTXFLOAT |
| fieldsize (deprecated from R16.2) | The criterion field size. | Any |
| sourcealias (deprecated from R16.2) | The criterion source alias. | Any |
| displayalias (deprecated from R16.2) | The criterion display alias. | Any |
| datasetname (deprecated from R16.2) | The criterion dataset name. | Any |
| lookupname (deprecated from R16.2) | The criterion lookup name | Any |
| treename (deprecated from R16.2) | The criterion tree name. | Any |
| multiselect (deprecated from R16.2) | Defines if the criterion can be multi selected. | 0 = No, 1 = Yes |
| isMandatory | Defines if the criterion can is mandatory. | 0 = No, 1 = Yes |
| componentType | Defines the ui component type | inputText, calendar, selectcheckboxmenu , autocomplete, select |
| className | Defines the class of the filter object | Any |
| managedbeanname | Defines the bean that handles the execution of "method" or "onChangeMethod" | Any |
| method | Defines the method that executed when searching for a specific value | Any |
| displayvalue | Defines the filter object value that will show in ui | Any |
| disableSelectOneMenuEmptyOption | Defines if you want to disable empty option for a select box | 0 = No, 1 = Yes |
| onChangeMethodName | Defines the method that will execute on change of the criterion in ui | Any |
Examples
Criterion with componentType inputText
<criterion>
<label>key_rewards_participant_age_range</label>
<extralabel>key_rewards_participant_age_range</extralabel>
<entitytablename>EXTRACT(YEAR FROM CURRENT_DATE) - COALESCE(CONTACTINFORMATION</entitytablename>
<entityfieldname>CIYEAROFBIRTH,EXTRACT(YEAR FROM CURRENT_DATE))</entityfieldname>
<fieldtype>ftXInteger</fieldtype>
<componentType>inputText</componentType>
<multiselect>0</multiselect>
<isMandatory>0</isMandatory>
</criterion>
Criterion with componentType calendar
<criterion>
<label>key_termination_date</label>
<extralabel>key_termination_date</extralabel>
<entitytablename>REWARDPARTICIPANTS</entitytablename>
<entityfieldname>REWPARTTERMINATIONDATE</entityfieldname>
<componentType>calendar</componentType>
<isMandatory>0</isMandatory>
</criterion>
Criterion with componentType selectcheckboxmenu
<criterion>
<label>key_rewards_participant_gender</label>
<extralabel>key_rewards_participant_gender</extralabel>
<entitytablename>CONTACTINFORMATION</entitytablename>
<entityfieldname>CIGENDER</entityfieldname>
<isMandatory>0</isMandatory>
<managedbeanname>subscriptionChangeAccountView</managedbeanname>
<method>getGenderOptions</method>
<componentType>selectcheckboxmenu</componentType>
<className>com.crm.dataobject.contactinfo.Gender</className>
</criterion>
Criterion with componentType autocomplete
<criterion>
<label>key_sign_up_unit</label>
<extralabel>key_sign_up_unit</extralabel>
<entitytablename>OUUNITS</entitytablename>
<entityfieldname>OUUID</entityfieldname>
<componentType>autocomplete</componentType>
<managedbeanname>genericReportView</managedbeanname>
<method>searchUnits</method>
<isMandatory>0</isMandatory>
<className>com.crm.dataobject.networkmanagement.CRMDOUnit</className>
</criterion>
Methods
CRM.COM Software includes the following methods for making criteria. All methods can be found in
/crm-ui/src/main/java/com/crm/beans/reports/GenericReportView.java class
| Methods |
|---|
searchAccountClassifications(String)
searchAccountingPeriods(String)
searchAccountReceivables(String)
searchAdditiveDiscountDefinitions(String)
searchContactInfoCategories(String)
searchContactInformation(String)
searchCountries(String)
searchFinancialTransactionTypes(String)
searchIndustries(String)
searchIndustrySectors(String)
searchLeadStatuses(String)
searchLeadTypes(String)
searchMethod(String)
searchProductBrands(String)
searchProductCategories(String)
searchProductFamilies(String)
searchProducts(String)
searchProductTypes(String)
searchServiceRequestCategories(String)
searchServiceRequestFinalResCategories(String)
searchServiceRequestResponseCategories(String)
searchServiceRequestStatuses(String)
searchServiceRequestTempResCategories(String)
searchServiceRequestTypes(String)
searchSubscriptionType(String)
searchVoucherTypes(String)
getReportNetflixChargeStatuses()
getReportNetflixChargeStatuses(String)
getReportOperatorAcknowledgementStatuses()
getReportOperatorAcknowledgementStatuses(String)
getReportProvisioningRequestTypeCodes()
getReportProvisioningRequestTypeCodes(String)
getServiceRequestImpactLevelOptions()
getServiceRequestLifeCycleStateOptions()
getServiceRequestPriorityLevelOptions()
getServiceRequestUrgencyLevelOptions()
getKYCProfileOptions()
getKYCProfileVerificationStateOptions()
getLeadImportanceLevelOptions()
getLeadLifeCycleStateOptions()
getLeadPriorityLevelOptions()
getMandatoryFields()
getNetflixMonthOptions()
getPaymentPreferenceTypeOptions()
getPhoneTypeOptions()
getPresentmentPreferenceTypeOptions()
getEmailTypeOptions()
getFinancialTransactionClassificationOptions()
getGenderOptions()
getConsentStateOptions()
getContactInformationLifeCycleStateOptions()
getContactInformationTypeOptions()
getCreditLimitStatusOptions()
getCreditRatingOptions()
getAccountLifeCycleStateOptions()
getAdditiveDiscountClassificationOptions()
getAdditiveDiscountTypeOptions()
getAddressTypeOptions()
getActiveInactiveOptions()
getBillingTermSchemeCodeOptions()
getBillingTermSchemeCodeOptions(BillType)
getBillingTermSchemeOptions()
getCountryOptions()
getCurrencyOptions()
getDaysOfMonthOptions()
getHourOptions()
getJobTypeOptions()
getLanguageOptions()
getMinuteOptions()
getMonthOptions()
getNormalBillingTermSchemeCodeOptions()
getSubscriptionTypeOptions()
getUnitOfTimeOptions()
getWeekdayOptions()
getYearOptions()
loadMonthNumberOptions()
loadYearOptions()
searchCommunities(String)
searchGroups(String)
searchUnitGroups(String)
searchUnits(String)
searchUsers(String) |
For creating your own methods you can make a class that will extends GenericReportView.java and make your own implementation