WARNING: Doing LIKE search without index for po_line.jsonb->>'publisher', CQL >>> SQL: publisher == twitter >>> lower(f_unaccent(po_line.jsonb->>'publisher')) LIKE lower(f_unaccent('twitter'))
Mar 28, 2022 12:27:30 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike
WARNING: Doing LIKE search without index for po_line.jsonb->'vendorDetail'->>'vendorAccount', CQL >>> SQL: vendorDetail.vendorAccount == twitter >>> lower(f_unaccent(po_line.jsonb->'vendorDetail'->>'vendorAccount')) LIKE lower(f_unaccent('twitter'))
Mar 28, 2022 12:27:30 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike
WARNING: Doing LIKE search without index for po_line.jsonb->'vendorDetail'->>'referenceNumbers', CQL >>> SQL: vendorDetail.referenceNumbers == twitter >>> lower(f_unaccent(po_line.jsonb->'vendorDetail'->>'referenceNumbers')) LIKE lower(f_unaccent('twitter'))
Mar 28, 2022 12:27:30 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike
WARNING: Doing LIKE search without index for po_line.jsonb->>'donor', CQL >>> SQL: donor == twitter >>> lower(f_unaccent(po_line.jsonb->>'donor')) LIKE lower(f_unaccent('twitter'))
Mar 28, 2022 12:27:30 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike
WARNING: Doing LIKE search without index for po_line.jsonb->>'selector', CQL >>> SQL: selector == twitter >>> lower(f_unaccent(po_line.jsonb->>'selector')) LIKE lower(f_unaccent('twitter'))
Mar 28, 2022 12:27:30 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike
WARNING: Doing LIKE search without index for po_line.jsonb->>'publisher', CQL >>> SQL: publisher == twitter >>> lower(f_unaccent(po_line.jsonb->>'publisher')) LIKE lower(f_unaccent('twitter'))
Mar 28, 2022 12:27:30 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike
WARNING: Doing LIKE search without index for po_line.jsonb->'vendorDetail'->>'vendorAccount', CQL >>> SQL: vendorDetail.vendorAccount == twitter >>> lower(f_unaccent(po_line.jsonb->'vendorDetail'->>'vendorAccount')) LIKE lower(f_unaccent('twitter'))
Mar 28, 2022 12:27:30 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike
WARNING: Doing LIKE search without index for po_line.jsonb->'vendorDetail'->>'referenceNumbers', CQL >>> SQL: vendorDetail.referenceNumbers == twitter >>> lower(f_unaccent(po_line.jsonb->'vendorDetail'->>'referenceNumbers')) LIKE lower(f_unaccent('twitter'))
Mar 28, 2022 12:27:30 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike
WARNING: Doing LIKE search without index for po_line.jsonb->>'donor', CQL >>> SQL: donor == twitter >>> lower(f_unaccent(po_line.jsonb->>'donor')) LIKE lower(f_unaccent('twitter'))
Mar 28, 2022 12:27:30 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike
WARNING: Doing LIKE search without index for po_line.jsonb->>'selector', CQL >>> SQL: selector == twitter >>> lower(f_unaccent(po_line.jsonb->>'selector')) LIKE lower(f_unaccent('twitter'))
2022-03-28T12:27:30,584 INFO  [vert.x-eventloop-thread-1] CQLWrapper CQL >>> SQL: (purchaseOrder.acqUnitIds=(0ebb1f7d-983f-3026-8a4c-5318e0ebc041) or (cql.allRecords=1 not purchaseOrder.acqUnitIds <> [])) and (((contributors=="twitter" or poLineNumber=="twitter" or requester=="twitter" or titleOrPackage=="twitter" or publisher=="twitter" or vendorDetail.vendorAccount=="twitter" or vendorDetail.referenceNumbers=="twitter" or donor=="twitter" or selector=="twitter" or physical.volumes=="twitter" or details.productIds=="twitter"))) sortby metadata.updatedDate/sort.descending >>>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 ((true) AND ( (po_line.purchaseOrderId IN  ( SELECT id FROM purchase_order WHERE 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 (((((((((((lower(f_unaccent(po_line.jsonb->>'contributors')) LIKE lower(f_unaccent('twitter'))) OR (lower(f_unaccent(po_line.jsonb->>'poLineNumber')) LIKE lower(f_unaccent('twitter')))) OR (lower(f_unaccent(po_line.jsonb->>'requester')) LIKE lower(f_unaccent('twitter')))) OR (lower(f_unaccent(po_line.jsonb->>'titleOrPackage')) LIKE lower(f_unaccent('twitter')))) OR (lower(f_unaccent(po_line.jsonb->>'publisher')) LIKE lower(f_unaccent('twitter')))) OR (lower(f_unaccent(po_line.jsonb->'vendorDetail'->>'vendorAccount')) LIKE lower(f_unaccent('twitter')))) OR (lower(f_unaccent(po_line.jsonb->'vendorDetail'->>'referenceNumbers')) LIKE lower(f_unaccent('twitter')))) OR (lower(f_unaccent(po_line.jsonb->>'donor')) LIKE lower(f_unaccent('twitter')))) OR (lower(f_unaccent(po_line.jsonb->>'selector')) LIKE lower(f_unaccent('twitter')))) OR (CASE WHEN length(lower(f_unaccent('twitter'))) <= 600 THEN left(lower(f_unaccent(po_line.jsonb->'physical'->>'volumes')),600) LIKE lower(f_unaccent('twitter')) ELSE left(lower(f_unaccent(po_line.jsonb->'physical'->>'volumes')),600) LIKE left(lower(f_unaccent('twitter')),600) AND lower(f_unaccent(po_line.jsonb->'physical'->>'volumes')) LIKE lower(f_unaccent('twitter')) END)) OR (lower(f_unaccent(po_line.jsonb->'details'->>'productIds')) LIKE lower(f_unaccent('twitter')))) ORDER BY left(lower(f_unaccent(po_line.jsonb->'metadata'->>'updatedDate')),600) DESC, lower(f_unaccent(po_line.jsonb->'metadata'->>'updatedDate')) DESC LIMIT 30 OFFSET 0
Mar 28, 2022 12:27:30 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike
WARNING: Doing LIKE search without index for po_line.jsonb->>'publisher', CQL >>> SQL: publisher == twitter >>> lower(f_unaccent(po_line.jsonb->>'publisher')) LIKE lower(f_unaccent('twitter'))
Mar 28, 2022 12:27:30 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike
WARNING: Doing LIKE search without index for po_line.jsonb->'vendorDetail'->>'vendorAccount', CQL >>> SQL: vendorDetail.vendorAccount == twitter >>> lower(f_unaccent(po_line.jsonb->'vendorDetail'->>'vendorAccount')) LIKE lower(f_unaccent('twitter'))
Mar 28, 2022 12:27:30 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike
WARNING: Doing LIKE search without index for po_line.jsonb->'vendorDetail'->>'referenceNumbers', CQL >>> SQL: vendorDetail.referenceNumbers == twitter >>> lower(f_unaccent(po_line.jsonb->'vendorDetail'->>'referenceNumbers')) LIKE lower(f_unaccent('twitter'))
Mar 28, 2022 12:27:30 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike
WARNING: Doing LIKE search without index for po_line.jsonb->>'donor', CQL >>> SQL: donor == twitter >>> lower(f_unaccent(po_line.jsonb->>'donor')) LIKE lower(f_unaccent('twitter'))
Mar 28, 2022 12:27:30 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike
WARNING: Doing LIKE search without index for po_line.jsonb->>'selector', CQL >>> SQL: selector == twitter >>> lower(f_unaccent(po_line.jsonb->>'selector')) LIKE lower(f_unaccent('twitter'))
Mar 28, 2022 12:27:30 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike
WARNING: Doing LIKE search without index for po_line.jsonb->>'publisher', CQL >>> SQL: publisher == twitter >>> lower(f_unaccent(po_line.jsonb->>'publisher')) LIKE lower(f_unaccent('twitter'))
Mar 28, 2022 12:27:30 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike
WARNING: Doing LIKE search without index for po_line.jsonb->'vendorDetail'->>'vendorAccount', CQL >>> SQL: vendorDetail.vendorAccount == twitter >>> lower(f_unaccent(po_line.jsonb->'vendorDetail'->>'vendorAccount')) LIKE lower(f_unaccent('twitter'))
Mar 28, 2022 12:27:30 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike
WARNING: Doing LIKE search without index for po_line.jsonb->'vendorDetail'->>'referenceNumbers', CQL >>> SQL: vendorDetail.referenceNumbers == twitter >>> lower(f_unaccent(po_line.jsonb->'vendorDetail'->>'referenceNumbers')) LIKE lower(f_unaccent('twitter'))
Mar 28, 2022 12:27:30 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike
WARNING: Doing LIKE search without index for po_line.jsonb->>'donor', CQL >>> SQL: donor == twitter >>> lower(f_unaccent(po_line.jsonb->>'donor')) LIKE lower(f_unaccent('twitter'))
Mar 28, 2022 12:27:30 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike
WARNING: Doing LIKE search without index for po_line.jsonb->>'selector', CQL >>> SQL: selector == twitter >>> lower(f_unaccent(po_line.jsonb->>'selector')) LIKE lower(f_unaccent('twitter'))
Mar 28, 2022 12:27:30 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike
WARNING: Doing LIKE search without index for po_line.jsonb->>'publisher', CQL >>> SQL: publisher == twitter >>> lower(f_unaccent(po_line.jsonb->>'publisher')) LIKE lower(f_unaccent('twitter'))
Mar 28, 2022 12:27:30 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike
WARNING: Doing LIKE search without index for po_line.jsonb->'vendorDetail'->>'vendorAccount', CQL >>> SQL: vendorDetail.vendorAccount == twitter >>> lower(f_unaccent(po_line.jsonb->'vendorDetail'->>'vendorAccount')) LIKE lower(f_unaccent('twitter'))
Mar 28, 2022 12:27:30 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike
WARNING: Doing LIKE search without index for po_line.jsonb->'vendorDetail'->>'referenceNumbers', CQL >>> SQL: vendorDetail.referenceNumbers == twitter >>> lower(f_unaccent(po_line.jsonb->'vendorDetail'->>'referenceNumbers')) LIKE lower(f_unaccent('twitter'))
Mar 28, 2022 12:27:30 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike
WARNING: Doing LIKE search without index for po_line.jsonb->>'donor', CQL >>> SQL: donor == twitter >>> lower(f_unaccent(po_line.jsonb->>'donor')) LIKE lower(f_unaccent('twitter'))
Mar 28, 2022 12:27:30 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike
WARNING: Doing LIKE search without index for po_line.jsonb->>'selector', CQL >>> SQL: selector == twitter >>> lower(f_unaccent(po_line.jsonb->>'selector')) LIKE lower(f_unaccent('twitter'))
2022-03-28T12:27:30,613 INFO  [vert.x-eventloop-thread-1] LogUtil 10.0.2.15:41516 GET /orders-storage/po-lines offset=0&query=%28purchaseOrder.acqUnitIds%3D%280ebb1f7d-983f-3026-8a4c-5318e0ebc041%29+or+%28cql.allRecords%3D1+not+purchaseOrder.acqUnitIds+%3C%3E+%5B%5D%29%29+and+%28%28%28contributors%3D%3D%22twitter%22+or+poLineNumber%3D%3D%22twitter%22+or+requester%3D%3D%22twitter%22+or+titleOrPackage%3D%3D%22twitter%22+or+publisher%3D%3D%22twitter%22+or+vendorDetail.vendorAccount%3D%3D%22twitter%22+or+vendorDetail.referenceNumbers%3D%3D%22twitter%22+or+donor%3D%3D%22twitter%22+or+selector%3D%3D%22twitter%22+or+physical.volumes%3D%3D%22twitter%22+or+details.productIds%3D%3D%22twitter%22%29%29%29+sortby+metadata.updatedDate%2Fsort.descending&limit=30 HTTP_1_1 200 43 45 tid=diku OK