Uploaded image for project: 'ActivityInfo'
  1. AI-2006

Export in wide format fails due to Syntax error

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major - next release
    • Resolution: Fixed
    • Fix Version/s: 2.19.1801
    • Component/s: Export
    • Labels:
      None

      Description

      When a client tries to export a database in Wide format this fails.

      Steps to reproduce:

      1. Sign in with valid credentials
      2. Navigate to Data Entry Tab
      3. Select database 9376
      4. Click on Export and choose Wide format
        Expected results: Database should be exported in wide format
        Current results : Export fails

      Console shows : org.activityinfo.server.endpoint.gwtrpc.RemoteExecutionContext$FiringCallback onFailure: GetSites failed with exception QuerySyntaxException (RemoteExecutionContext.java:265)
      org.activityinfo.store.query.shared.QuerySyntaxException: Syntax error in column i1145705451 '(+ b_ir g_ir)' : Ambiguous symbol b_ir: Could refer to [UASC Protection Assistance / حماية المنفصلين Monthly Reports:Boys identified - الأولاد الذين تم التعرف عليهم], [UASC Protection Assistance / حماية المنفصلين Monthly Reports:Boys registered

        TestRail: Results

          Attachments

            Activity

              People

              • Assignee:
                jamie Jamie Whitehouse
                Reporter:
                lucy Lucy Brinks
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  TestRail: Cases