This tag is used to define a report criterion.
Attributes
| Name | Description | Values |
|---|
| criteriatype (deprecated from R16.2) | The type of the criterion. | 0,1,2,single |
| label | The label that will be displayed on the specific criteria input. | Any |
| entitytablename | The table name of the entity. | Any |
| entityfieldname | The field name of the entity. | Any |
| fieldtype | The criterion field type. Specified only if componentType is inputText | FTXSTRING. FTXINTEGER, FTXFLOAT |
| isMandatory | Defines if the criterion is mandatory. | 0 = No, 1 = Yes |
| componentType | Defines the UI component type | inputText, calendar, selectcheckboxmenu , autocomplete, select |
| className | Defines the Java class of the enity | Any |
| managedbeanname | Defines the managed bean that handles the execution of the "method" or "onChangeMethod" | Any |
| method | Defines the method that is executed when searching for a specific value | Any |
| displayvalue | Defines the value that will be displayed on the select box | Any |
| disableSelectOneMenuEmptyOption | Disables the empty option for the select box | 0 = No, 1 = Yes |
| onChangeMethodName | Defines the Java method that will be executed on change of the criterion value | 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