Viewing 5 posts - 1 through 5 (of 5 total)
Viewing 5 posts - 1 through 5 (of 5 total)
- You must be logged in to reply to this topic.
Welcome to the POB User Group Online Community! › Forums › PUG International › Problems with Database actions
Hi,
I am looking for some help setting up a new trigger in POB. Im basically trying to get POB to update a string once a user has updated a case memo. The users must in the below user groups for it to update. I’ve attached the condition setup below.
Condition:
Action:Memo insert
Field CasePK:
Condition TRUE
PQL Value:[1|Case x|x.CasePK=[CasePK] And ‘[UID]’ IN (‘Core Network’,Service Desk’,’Senior Analysts’)]
I’ve attached the condition to a Database action.
Id: Case.Update_ByTeam
Execution Mode: Public
Condition: Case.Update_ByTeam: Case.Update_ByTeam
Operation: Set Values
Target Column: Last updated by Team
Source PQL Value: [GID]
I’ve tested this but it still doesn’t update the string with the Users Group.
Hi,
In your PQL, you are working with [UID], which is retrieving the current User’s ID. But if I understand you right, you want to get the current User Group’s ID, which would be [GID].
I guess that’s the only problem. 🙂
PS: You can test any PQL by typing it into the bottom-left navigation search field (F11) after a “=”, such as “=[UID]”. That way, you can always see which value your PQL returns in a certain situation. If you open a case where the trigger should be fired, and you put in your (corrected) PQL, you should see a pop-up showing “1”.
Br,
Stefan
Hi,
I’ve changed my condition to user GID instead. I still cannot get this to work.
Any ideas?
Thanks
Kieran
What if you switch your Condition Action from Memo Insert to Memo Update?
As far as I remember, Memo Insert will only fire when the first memo entry is saved on a case – and most cases should already have one.
Another hint: If you want the trigger to fire only on certain memo types (such as “Problem”), remember to add a line like
Field = Description
Condition = Memo Type
Value = Problem
Hi Stefan,
You are quite right! I’ve changed it to Memo Update and it is now working as expected.
Thanks you very much.
The POB G6 2.0 mobile interfaces for analysts and customers provide great new capabilities and features. The mobile interfaces have a new look and feel and they allow utilization of most areas of POB from a mobile platform. On January 19th, Kevin Goertzen will show and demonstrate the new mobile interfaces in POB G6 2.0 […]
The PUG board has decided to have next year’s Scandinavian conference in a virtual setting. So, mark your calendar for April 20th, 2021, where PUG will host a one-day virtual conference. The decision was made based on the feedback the PUG board got when they asked how participants would feel about attending a physical conference, […]