Bizzdesign logo
  • Contact us
    Alfabet Support Hopex Support Horizzon Support Unify Support
  • Bizzdesign Community
  • Bizzdesign University
  • Bizzdesign
 
  1. Alfabet help
  2. Solution Configuration Changes between Alfabet 10.15 and Alfabet 11.8
  3. Changes to query building
  • What is different when configuring Alfabet 11?
  • Changes for working with Alfabet Expand Windows
  • Changes to the configuration of the class model
  • Content areas substitute object views and guide views
  • Changes to the configuration of data workbenches
  • Changes to the configuration of the user interface
  • Changes to styling of the user interface
  • Changes to query building
  • Changes to configured reports
  • Changes to the generation of AMM
  • AlfaBot no longer supported
  • Other configuration changes

Changes to query building

  • A number of new Alfabet parameters are now available for use in queries executed on the Alfabet database:
    • @BASES returns the REFSTR values of all objects currently listed in a data workbench. @BASES can be used in IN statements of queries defined for configured reports assigned to a data workbench report group. The parameter requires that the Apply to Class attribute of the configured report is not set. It compares a single REFSTR to the list of REFSTR values. Therefore it cannot be used with reference array properties in WHERE statements of Alfabet query language.
    • @CURRENT_THEME: Returns the UI theme the user currently selected for display of the user interface. This is for future use in configured reports to substitute the concept of color rules with coloring responding to customer themes.
    • @ALIASNAME: Returns the name of the server alias used for the Alfabet database connection to execute the query.
    • @ALIASCAPTION: Returns the caption of the server alias used for the Alfabet database connection to execute the query.
  • The Alfabet instruction LinkAssignment has a new target type DataWorkbench . For data workbenches, filters can be set in the instruction in the same way as they are already available for configured reports. The query of the data workbench must then be defined to include WHERE statements with parameter definitions.
  • Not all instructions are currently supported. Click for information about support for each instruction.

Alfabet Resources

  • Support
  • Learning Portal
  • Downloads
  • Announcements
  • Release Lifecycle
  • Cloud Availability

Support

  • Alfabet Help
  • Hopex Help
  • Horizzon Help
  • Unify Help
  • Knowledge Base

Resources

  • Bizzdesign Community
  • Courses and E-learning
  • Blog Articles
  • Events & Webinars
  • Resource Center

Company

  • Bizzdesign
  • Alfabet Support Policy
  • Hopex Support Policy
  • Privacy Policy
  • Code of Ethics
  • Legal Notices

Copyright © Bizzdesign