View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - [SOLVED] [V5] Order doesn't appear in list if no project set - ProjeQtOr
 

[SOLVED] [V5] Order doesn't appear in list if no project set

More
17 Jun 2015 12:13 #1 by papjul
Hi,

As an administrator, when I create an order with no project selected in the list (optional field), it doesn't show up in the orders list (list area). When I add a project id to this order directly in database, order shows up in the list.

I didn't test other entities, but it might not affect only orders.

I didn't remember having this problem before V5.

Thank you,

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

More
17 Jun 2015 13:33 #2 by babynus
Hi,

You may have discovered a bug.
It is due to V5 new access rights management, that can be different on several projects (different profile can now be defined on each project).
Other entities are not affected as Project is mandatory for most items.
Items that are not Project dependant are correctly managed (Products, Resources, ...)
Item where project is optional are very few :
- document : already taken into account
- bill : was forgotten.
I'll check to be sure there is not other.

Now I wonder why project is not mandatory for bills. Does it really have an interest for you ?
Moveover, for quotes project in mandatory...
(that's why I never faced the issue : I always create bills through copy of quotes)

Ticket #1723 recorded.

Thanks for reporting

Babynus
Administrator of ProjeQtOr web site

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

More
17 Jun 2015 13:47 #3 by papjul

babynus wrote: - bill : was forgotten.

It's mandatory on invoices/bills for me, you meant orders?

babynus wrote: I'll check to be sure there is not other.

Requirements, tests cases & tests sessions.

babynus wrote: Now I wonder why project is not mandatory for bills. Does it really have an interest for you ?
Moveover, for quotes project in mandatory...
(that's why I never faced the issue : I always create bills through copy of quotes)

I was just testing an order, that's why I didn't fill in all fields, I usually copy from quotations to orders too.

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

More
17 Jun 2015 14:46 #4 by babynus
You're right.
Issue exist on Orders, Requirements, Tests cases & Tests sessions.

It will be fixed on next patch.

Babynus
Administrator of ProjeQtOr web site

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

More
18 Jun 2015 11:32 #5 by papjul
Issue affects messages too.

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

More
19 Jun 2015 00:06 #6 by babynus
Issue fixed.
Fix is just to replace in /tool/projeqtor.php, line 742
} else if ($accessRightRead=='ALL') {
    $queryWhere="($tableAlias$fieldProj not in $listNO or $tableAlias$fieldProj is null)";
    if ($listRES) $queryWhere.=" and ($tableAlias$fieldProj not in $listRES or $clauseRES)";
    if ($listOWN) $queryWhere.=" and ($tableAlias$fieldProj not in $listOWN or $clauseOWN)";
  }
with
} else if ($accessRightRead=='ALL') {
    $queryWhere="($tableAlias$fieldProj not in $listNO or $tableAlias$fieldProj is null)";
    if ($listRES) $queryWhere.=" and ($tableAlias$fieldProj not in $listRES or $tableAlias$fieldProj is null or $clauseRES)";
    if ($listOWN) $queryWhere.=" and ($tableAlias$fieldProj not in $listOWN or $tableAlias$fieldProj is null or $clauseOWN)";
  }

Fix will soon be deployed in patch V5.0.1

Babynus
Administrator of ProjeQtOr web site

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

Moderators: babynusprotion
Time to create page: 0.058 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.