Article Details
Id:16889
Product:finPOWER Connect
Type:NEW
Version:3.03.00
Opened:09/04/2020
Closed:09/04/2020
Released:01/05/2020
Job: J024073

HTML Widgets; Grids; Support for displaying Standard Ranges in editable columns

String and Code type widget.UI.Grid columns now support displaying a dropdown list generated from a Standard Range such as Branches, Accounts or Clients:

gridClients.AddColumnString("BranchId", { caption: "Role", allowEdit: true, standardRange: "Branches", sqlWhere: "", displayColumns: "BranchId,Name", includeInactive: false });

Options applicable to Standard Ranges are:

  • standardRangeName
  • sqlWhere
  • includeInactive
  • displayColumns

NOTE: Special standard ranges such as Accounts and Clients do not display a dropdown list but instead show a search facility. Therefore, the displayColumns option may be ignored.