Uploaded image for project: 'RAML Module Builder'
  1. RAML Module Builder
  2. RMB-394

Search with SQL view broken

    XMLWordPrintable

    Details

    • Template:
    • Sprint:
      CP: sprint 65
    • Story Points:
      1
    • Development Team:
      Core: Platform

      Description

      CQL2PG from RMB 25 no longer can handles views correctly.

      CQL:
      instance_holding_item_view.it_jsonb.barcode==706949453641

      SQL: 

      WHERE lower(f_unaccent(jsonb->'instance_holding_item_view'->'it_jsonb'->>'barcode')) LIKE lower(f_unaccent('706949453641'))

      should be

      WHERE lower(f_unaccent(instance_holding_item_view.it_jsonb->>'barcode')) LIKE lower(f_unaccent('706949453641'))

        TestRail: Results

          Attachments

            Issue Links

            blocks

            Task - A task that needs to be done. MODINVSTOR-285 upgrade to RMB 26 and resolve related issues

            • P2 - normal priority level, must be included in the current development cycle
            • Closed

            Task - A task that needs to be done. RMB-386 Release version 25

            • P3 - low priority level, item will be considered for inclusion in the next dev cycle
            • Closed
            relates to

            Story - Created by Jira Software - do not edit or delete. Issue type for a user story. RMB-391 Implement foreign key support for CQLPGJson Parser (two tables, parent->child)

            • P2 - normal priority level, must be included in the current development cycle
            • Closed

              Activity

                People

                Assignee:
                julianladisch Julian Ladisch
                Reporter:
                adam Adam Dickmeiss
                Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                  Dates

                  Created:
                  Updated:
                  Resolved:

                    TestRail: Runs

                      TestRail: Cases