This issue arises when I try to display attachment for Quotation.
Column "SignatureDate" doesn't exist in table "Quotation".
2016-04-12 10:52:17.929 ** ERROR ** Exception-[42S22] SQLSTATE[42S22]: Column not found: 1054 Unknown column 'signatureDate' in 'where clause'
2016-04-12 10:52:17.931 ** ERROR ** For query : select * from quotation where (idProject not in (0) or idProject is null ) and (idProject not in (0) or idProject is null or (idResource='1') ) and (idProject not in (0) or idProject is null or (idUser='1') ) and signatureDate >= 2016-04-12 order by signatureDate DESC
Sorry, signatureDate was a custom field I added.
On line 35 of view/galleryShow.php, change:
$entityDateField = array('Quotation' => 'signatureDate',
to
$entityDateField = array('Quotation' => 'initialEndDate',
or
$entityDateField = array('Quotation' => 'sendDate',
according to which date you want to filter with 😉
I need to know which field will be used in the filter.
I work on version 5.3 of the user guide.
initialEndDate, sendDate or both (You decide).
On my version of ProjeQtOr, I want to filter according to the signature date of the quotation.
When you filter the financial gallery according to a date, according to which date do you want to filter? Initial end date or send date?
It's up to you to decide until a fix, but babynus will settle the situation eventually for the community edition of ProjeQtOr.
I need to know which field will be used in the filter.
I work on version 5.3 of the user guide.
initialEndDate, sendDate or both (You decide).
I would propose to use the "done" date (doneDate in the database)
It's OK for me !