chrissharp123

Untitled

May 26th, 2017
136
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1.  SELECT * FROM (SELECT  SUM("56ea0ee77c2c6efe0131dfeea01705f5"."amount_estimated") AS "Amount Estimated",
  2.         SUM("56ea0ee77c2c6efe0131dfeea01705f5"."amount_encumbered") AS "Amount Encumbered",
  3.         SUM("56ea0ee77c2c6efe0131dfeea01705f5"."amount_spent") AS "Amount Spent",
  4.         "56ea0ee77c2c6efe0131dfeea01705f5"."state" AS "State",
  5.         "56ea0ee77c2c6efe0131dfeea01705f5"."id" AS "Purchase Order ID",
  6.         "f6422b231827b01bf4a6ffe0080beb05"."item_count" AS "Item Count",
  7.         "3d4810701da515a9109943f830ba6cc4"."code" AS "Code",
  8.         date("56ea0ee77c2c6efe0131dfeea01705f5"."create_time") AS "Creation Time",
  9.         date("56ea0ee77c2c6efe0131dfeea01705f5"."order_date") AS "Order Date"
  10.   FROM  acq.purchase_order AS "56ea0ee77c2c6efe0131dfeea01705f5"
  11.         INNER JOIN acq.provider AS "3d4810701da515a9109943f830ba6cc4" ON ("56ea0ee77c2c6efe0131dfeea01705f5"."provider" = "3d4810701da515a9109943f830ba6cc4"."id")
  12.         INNER JOIN actor.org_unit AS "6384d64cf75978fb7e6f1cd23ff5c037" ON ("56ea0ee77c2c6efe0131dfeea01705f5"."ordering_agency" = "6384d64cf75978fb7e6f1cd23ff5c037"."id")
  13.         LEFT OUTER JOIN acq.lineitem AS "f6422b231827b01bf4a6ffe0080beb05" ON ("56ea0ee77c2c6efe0131dfeea01705f5"."id" = "f6422b231827b01bf4a6ffe0080beb05"."purchase_order")
  14.   WHERE date("56ea0ee77c2c6efe0131dfeea01705f5"."create_time") >= $_147912$2017-01-02$_147912$
  15.         AND "6384d64cf75978fb7e6f1cd23ff5c037"."id" IN ($_147912$213$_147912$)
  16.   GROUP BY 4, 5, 6, 7, 8, 9
  17.   ORDER BY SUM("56ea0ee77c2c6efe0131dfeea01705f5"."amount_estimated") ASC, SUM("56ea0ee77c2c6efe0131dfeea01705f5"."amount_encumbered") ASC, SUM("56ea0ee77c2c6efe0131dfeea01705f5"."amount_spent") ASC, "56ea0ee77c2c6efe0131dfeea01705f5"."state" ASC, "56ea0ee77c2c6efe0131dfeea01705f5"."id" ASC, "f6422b231827b01bf4a6ffe0080beb05"."item_count" ASC, "3d4810701da515a9109943f830ba6cc4"."code" ASC, date("56ea0ee77c2c6efe0131dfeea01705f5"."create_time") ASC, date("56ea0ee77c2c6efe0131dfeea01705f5"."order_date") ASC
  18. ) limited_to_1048575_hits LIMIT 1048575
  19.  
  20.  
  21. Error is:  DBD::Pg::st execute failed: ERROR:  column 56ea0ee77c2c6efe0131dfeea01705f5.amount_estimated does not exist
  22. LINE 1: SELECT * FROM (SELECT SUM("56ea0ee77c2c6efe0131dfeea01705f5"...
  23.                                   ^ at /openils/bin/clark-kent.pl line 255.
RAW Paste Data