The latest version of the Qalcwise platform introduces a number of improvements that will be especially appreciated by application builders, administrators, and advanced users. Qalcwise 2.3 includes, among others, new formulas, additional debugging capabilities, more convenient management of scheduled jobs, and changes that improve daily work with data and grids.
Below, we present the most interesting changes introduced in Qalcwise 2.3.
FilterXML – a new formula for working with XML data
Qalcwise 2.3 introduces a new FilterXML formula that allows you to extract data from XML text using XPath expressions. The function enables reading values of elements located within an XML structure, and the result is returned as text containing all matching values.
You can read more about the FilterXML formula here: https://qalcwise.zendesk.com/hc/pl/articles/26905895771804-FilterXML
RowNumber – row numbering in a table
The new RowNumber formula returns the number of the current row in a table according to the current data display order. The function can only be used within the table section.
You can read more about the RowNumber formula here: https://qalcwise.zendesk.com/hc/pl/articles/26909138516380-RowNumber
Change in aliases
From version 2.3 onwards, an alias name must contain at least 4 characters.
More information about aliases can be found here: https://qalcwise.zendesk.com/hc/pl/articles/213502065-Alias
Export of application instance data to XLSX
The “Export from database” action has been extended with the ability to export application instance data. The data is exported to an .xlsx file.
You can read more about how the action works here: https://qalcwise.zendesk.com/hc/pl/articles/360022087360-Krok-akcji-Eksportuj-z-bazy
Scheduled jobs available in the administration panel
A new “Scheduled jobs” tab has been added to the administration panel. It allows managing jobs directly from the panel – without the need to use the internal system.
Autocomplete instead of a dropdown list
The default behavior after dragging a field from the “Data” tab has changed. Instead of a classic dropdown list, an autocomplete field now appears in the cell.
You can read more about autocomplete cells here: https://qalcwise.zendesk.com/hc/pl/articles/212992969-Kom%C3%B3rki-autouzupe%C5%82niane
Changes in the default autocomplete formula
After dragging a field from the “Data” tab, the default lookup formula no longer includes unique().
More information can be found here:
https://qalcwise.zendesk.com/hc/pl/articles/212668025-Lookup
https://qalcwise.zendesk.com/hc/pl/articles/212096849-Unique
Number formatting in gridview
Qalcwise 2.3 introduces the ability to set number formatting for numeric columns in gridview.
Number formatting in Qalcwise gridview
More information can be found here: https://qalcwise.zendesk.com/hc/pl/articles/13381388103068-Tabela-danych-Lista-danych
Confirmation when deleting multiple records
When deleting multiple rows in gridview, a confirmation dialog is displayed showing the number of selected records.
Lookup array limit
If an array used in a lookup condition contains more than 1,000 elements, the system will display an error message.
More information about arrays can be found here: https://qalcwise.zendesk.com/hc/pl/articles/212062989-Array
New action “Set app language”
Qalcwise 2.3 introduces a new action that allows changing the application language within an instance.
More information about this action can be found here: https://qalcwise.zendesk.com/hc/pl/articles/25419028605852-Krok-akcji-Ustaw-j%C4%99zyk-apki
Detailed technical information about the application
Qalcwise 2.3 introduces the ability to view detailed technical information about an application. To use this feature, simply add the parameter &meta=true to the URL.
After adding the parameter, you can check, among others:
- instance open time,
- instance size in the database,
- amount of data sent from the server,
- lookup sizes.
Qalcwise 2.3 – more control and more convenient application management
The latest version of Qalcwise introduces a number of changes that improve both application development and daily work with data and platform administration. The new features include new formulas, additional application debugging capabilities, improvements in gridview, and more convenient management of scheduled jobs.
Qalcwise 2.3 is primarily about practical changes that help you work faster with data, better control application behavior, and more conveniently manage processes on the platform.