Article Details
Id:20392
Product:finPOWER Connect
Type:NEW
Version:4.00.03
Opened:21/06/2023
Closed:03/07/2023
Released:27/09/2023
Job: J031375

Scripts; Business Layer collection classes now queryable using LINQ

The collection classes in the finBL Business Layer have been updated to include a GetAll() method that can be used with LINQ statements in scripts, as in the following example:

  Dim item As finAccountAppTypeRO 
  Dim items As List(Of finAccountAppTypeRO) 

  items = (From i In finBL.AccountAppTypes.GetAll() Order By i.Description Select i).ToList()
  For Each item In items
    finBL.DebugPrint(item.AccountAppTypeId)
  Next

The following Collection Classes have been updated:

  • finAccountAppTypes
  • finAccountRoles
  • finAccountTypes
  • finBankAccounts
  • finBranches
  • finCalendars
  • finCashRegisters
  • finCertificates
  • finClientClasses
  • finClientGroups
  • finClientTypes
  • finContactMethods
  • finCostCentres
  • finDecisionCards
  • finDepartments
  • finDocuments
  • finElements
  • finEntities
  • finExternalParties
  • finExternalPartyEmployees
  • finGlAccounts
  • finIdentificationTypes
  • finInformationLists
  • finLogSeverities
  • finMonitorCategories
  • finPageSets
  • finParameterSets
  • finPaymentMethods
  • finPaymentTypes
  • finPools
  • finPortals
  • finProductTypes
  • finQueues
  • finRateTables
  • finReportTemplates
  • finResources
  • finScripts
  • finSecuredPartyGroups
  • finSecurityCollateralClasses
  • finSecurityStmtGroups
  • finSecurityTypes
  • finStatisticTypes
  • finTaxCategories
  • finTransactionTypes
  • finUserGroups
  • finUsers
  • finWebConfigs
  • finWebSubscribers
  • finWorkflowTypes

The following Collection Classes have not been updated:

  • finBankBranches
  • finHtmlWidgets
  • finHtmlWidgetUiStyles
  • finSmartLists
  • finWorkflows