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

Search with SQL view broken

    XMLWordPrintable

Details

    • CP: sprint 65
    • 1
    • 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

            Activity

              People

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

                Dates

                  Created:
                  Updated:
                  Resolved:

                  TestRail: Runs

                    TestRail: Cases