View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - [SOLVED] Financial Gallery V 5.3.1 - ProjeQtOr
 
 

[SOLVED] Financial Gallery V 5.3.1

More
12 Apr 2016 16:57 #1 by richard.pare
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

Please Log in or Create an account to join the conversation.

More
13 Apr 2016 12:33 - 13 Apr 2016 12:33 #2 by papjul
Replied by papjul on topic Financial Gallery V 5.3.1
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 ;)
Last edit: 13 Apr 2016 12:33 by papjul.

Please Log in or Create an account to join the conversation.

More
14 Apr 2016 14:55 #3 by richard.pare
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).

Please Log in or Create an account to join the conversation.

More
14 Apr 2016 15:02 #4 by papjul
Replied by papjul on topic Financial Gallery V 5.3.1
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.

Please Log in or Create an account to join the conversation.

More
14 Apr 2016 20:38 - 14 Apr 2016 20:38 #5 by babynus
Replied by babynus on topic Financial Gallery V 5.3.1

richard.pare wrote: 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)

Babynus
Administrator of ProjeQtOr web site
Last edit: 14 Apr 2016 20:38 by babynus.

Please Log in or Create an account to join the conversation.

More
14 Apr 2016 20:46 #6 by richard.pare
It's OK for me !

Please Log in or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.038 seconds

Cookies settings

×

Functional Cookies

Ce site utilise des cookies pour assurer son bon fonctionnement et ne peuvent pas être désactivés de nos systèmes. Nous ne les utilisons pas à des fins publicitaires. Si ces cookies sont bloqués, certaines parties du site ne pourront pas fonctionner.

Session

Please login to see yours activities!

Other cookies

Ce site web utilise un certain nombre de cookies pour gérer, par exemple, les sessions utilisateurs.