Contents x
      Simple Solutions to Common Problems
      • 19 Jul 2023
      • 1 Minute to read
      • Contributors
      • Print
      • Dark
        Light
      • PDF
      Contents

      Simple Solutions to Common Problems

      • Updated on 19 Jul 2023
      • 1 Minute to read
      • Contributors
      • Print
      • Dark
        Light
      • PDF
      Article Summary

      PREPARED STATEMENTS

      ProblemSolutionReference
      The Count() function used in Prepared Statement fails to retrieve count data matching the given criteria.Use of Alias in Select queryAlias-new
      JSON extract query inside Prepared Statement returns a list with empty braces

      		Use of Alias in Select queryJson-extract

      CUSTOM CSS

      ProblemSolutionReference
      The following custom css script: float:right (to move a button component to the right of the Topbar)
      does not work in the Topbar component of the App Designer.
      problem-new      		Use the following custom css script:
      1 float: right;
2 margin-left: auto;
3

      		solution

      APP DESIGNER

      ScenarioProblemSolution Reference
      A Page comprises of two Select components mapped to two tables A and B respectively. In the UI, based on the value from table A, a set of values from table B is filtered and displayed. Whenever table A value changes the corresponding values from table B must be filtered (using the FILTER condition) and displayed.The first select component is clicked and a value is chosen. When the second select component is clicked, the filtered values are observed as expected. If the selection in first select component changes, the second select component displays an empty list.Reset the Table B values from a master copy of Table B.Add a copy script in change event of the first Select component. Now, each time selection from Table A changes, the Table B is filtered from the original master data.
      ResetFilter-new
      NAFor the Topbar and Footer component, the Heading is left-aligned by default. The user cannot center-align the Heading.To center-align the Heading, the following workaround can be done:
      1. Add a topbar component.
      2. Delete the default Heading sub-component within the topbar.
      3. Insert a Grid component inside the topbar.
      4. Modify the Grid component properties, to have only one row.
      5. Add a Text component inside the grid.
      6. In Text component properties, under Text properties, click the center-align icon to align the Text to center.
      		How to center align heading
      Was this article helpful?
      What's Next
      ESC

      Eddy, a super-smart generative AI, opening up ways to have tailored queries and responses