ProcCategoryPolicyParameter::addVendorFilterForCategoryPolicyRule Method
Adds joins, conditionally, to the specified query build data sources.
Syntax
client server public static void addVendorFilterForCategoryPolicyRule(
RefRecId _le,
RefRecId _ou,
Query _query,
QueryBuildDataSource _parentDStoJoinCategoryPolicyParameterTo,
FieldId _procurementCategoryFieldIdOnParent,
QueryBuildDataSource _parentDStoJoinStatusTo,
FieldId _vendorCategoryFieldIdOnParent)
Run On
Called
Parameters
- _le
Type: RefRecId Extended Data Type
An instance of the RefRecId class for the CompanyInfo table to represent the legal entity.
- _ou
Type: RefRecId Extended Data Type
An instance of the RefRecId class that represents the operating unit.
- _query
Type: Query Class
A query object in which to add the vendor status filter.
- _parentDStoJoinCategoryPolicyParameterTo
Type: QueryBuildDataSource Class
A query build data source in which to conditionally join the ProcCategoryPolicyParameter table.
- _procurementCategoryFieldIdOnParent
Type: FieldId Extended Data Type
The field ID of a column in the given _parentDStoJoinCategoryPolicyParameterTo parameter that represents the record ID of the procurement category.
- _parentDStoJoinStatusTo
Type: QueryBuildDataSource Class
The query build data source in which to conditionally join the VendProcurementCategoryStatus table.
- _vendorCategoryFieldIdOnParent
Type: FieldId Extended Data Type
The field ID of a column on the given _parentDStoJoinStatusTo parameter that represents the record ID of the vendor category.
Remarks
If category policy rule is found, there are two things that occur. First, an inner join to the ProcCategoryPolicyParameter table is added. The inner join is between the _parentDStoJoinCategoryPolicyParameterTo parameter and the ProcCategoryPolicyParameter table on the procurement category record ID fields.
Second, an outer join to the VendProcurementCategoryStatus table is added.
The outer join is between the _parentDStoJoinStatusTo parameter and the ProcCategoryPolicyParameter table on the vendor category record ID fields.