2021-11-11T09:37:19,125 INFO  [vert.x-eventloop-thread-1] CQLWrapper CQL >>> SQL: userId==185c3981-a5f3-557e-a749-a01a3b1d2b75 >>>WHERE CASE WHEN length(lower(f_unaccent('185c3981-a5f3-557e-a749-a01a3b1d2b75'))) <= 600 THEN left(lower(f_unaccent(acquisitions_unit_membership.jsonb->>'userId')),600) LIKE lower(f_unaccent('185c3981-a5f3-557e-a749-a01a3b1d2b75')) ELSE left(lower(f_unaccent(acquisitions_unit_membership.jsonb->>'userId')),600) LIKE left(lower(f_unaccent('185c3981-a5f3-557e-a749-a01a3b1d2b75')),600) AND lower(f_unaccent(acquisitions_unit_membership.jsonb->>'userId')) LIKE lower(f_unaccent('185c3981-a5f3-557e-a749-a01a3b1d2b75')) END LIMIT 2147483647 OFFSET 0
2021-11-11T09:37:19,125 INFO  [vert.x-eventloop-thread-1] RestRouting invoking getAcquisitionsUnitsStorageUnits
Nov 11, 2021 9:37:19 AM org.folio.cql2pgjson.CQL2PgJSON loadDbSchema
INFO: loadDbSchema: Loaded templates/db_scripts/schema.json OK
2021-11-11T09:37:19,126 INFO  [vert.x-eventloop-thread-1] CQLWrapper CQL >>> SQL: (isDeleted==false) and (protectRead==false) >>>WHERE (CASE WHEN length(lower(f_unaccent('false'))) <= 600 THEN left(lower(f_unaccent(acquisitions_unit.jsonb->>'isDeleted')),600) LIKE lower(f_unaccent('false')) ELSE left(lower(f_unaccent(acquisitions_unit.jsonb->>'isDeleted')),600) LIKE left(lower(f_unaccent('false')),600) AND lower(f_unaccent(acquisitions_unit.jsonb->>'isDeleted')) LIKE lower(f_unaccent('false')) END) AND (CASE WHEN length(lower(f_unaccent('false'))) <= 600 THEN left(lower(f_unaccent(acquisitions_unit.jsonb->>'protectRead')),600) LIKE lower(f_unaccent('false')) ELSE left(lower(f_unaccent(acquisitions_unit.jsonb->>'protectRead')),600) LIKE left(lower(f_unaccent('false')),600) AND lower(f_unaccent(acquisitions_unit.jsonb->>'protectRead')) LIKE lower(f_unaccent('false')) END) LIMIT 2147483647 OFFSET 0
2021-11-11T09:37:19,127 INFO  [vert.x-eventloop-thread-1] LogUtil 10.36.1.47:35796 GET /acquisitions-units-storage/memberships offset=0&query=userId%3D%3D185c3981-a5f3-557e-a749-a01a3b1d2b75&limit=2147483647 HTTP_1_1 200 63 2 tid=diku OK 
2021-11-11T09:37:19,128 INFO  [vert.x-eventloop-thread-1] LogUtil 10.36.1.47:35632 GET /acquisitions-units-storage/units offset=0&query=%28isDeleted%3D%3Dfalse%29+and+%28protectRead%3D%3Dfalse%29&limit=2147483647 HTTP_1_1 200 401 2 tid=diku OK 
2021-11-11T09:37:19,130 INFO  [vert.x-eventloop-thread-1] RestRouting invoking getOrdersStoragePurchaseOrders
Nov 11, 2021 9:37:19 AM org.folio.cql2pgjson.CQL2PgJSON loadDbSchema
INFO: loadDbSchema: Loaded templates/db_scripts/schema.json OK
2021-11-11T09:37:19,130 INFO  [vert.x-eventloop-thread-1] CQLWrapper CQL >>> SQL: (acqUnitIds=(0ebb1f7d-983f-3026-8a4c-5318e0ebc041) or (cql.allRecords=1 not acqUnitIds <> [])) and (id==b44ac87f-d594-4617-8674-2fac6dcfb338) >>>WHERE ((get_tsvector(f_unaccent(purchase_order.jsonb->>'acqUnitIds')) @@ tsquery_phrase(f_unaccent('0ebb1f7d-983f-3026-8a4c-5318e0ebc041'))) OR ((true) AND ( (CASE WHEN length(lower(f_unaccent('[]'))) <= 600 THEN left(lower(f_unaccent(purchase_order.jsonb->>'acqUnitIds')),600) NOT LIKE lower(f_unaccent('[]')) ELSE left(lower(f_unaccent(purchase_order.jsonb->>'acqUnitIds')),600) NOT LIKE left(lower(f_unaccent('[]')),600) OR lower(f_unaccent(purchase_order.jsonb->>'acqUnitIds')) NOT LIKE lower(f_unaccent('[]')) END) IS NOT TRUE))) AND (id='b44ac87f-d594-4617-8674-2fac6dcfb338') LIMIT 1000 OFFSET 0
2021-11-11T09:37:19,133 INFO  [vert.x-eventloop-thread-1] LogUtil 10.36.1.47:35796 GET /orders-storage/purchase-orders limit=1000&offset=0&query=%28acqUnitIds%3D%280ebb1f7d-983f-3026-8a4c-5318e0ebc041%29+or+%28cql.allRecords%3D1+not+acqUnitIds+%3C%3E+%5B%5D%29%29+and+%28id%3D%3Db44ac87f-d594-4617-8674-2fac6dcfb338%29&lang=en HTTP_1_1 200 914 3 tid=diku OK 
2021-11-11T09:42:34,632 INFO  [vert.x-eventloop-thread-1] RestRouting invoking getOrdersStoragePoLines
Nov 11, 2021 9:42:34 AM org.folio.cql2pgjson.CQL2PgJSON loadDbSchema
INFO: loadDbSchema: Loaded templates/db_scripts/schema.json OK
2021-11-11T09:42:34,636 INFO  [vert.x-eventloop-thread-1] CQLWrapper CQL >>> SQL: vendorDetail.referenceNumbers=("1233") >>>WHERE get_tsvector(f_unaccent(po_line.jsonb->'vendorDetail'->>'referenceNumbers')) @@ tsquery_phrase(f_unaccent('1233')) LIMIT 10 OFFSET 0
2021-11-11T09:42:34,647 INFO  [vert.x-eventloop-thread-1] LogUtil 10.36.1.47:36056 GET /orders-storage/po-lines query=vendorDetail.referenceNumbers=(%221233%22) HTTP_1_1 200 2556 14 tid=diku OK 
2021-11-11T09:42:37,175 INFO  [vert.x-eventloop-thread-1] RestRouting invoking getOrdersStoragePoLines
Nov 11, 2021 9:42:37 AM org.folio.cql2pgjson.CQL2PgJSON loadDbSchema
INFO: loadDbSchema: Loaded templates/db_scripts/schema.json OK
2021-11-11T09:42:37,180 INFO  [vert.x-eventloop-thread-1] CQLWrapper CQL >>> SQL: vendorDetail.referenceNumbers=("1233") >>>WHERE get_tsvector(f_unaccent(po_line.jsonb->'vendorDetail'->>'referenceNumbers')) @@ tsquery_phrase(f_unaccent('1233')) LIMIT 10 OFFSET 0
2021-11-11T09:42:37,189 INFO  [vert.x-eventloop-thread-1] LogUtil 10.36.1.47:36056 GET /orders-storage/po-lines query=vendorDetail.referenceNumbers=(%221233%22) HTTP_1_1 200 2556 13 tid=diku OK 
2021-11-11T09:42:38,141 INFO  [vert.x-eventloop-thread-1] RestRouting invoking getOrdersStoragePoLines
Nov 11, 2021 9:42:38 AM org.folio.cql2pgjson.CQL2PgJSON loadDbSchema
INFO: loadDbSchema: Loaded templates/db_scripts/schema.json OK
2021-11-11T09:42:38,145 INFO  [vert.x-eventloop-thread-1] CQLWrapper CQL >>> SQL: vendorDetail.referenceNumbers=("1233") >>>WHERE get_tsvector(f_unaccent(po_line.jsonb->'vendorDetail'->>'referenceNumbers')) @@ tsquery_phrase(f_unaccent('1233')) LIMIT 10 OFFSET 0
2021-11-11T09:42:38,155 INFO  [vert.x-eventloop-thread-1] LogUtil 10.36.1.47:36056 GET /orders-storage/po-lines query=vendorDetail.referenceNumbers=(%221233%22) HTTP_1_1 200 2556 14 tid=diku OK 
2021-11-11T09:42:39,221 INFO  [vert.x-eventloop-thread-1] RestRouting invoking getOrdersStoragePoLines
Nov 11, 2021 9:42:39 AM org.folio.cql2pgjson.CQL2PgJSON loadDbSchema
INFO: loadDbSchema: Loaded templates/db_scripts/schema.json OK
2021-11-11T09:42:39,225 INFO  [vert.x-eventloop-thread-1] CQLWrapper CQL >>> SQL: vendorDetail.referenceNumbers=("1233") >>>WHERE get_tsvector(f_unaccent(po_line.jsonb->'vendorDetail'->>'referenceNumbers')) @@ tsquery_phrase(f_unaccent('1233')) LIMIT 10 OFFSET 0
2021-11-11T09:42:39,235 INFO  [vert.x-eventloop-thread-1] LogUtil 10.36.1.47:36056 GET /orders-storage/po-lines query=vendorDetail.referenceNumbers=(%221233%22) HTTP_1_1 200 2556 13 tid=diku OK 
2021-11-11T09:43:23,184 INFO  [vert.x-eventloop-thread-1] RestRouting invoking getOrdersStoragePoLines
Nov 11, 2021 9:43:23 AM org.folio.cql2pgjson.CQL2PgJSON loadDbSchema
INFO: loadDbSchema: Loaded templates/db_scripts/schema.json OK
2021-11-11T09:43:23,188 INFO  [vert.x-eventloop-thread-1] CQLWrapper CQL >>> SQL: purchaseOrder.acqUnitIds=(0ebb1f7d-983f-3026-8a4c-5318e0ebc041 OR d669b8cb-4b94-4193-a0f2-b77e8b77b2e6 ) >>>WHERE (po_line.purchaseOrderId IN  ( SELECT id FROM purchase_order WHERE get_tsvector(f_unaccent(purchase_order.jsonb->>'acqUnitIds')) @@ tsquery_phrase(f_unaccent('0ebb1f7d-983f-3026-8a4c-5318e0ebc041')))) OR (po_line.purchaseOrderId IN  ( SELECT id FROM purchase_order WHERE get_tsvector(f_unaccent(purchase_order.jsonb->>'acqUnitIds')) @@ tsquery_phrase(f_unaccent('d669b8cb-4b94-4193-a0f2-b77e8b77b2e6')))) LIMIT 10 OFFSET 0
2021-11-11T09:43:23,199 INFO  [vert.x-eventloop-thread-1] LogUtil 10.36.1.47:36056 GET /orders-storage/po-lines query=purchaseOrder.acqUnitIds=(0ebb1f7d-983f-3026-8a4c-5318e0ebc041%20OR%20d669b8cb-4b94-4193-a0f2-b77e8b77b2e6%20) HTTP_1_1 200 3016 16 tid=diku OK 
2021-11-11T09:43:24,544 INFO  [vert.x-eventloop-thread-1] RestRouting invoking getOrdersStoragePoLines
Nov 11, 2021 9:43:24 AM org.folio.cql2pgjson.CQL2PgJSON loadDbSchema
INFO: loadDbSchema: Loaded templates/db_scripts/schema.json OK
2021-11-11T09:43:24,545 INFO  [vert.x-eventloop-thread-1] CQLWrapper CQL >>> SQL: purchaseOrder.acqUnitIds=(0ebb1f7d-983f-3026-8a4c-5318e0ebc041 OR d669b8cb-4b94-4193-a0f2-b77e8b77b2e6 ) >>>WHERE (po_line.purchaseOrderId IN  ( SELECT id FROM purchase_order WHERE get_tsvector(f_unaccent(purchase_order.jsonb->>'acqUnitIds')) @@ tsquery_phrase(f_unaccent('0ebb1f7d-983f-3026-8a4c-5318e0ebc041')))) OR (po_line.purchaseOrderId IN  ( SELECT id FROM purchase_order WHERE get_tsvector(f_unaccent(purchase_order.jsonb->>'acqUnitIds')) @@ tsquery_phrase(f_unaccent('d669b8cb-4b94-4193-a0f2-b77e8b77b2e6')))) LIMIT 10 OFFSET 0
2021-11-11T09:43:24,551 INFO  [vert.x-eventloop-thread-1] LogUtil 10.36.1.47:36056 GET /orders-storage/po-lines query=purchaseOrder.acqUnitIds=(0ebb1f7d-983f-3026-8a4c-5318e0ebc041%20OR%20d669b8cb-4b94-4193-a0f2-b77e8b77b2e6%20) HTTP_1_1 200 3016 7 tid=diku OK 
2021-11-11T09:43:25,622 INFO  [vert.x-eventloop-thread-1] RestRouting invoking getOrdersStoragePoLines
Nov 11, 2021 9:43:25 AM org.folio.cql2pgjson.CQL2PgJSON loadDbSchema
INFO: loadDbSchema: Loaded templates/db_scripts/schema.json OK
2021-11-11T09:43:25,623 INFO  [vert.x-eventloop-thread-1] CQLWrapper CQL >>> SQL: purchaseOrder.acqUnitIds=(0ebb1f7d-983f-3026-8a4c-5318e0ebc041 OR d669b8cb-4b94-4193-a0f2-b77e8b77b2e6 ) >>>WHERE (po_line.purchaseOrderId IN  ( SELECT id FROM purchase_order WHERE get_tsvector(f_unaccent(purchase_order.jsonb->>'acqUnitIds')) @@ tsquery_phrase(f_unaccent('0ebb1f7d-983f-3026-8a4c-5318e0ebc041')))) OR (po_line.purchaseOrderId IN  ( SELECT id FROM purchase_order WHERE get_tsvector(f_unaccent(purchase_order.jsonb->>'acqUnitIds')) @@ tsquery_phrase(f_unaccent('d669b8cb-4b94-4193-a0f2-b77e8b77b2e6')))) LIMIT 10 OFFSET 0
2021-11-11T09:43:25,628 INFO  [vert.x-eventloop-thread-1] LogUtil 10.36.1.47:36056 GET /orders-storage/po-lines query=purchaseOrder.acqUnitIds=(0ebb1f7d-983f-3026-8a4c-5318e0ebc041%20OR%20d669b8cb-4b94-4193-a0f2-b77e8b77b2e6%20) HTTP_1_1 200 3016 6 tid=diku OK 
2021-11-11T09:43:26,740 INFO  [vert.x-eventloop-thread-1] RestRouting invoking getOrdersStoragePoLines
Nov 11, 2021 9:43:26 AM org.folio.cql2pgjson.CQL2PgJSON loadDbSchema
INFO: loadDbSchema: Loaded templates/db_scripts/schema.json OK
2021-11-11T09:43:26,741 INFO  [vert.x-eventloop-thread-1] CQLWrapper CQL >>> SQL: purchaseOrder.acqUnitIds=(0ebb1f7d-983f-3026-8a4c-5318e0ebc041 OR d669b8cb-4b94-4193-a0f2-b77e8b77b2e6 ) >>>WHERE (po_line.purchaseOrderId IN  ( SELECT id FROM purchase_order WHERE get_tsvector(f_unaccent(purchase_order.jsonb->>'acqUnitIds')) @@ tsquery_phrase(f_unaccent('0ebb1f7d-983f-3026-8a4c-5318e0ebc041')))) OR (po_line.purchaseOrderId IN  ( SELECT id FROM purchase_order WHERE get_tsvector(f_unaccent(purchase_order.jsonb->>'acqUnitIds')) @@ tsquery_phrase(f_unaccent('d669b8cb-4b94-4193-a0f2-b77e8b77b2e6')))) LIMIT 10 OFFSET 0
2021-11-11T09:43:26,746 INFO  [vert.x-eventloop-thread-1] LogUtil 10.36.1.47:36056 GET /orders-storage/po-lines query=purchaseOrder.acqUnitIds=(0ebb1f7d-983f-3026-8a4c-5318e0ebc041%20OR%20d669b8cb-4b94-4193-a0f2-b77e8b77b2e6%20) HTTP_1_1 200 3016 6 tid=diku OK