projekt kivitendo

    qq|SELECT a.id, a.invnumber, a.transdate, a.duedate, a.amount, a.paid, | .

    qq|  a.ordnumber, v.name, a.invoice, a.netamount, a.datepaid, a.notes, | .

    qq|  a.globalproject_id, a.storno, a.storno_id, a.direct_debit, | .

    qq|  pr.projectnumber AS globalprojectnumber, | .

    qq|  e.name AS employee, | .

    qq|  v.vendornumber, v.country, v.ustid, | .

    $where .= " AND a.ordnumber ILIKE ?";

    push(@values, like($form->{ordnumber}));

  }

  if ($form->{notes}) {

    $where .= " AND lower(a.notes) LIKE ?";

    push(@values, like($form->{notes}));