View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - Create notification for Leave Period - Page 2 - ProjeQtOr
 
 

Create notification for Leave Period

More
14 Sep 2021 18:36 #7 by mcanuto
Replied by mcanuto on topic Create notification for Leave Period
I looked into my production table (v9.2.2)  and my test table (v9.2.3, upgraded today) and they are identical:

 

And I'm not sure I can see an issue. I found a way to create the notification, but I need to delete the "[]" of the notifiable element at the top, to fill all the form and retype them to save. But I don't think this is the normal way to use it.

Can you tell me what's wrong in my table, please?

Regards,
MCanuto
Attachments:

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

More
15 Sep 2021 09:24 #8 by babynus
Replied by babynus on topic Create notification for Leave Period
Hi,
It seems you entered some values manually in the table (id 82 & 83)
they are different from what is inserted through migration
INSERT INTO `${prefix}notifiable` (`notifiableItem`,`name`,`idle`) VALUES
    ('Leave','Leave',0),
    ('EmployeeLeaveEarned','Leave Earned',0),
    ('Workflow','Workflow',0),
    ('Status', 'Status',0),
    ('LeaveType', 'Leave Type',0);

We don't support this kind of changes
Babynus
Administrator of ProjeQtOr web site

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

More
08 Oct 2021 11:20 #9 by mcanuto
Replied by mcanuto on topic Create notification for Leave Period
Hello, Babynus,

I'm pretty sur we never add records to that table manually. 
It seems like the ID 82, 83 and 86 got a name in french instead of the english one on your query.

Anyway, is there a possibility to undo it and fix the content of this table?
If we delete those records and run your query again, would it have any other impact on any other table?

At least, can you tell me in which version it was added to the database?

Thank you for any help you can provide.

Best regards,
MCanuto
 

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

More
13 Oct 2021 15:37 - 13 Oct 2021 15:38 #10 by babynus
Replied by babynus on topic Create notification for Leave Period

Anyway, is there a possibility to undo it and fix the content of this table?

Yes update the table

If we delete those records and run your query again, would it have any other impact on any other table?

No, only notifications are impacted with notifiable.

At least, can you tell me in which version it was added to the database?

V8.0.0 (it was when I was young...)
Babynus
Administrator of ProjeQtOr web site
Last edit: 13 Oct 2021 15:38 by babynus.

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

More
02 Feb 2022 10:53 #11 by mcanuto
Replied by mcanuto on topic Create notification for Leave Period
Sorry, I took a long time to get back to you on this.

Once the table updated, it's working.

Just another question. On the notification, I cannot use the information of the Leave Type, which can be important. Is that something planned to be available on the future?

Regards,
MCanuto

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

More
02 Feb 2022 14:19 #12 by babynus
Replied by babynus on topic Create notification for Leave Period
As designed for this feature, all fields available are proposed.
So the Leave Type may not be directly avaialble.
Babynus
Administrator of ProjeQtOr web site

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

Moderators: babynus, protion
Time to create page: 0.044 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.

Login Form