Codeunit SelectionFilterManagement

ID 46

Namespace: System.Text

Methods

GetSelectionFilter

Get a filter for the selected field from a provided record. Ranges will be used inside the filter were possible.

procedure GetSelectionFilter(var TempRecRef: RecordRef, SelectionFieldID: Integer): Text

Parameters

Name	Type	Description
TempRecRef	RecordRef	Record used to determine the field filter.
SelectionFieldID	Integer	The field for which the filter will be constructed.

Returns

Type	Description
Text	The filter for the provided field ID. For example, '1..3|6'.

Remarks

This method queries the database intensively, can cause perfomance issues and even cause database server exceptions. Consider using the overload with ComputeRangesUsingRecords set to false.

CreateFilterFromTempTable

procedure CreateFilterFromTempTable(var SourceTempRecRef: RecordRef, var RecRef: RecordRef, SelectionFieldID: Integer): Text

Parameters

Name	Type	Description
SourceTempRecRef	RecordRef
RecRef	RecordRef
SelectionFieldID	Integer

Returns

Type	Description
Text

AddQuotes

procedure AddQuotes(inString: Text): Text

Parameters

Name	Type	Description
inString	Text

Returns

Type	Description
Text

ReplaceString

procedure ReplaceString(String: Text, FindWhat: Text, ReplaceWith: Text): Text

Parameters

Name	Type	Description
String	Text
FindWhat	Text
ReplaceWith	Text

Returns

Type	Description
Text

GetSelectionFilterForItem

procedure GetSelectionFilterForItem(var Item: Record Item): Text

Parameters

Name	Type	Description
Item	Table Microsoft.Inventory.Item.Item

Returns

Type	Description
Text

GetSelectionFilterForServiceItem

Obsolete

This element will become obsolete from version 25.0. Replaced by same procedure in codeunit Serv. Selection Filter Mgt.

[Obsolete(Replaced by same procedure in codeunit Serv. Selection Filter Mgt.,25.0)]
procedure GetSelectionFilterForServiceItem(var ServiceItem: Record "Service Item"): Text

Parameters

Name	Type	Description
ServiceItem	Table Microsoft.Service.Item."Service Item"

Returns

Type	Description
Text

GetSelectionFilterForDimensionValue

procedure GetSelectionFilterForDimensionValue(var DimVal: Record "Dimension Value"): Text

Parameters

Name	Type	Description
DimVal	Table Microsoft.Finance.Dimension."Dimension Value"

Returns

Type	Description
Text

GetSelectionFilterForCurrency

procedure GetSelectionFilterForCurrency(var Currency: Record Currency): Text

Parameters

Name	Type	Description
Currency	Table Microsoft.Finance.Currency.Currency

Returns

Type	Description
Text

GetSelectionFilterForCustomerPriceGroup

procedure GetSelectionFilterForCustomerPriceGroup(var CustomerPriceGroup: Record "Customer Price Group"): Text

Parameters

Name	Type	Description
CustomerPriceGroup	Table Microsoft.Sales.Pricing."Customer Price Group"

Returns

Type	Description
Text

GetSelectionFilterForLocation

procedure GetSelectionFilterForLocation(var Location: Record Location): Text

Parameters

Name	Type	Description
Location	Table Microsoft.Inventory.Location.Location

Returns

Type	Description
Text

GetSelectionFilterForGLAccount

procedure GetSelectionFilterForGLAccount(var GLAccount: Record "G/L Account"): Text

Parameters

Name	Type	Description
GLAccount	Table Microsoft.Finance.GeneralLedger.Account."G/L Account"

Returns

Type	Description
Text

GetSelectionFilterForGLAccountCategory

procedure GetSelectionFilterForGLAccountCategory(var GLAccountCategory: Record "G/L Account Category"): Text

Parameters

Name	Type	Description
GLAccountCategory	Table Microsoft.Finance.GeneralLedger.Account."G/L Account Category"

Returns

Type	Description
Text

GetSelectionFilterForCustomer

