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

Prochaines sessions de formation

Les prochaines formations et démonstrations sont ouvertes, inscrivez-vous rapidement !

 

Démonstration de ProjeQtOr

(gratuit, sur inscription)

Mardi 23 avril (10h30-12h)

Jeudi 16 mai (16h-17h30)

Jeudi 13 juin (10h30-12h)

 
 

Planifiez avec ProjeQtOr

3 et 4 avril (9h - 12h30)

 
 

Administrez avec ProjeQtOr

10 et 11 avril (9h - 12h30)

 

 

 
 

[SOLVED] Financial Gallery V 5.3.1

More
12 Avr 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 Connexion or Create an account to join the conversation.

More
13 Avr 2016 12:33 - 13 Avr 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 Avr 2016 12:33 by papjul.

Please Connexion or Create an account to join the conversation.

More
14 Avr 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 Connexion or Create an account to join the conversation.

More
14 Avr 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 Connexion or Create an account to join the conversation.

More
14 Avr 2016 20:38 - 14 Avr 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 Avr 2016 20:38 by babynus.

Please Connexion or Create an account to join the conversation.

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

Please Connexion or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.036 seconds

Paramétrages de cookies

×

Cookies fonctionnels

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

Veuillez vous connecter pour voir vos activités!

Autres cookies

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