Background
Custom queries allow a power user to add information to a Decision Step by querying the database as the Decision Step is being instantiated.
If the Custom Query throws an error or does not return information as expected, it can cause other processes to fail.
This spec cycles through each method listed under custom query dropdown, and ensures that each query returns a result without errors.
Specification
The current list of custom queries tested by this spec is as follows:
"Attachment",
"AttachmentTemplate",
"Bankruptcy",
"BidAtSale",
"Borrower",
"Broker",
"BusinessRule",
"Calendar",
"Collection",
"CollectionMember",
"CollectionTemplate",
"ConfigurationEntry",
"Contact",
"ContactMethod",
"ContactTemplate",
"Contract",
"ContractProduct",
"Court",
"Debt",
"DebtCollection",
"DebtTemplate",
"Decision",
"DecisionDelay",
"DecisionDelayTemplate",
"DecisionDependency",
"DecisionStep",
"DecisionStepTemplate",
"DecisionTemplate",
"Event",
"EventQueue",
"Foreclosure",
"Geography",
"Help",
"Holiday",
"HolidayInstance",
"ImportFile",
"ImportFileQueue",
"ImportFileTemplate",
"ImportForm",
"ImportFormQuestion",
"ImportFormTemplate",
"ImportLog",
"Ledger",
"LedgerItem",
"LedgerTemplate",
"LedgerTemplateItem",
"Litigation",
"Loan",
"Matrix",
"MatrixDimension",
"MatrixFact",
"MatrixMeasure",
"Message",
"MessageRecipient",
"MessageTemplate",
"ObjectAccess",
"ObjectLink",
"ObjectQueue",
"ObjectState",
"ObjectStatus",
"ObjectSubscription",
"ObjectType",
"Organization",
"Payment",
"PaymentMessage",
"PaymentPlan",
"PaymentPlanTemplate",
"Person",
"PersonAccess",
"PersonDefault",
"Process",
"ProcessTemplate",
"ProfessionalLicense",
"Property",
"PublicRecord",
"QueueLog",
"Report",
"ReportQuery",
"ReportRequest",
"Schedule",
"Score",
"ScoreItem",
"ScoreItemTemplate",
"ScoreTemplate",
"SecurityAccess",
"ServiceBroker",
"ServiceRequest",
"SLSLoan",
"SmartWorklist",
"SmartWorklistMember",
"SmartWorklistTemplate",
"State",
"SystemDefault",
"SystemFunction",
"SystemMember",
"SystemPermission",
"SystemRole",
"Valuation",
"ValuationComparable"