Skip to main content

​
App Storage Types Differ

YiDA’s underlying storage type has evolved over time. Newer storage types deliver higher performance and stronger parsing capabilities. In most cases, older apps are upgraded to the new storage automatically. However, certain type combinations cannot be upgraded automatically, so some features are temporarily unsupported.

​
Switch to High-Performance Storage

To improve YiDA report performance and resolve the request timeout issues described above, the upper limit for multi-table associations in View Tables has been raised. YiDA’s report-related data modules are currently being migrated to high-performance storage. After migration, report data query efficiency will improve several times over, and View Table capabilities will also be enhanced. In most cases, users are upgraded automatically with no action required (including on the Free plan). However, the automatic upgrade will not occur if you encounter any of the following errors.

​
CASEWHEN ERROR

  • argument of CASE/WHEN must be type boolean, not type integer
  • CASE types text and integer cannot be matched
Cause: the caseWhen condition type does not match the expected type. After the high-performance storage upgrade, the argument following WHEN must be of boolean type. Solution: adjust the argument type based on the error message.

​
Numeric ERROR

  • invalid input syntax for type numeric: “750D”
Cause: the calculation contains illegal characters, which are no longer supported after the high-performance storage upgrade. Solution: use the formula VAL() to convert text into a numerical type.

​
Math Formula ERROR

  • function sum(text) does not exist
  • function avg(text) does not exist
Cause: text values cannot be summed, averaged, or used in other numerical operations. This is no longer supported after the high-performance storage upgrade. Solution: use VAL to convert values to numbers before performing addition.

​
Logical Formula ERROR

  • operator does not exist: boolean = integer
Cause: the formula contains an equality operator. This is no longer supported after the high-performance storage upgrade. Solution: the data types on both sides do not match. Change them to the same type.