NEW3.03.00 · Released 1 May 2020
NEWfinPOWER Connect
Released in
3.03.00
1 May 2020
  1. Opened9 Apr
  2. Closed9 Apr
  3. Released1 May
Article 16889 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.