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