procedure GetSelectionFilterForCustomer(var Customer: Record Customer): Text

Parameters

Name	Type	Description
Customer	Table Microsoft.Sales.Customer.Customer

Returns

Type	Description
Text

GetSelectionFilterForContact

procedure GetSelectionFilterForContact(var Contact: Record Contact): Text

Parameters

Name	Type	Description
Contact	Table Microsoft.CRM.Contact.Contact

Returns

Type	Description
Text

GetSelectionFilterForVendor

procedure GetSelectionFilterForVendor(var Vendor: Record Vendor): Text

Parameters

Name	Type	Description
Vendor	Table Microsoft.Purchases.Vendor.Vendor

Returns

Type	Description
Text

GetSelectionFilterForResource

procedure GetSelectionFilterForResource(var Resource: Record Resource): Text

Parameters

Name	Type	Description
Resource	Table Microsoft.Projects.Resources.Resource.Resource

Returns

Type	Description
Text

GetSelectionFilterForInventoryPostingGroup

procedure GetSelectionFilterForInventoryPostingGroup(var InventoryPostingGroup: Record "Inventory Posting Group"): Text

Parameters

Name	Type	Description
InventoryPostingGroup	Table Microsoft.Inventory.Item."Inventory Posting Group"

Returns

Type	Description
Text

GetSelectionFilterForGLBudgetName

procedure GetSelectionFilterForGLBudgetName(var GLBudgetName: Record "G/L Budget Name"): Text

Parameters

Name	Type	Description
GLBudgetName	Table Microsoft.Finance.GeneralLedger.Budget."G/L Budget Name"

Returns

Type	Description
Text

GetSelectionFilterForBusinessUnit

procedure GetSelectionFilterForBusinessUnit(var BusinessUnit: Record "Business Unit"): Text

Parameters

Name	Type	Description
BusinessUnit	Table Microsoft.Finance.Consolidation."Business Unit"

Returns

Type	Description
Text

GetSelectionFilterForICPartner

procedure GetSelectionFilterForICPartner(var ICPartner: Record "IC Partner"): Text

Parameters

Name	Type	Description
ICPartner	Table Microsoft.Intercompany.Partner."IC Partner"

Returns

Type	Description
Text

GetSelectionFilterForCashFlow

procedure GetSelectionFilterForCashFlow(var CashFlowForecast: Record "Cash Flow Forecast"): Text

Parameters

Name	Type	Description
CashFlowForecast	Table Microsoft.CashFlow.Forecast."Cash Flow Forecast"

Returns

Type	Description
Text

GetSelectionFilterForCashFlowAccount

procedure GetSelectionFilterForCashFlowAccount(var CashFlowAccount: Record "Cash Flow Account"): Text

Parameters

Name	Type	Description
CashFlowAccount	Table Microsoft.CashFlow.Account."Cash Flow Account"

Returns

Type	Description
Text

GetSelectionFilterForCostBudgetName

procedure GetSelectionFilterForCostBudgetName(var CostBudgetName: Record "Cost Budget Name"): Text

Parameters

Name	Type	Description
CostBudgetName	Table Microsoft.CostAccounting.Budget."Cost Budget Name"

Returns

Type	Description
Text

GetSelectionFilterForCostCenter

procedure GetSelectionFilterForCostCenter(var CostCenter: Record "Cost Center"): Text

Parameters

Name	Type	Description
CostCenter	Table Microsoft.CostAccounting.Account."Cost Center"

Returns

Type	Description
Text

GetSelectionFilterForCostObject

procedure GetSelectionFilterForCostObject(var CostObject: Record "Cost Object"): Text

Parameters

Name	Type	Description
CostObject	Table Microsoft.CostAccounting.Account."Cost Object"

Returns

Type	Description
Text

GetSelectionFilterForCostType

procedure GetSelectionFilterForCostType(var CostType: Record "Cost Type"): Text

Parameters

Name	Type	Description
CostType	Table Microsoft.CostAccounting.Account."Cost Type"

