#658 Query error when generating sales order from timecards

1.3
closed-fixed
nobody
None
5
2012-10-05
2012-08-19
Anonymous
No

SELECT j.id, p.description, j.qty - j.allocated AS qty,
j.sellprice, j.parts_id, pr.credit_id as customer_id,
j.project_id, j.checkedin::date AS transdate,
j.notes, c.legal_name AS customer, pr.projectnumber,
p.partnumber
FROM jcitems j
JOIN project pr ON (pr.id = j.project_id)
JOIN parts p ON (p.id = j.parts_id)
LEFT JOIN entity_credit_account eca ON (eca.id = pr.credit_id)
LEFT JOIN company c ON eca.entity_id = c.entity_id
WHERE pr.parts_id IS NULL
AND j.allocated != j.qty AND j.project_id = '1' AND j.checkedin >= '2012-01-01' AND j.checkedout <= (date '2012-08-01' + interval '1 days')
ORDER BY pr.projectnumber, c.name, j.parts_id, j.checkedin::date
ERROR: column c.name does not exist
LINE 14: ORDER BY pr.projectnumber, c.name, j.parts_id, j.checked...
^

My instance reports being 1.3.19

Discussion

  • Erik Huelsmann

    Erik Huelsmann - 2012-10-05
    • status: open --> closed-fixed
     
  • Erik Huelsmann

    Erik Huelsmann - 2012-10-05

    r5143.

     

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

JavaScript is required for this form.





No, thanks