Returns

Type	Description
Text

GetSelectionFilterForCampaign

procedure GetSelectionFilterForCampaign(var Campaign: Record Campaign): Text

Parameters

Name	Type	Description
Campaign	Table Microsoft.CRM.Campaign.Campaign

Returns

Type	Description
Text

GetSelectionFilterForEmployee

procedure GetSelectionFilterForEmployee(var Employee: Record Employee): Text

Parameters

Name	Type	Description
Employee	Table Microsoft.HumanResources.Employee.Employee

Returns

Type	Description
Text

GetSelectionFilterForLotNoInformation

procedure GetSelectionFilterForLotNoInformation(var LotNoInformation: Record "Lot No. Information"): Text

Parameters

Name	Type	Description
LotNoInformation	Table Microsoft.Inventory.Tracking."Lot No. Information"

Returns

Type	Description
Text

GetSelectionFilterForPackageNoInformation

procedure GetSelectionFilterForPackageNoInformation(var PackageNoInformation: Record "Package No. Information"): Text

Parameters

Name	Type	Description
PackageNoInformation	Table Microsoft.Inventory.Tracking."Package No. Information"

Returns

Type	Description
Text

GetSelectionFilterForSerialNoInformation

procedure GetSelectionFilterForSerialNoInformation(var SerialNoInformation: Record "Serial No. Information"): Text

Parameters

Name	Type	Description
SerialNoInformation	Table Microsoft.Inventory.Tracking."Serial No. Information"

Returns

Type	Description
Text

GetSelectionFilterForCustomerDiscountGroup

procedure GetSelectionFilterForCustomerDiscountGroup(var CustomerDiscountGroup: Record "Customer Discount Group"): Text

Parameters

Name	Type	Description
CustomerDiscountGroup	Table Microsoft.Sales.Pricing."Customer Discount Group"

Returns

Type	Description
Text

GetSelectionFilterForItemDiscountGroup

procedure GetSelectionFilterForItemDiscountGroup(var ItemDiscountGroup: Record "Item Discount Group"): Text

Parameters

Name	Type	Description
ItemDiscountGroup	Table Microsoft.Inventory.Item."Item Discount Group"

Returns

Type	Description
Text

GetSelectionFilterForItemCategory

procedure GetSelectionFilterForItemCategory(var ItemCategory: Record "Item Category"): Text

Parameters

Name	Type	Description
ItemCategory	Table Microsoft.Inventory.Item."Item Category"

Returns

Type	Description
Text

GetSelectionFilterForIssueReminder

procedure GetSelectionFilterForIssueReminder(var ReminderHeader: Record "Reminder Header"): Text

Parameters

Name	Type	Description
ReminderHeader	Table Microsoft.Sales.Reminder."Reminder Header"

Returns

Type	Description
Text

GetSelectionFilterForWorkflowStepInstance

procedure GetSelectionFilterForWorkflowStepInstance(var WorkflowStepInstance: Record "Workflow Step Instance"): Text

Parameters

Name	Type	Description
WorkflowStepInstance	Table System.Automation."Workflow Step Instance"

Returns

Type	Description
Text

GetSelectionFilterForWorkflowBuffer

procedure GetSelectionFilterForWorkflowBuffer(var TempWorkflowBuffer: Record "Workflow Buffer" temporary): Text

Parameters

Name	Type	Description
TempWorkflowBuffer	Table System.Automation."Workflow Buffer"

Returns

Type	Description
Text

GetSelectionFilterForResponsibilityCenter

procedure GetSelectionFilterForResponsibilityCenter(var ResponsibilityCenter: Record "Responsibility Center"): Text

Parameters

Name	Type	Description
ResponsibilityCenter	Table Microsoft.Inventory.Location."Responsibility Center"

Returns

Type	Description
Text

GetSelectionFilterForSalesPersonPurchaser

procedure GetSelectionFilterForSalesPersonPurchaser(var SalespersonPurchaser: Record "Salesperson/Purchaser"): Text

Parameters

Name	Type	Description
SalespersonPurchaser	Table Microsoft.CRM.Team."Salesperson/Purchaser"

Returns

Type	Description
Text

GetSelectionFilterForItemVariant

procedure GetSelectionFilterForItemVariant(var ItemVariant: Record "Item Variant"): Text

Parameters

Name	Type	Description
ItemVariant	Table Microsoft.Inventory.Item."Item Variant"

Returns

Type	Description
Text

GetSelectionFilterForFixedAsset

procedure GetSelectionFilterForFixedAsset(var FixedAsset: Record "Fixed Asset"): Text

Parameters

Name	Type	Description
FixedAsset	Table Microsoft.FixedAssets.FixedAsset."Fixed Asset"

Returns

Type	Description
Text

GetSelectionFilterForSalesHeader

procedure GetSelectionFilterForSalesHeader(var SalesHeader: Record "Sales Header"): Text

Parameters

Name	Type	Description
SalesHeader	Table Microsoft.Sales.Document."Sales Header"

Returns

Type	Description
Text

GetSelectionFilterForPurchaseHeader

procedure GetSelectionFilterForPurchaseHeader(var PurchaseHeader: Record "Purchase Header"): Text

Parameters

Name	Type	Description
PurchaseHeader	Table Microsoft.Purchases.Document."Purchase Header"

Returns

Type	Description
Text

GetSelectionFilterForTransferHeader

procedure GetSelectionFilterForTransferHeader(var TransferHeader: Record "Transfer Header"): Text

Parameters

Name	Type	Description
TransferHeader	Table Microsoft.Inventory.Transfer."Transfer Header"

Returns

Type	Description
Text

GetSelectionFilterForAggregatePermissionSetRoleId

procedure GetSelectionFilterForAggregatePermissionSetRoleId(var AggregatePermissionSet: Record "Aggregate Permission Set"): Text

Parameters

Name	Type	Description
AggregatePermissionSet	Table System.Security.AccessControl."Aggregate Permission Set"

Returns

Type	Description
Text

GetSelectionFilterForJob

procedure GetSelectionFilterForJob(var Job: Record Job): Text

Parameters

Name	Type	Description
Job	Table Microsoft.Projects.Project.Job.Job

Returns

Type	Description
Text

GetSelectionFilterForJobTask

procedure GetSelectionFilterForJobTask(var JobTask: Record "Job Task"): Text

Parameters

Name	Type	Description
JobTask	Table Microsoft.Projects.Project.Job."Job Task"

Returns

Type	Description
Text

GetSelectionFilter

Get a filter for the selected field from a provided record. Ranges will be used inside the filter were possible. The values in the selected field must be unique and sorted in ascending order.

procedure GetSelectionFilter(var SourceRecRef: RecordRef, SelectionFieldID: Integer, ComputeRangesUsingRecords: Boolean): Text

Parameters

Name	Type	Description
SourceRecRef	RecordRef	Record used to determine the field filter.
SelectionFieldID	Integer	The field for which the filter will be constructed.
ComputeRangesUsingRecords	Boolean	Specify if the computations should be performed on records, or in-memory structures. If the parameter is false, the database load is greatly reduced, but the memory footprint is bigger

Returns

Type	Description
Text	The filter for the provided field ID. For example, '1..3|6'.

GetMaximumNumberOfParametersInSQLQuery

procedure GetMaximumNumberOfParametersInSQLQuery(): Integer

Returns

Type	Description
Integer

GetSelectionFilterForServiceHeader

Obsolete

This element will become obsolete from version 25.0. Replaced by same procedure in codeunit Serv. Selection Filter Mgt.

[Obsolete(Replaced by same procedure in codeunit Serv. Selection Filter Mgt.,25.0)]
procedure GetSelectionFilterForServiceHeader(var ServiceHeader: Record "Service Header"): Text

Parameters

Name	Type	Description
ServiceHeader	Table Microsoft.Service.Document."Service Header"

Returns

Type	Description
Text

See also

• Codeunit