PUG

  • PUG News
  • PUG Forum
  • Shared documents
  • PUG Events
    • Scandinavian Conferences
    • Scandinavian Theme Days
    • D-A-CH Events
    • North American Events
  • PUG Info
    • PUG Board Info (Scandinavia)
    • PUG Rules
    • PUG Member Lists and Board Members
  • Contact Us

Problems with Database actions

  • Follow us on Twitter
  • Join our Facebook Group
  • RSS

Welcome to the POB User Group Online Community! › Forums › PUG International › Problems with Database actions

Viewing 5 posts - 1 through 5 (of 5 total)
  • Author
    Posts
  • 02/09/2019 at 16:29 #4674
    kieranwilson
    Member

    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.

    02/09/2019 at 16:36 #4675
    Stefan Reichelt
    Participant

    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

    02/09/2019 at 16:47 #4676
    kieranwilson
    Member

    Hi,

    I’ve changed my condition to user GID instead. I still cannot get this to work.

    Any ideas?

    Thanks
    Kieran

    02/09/2019 at 16:55 #4677
    Stefan Reichelt
    Participant

    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

    02/09/2019 at 17:20 #4678
    kieranwilson
    Member

    Hi Stefan,

    You are quite right! I’ve changed it to Memo Update and it is now working as expected.

    Thanks you very much.

  • Author
    Posts
Viewing 5 posts - 1 through 5 (of 5 total)
  • You must be logged in to reply to this topic.
Log In

Login

Register | Lost your password?

Menu

  • PUG News
  • PUG Forum
  • Shared documents
  • PUG Events
    • Scandinavian Conferences
    • Scandinavian Theme Days
    • D-A-CH Events
    • North American Events
  • PUG Info
    • PUG Board Info (Scandinavia)
    • PUG Rules
    • PUG Member Lists and Board Members
  • Contact Us

Pages

  • Anmeldung zur PUG Konferenz 2018
  • Contact us
  • Forgot Password
  • Login
  • Lost password
  • POB Tip – Filtering lists to show only limited data
  • Profile
  • Registration
  • Registration for PUG 2019 in Scandinavia
  • Registration for PUG 2020 in Scandinavia
  • Skandinavisk PUG konference 2014 (Hurdal, Norge)
  • Skandinavisk PUG konference 2017 (Sundvolden, Norge)
  • Tilmelding til / Anmälan till PUG 2015 i Sollentuna
  • Tilmelding til erfamøde hos Frederiksberg Kommune
  • Tilmelding til PUG 2016 / Anmälan till PUG 2016
  • Tilmelding til PUG 2018 / Anmälan till PUG 2018
  • Udfyld nedenstĂĄende felter hvis du ønsker at melde jer ind i PUG
  • Welcome to the POB User Group Online Community!
  • Wendia North America 2018 Customer-Partner Conference Registration Form
  • Wendia North America 2019 Customer-Partner Conference Registration Form
  • You are not a member?
  • Webinar on the New Mobile Web Apps in POB G6 2.006/01/2021 - 13:41

    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 […]

  • December Webinar on Triggers in POB27/11/2020 - 12:10
  • PUG 2021 – Redesigned for a Virtual Setting (Scandinavia)13/11/2020 - 11:29

    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, […]

© Copyright - PUG - All rights reserved by PUG © 2012
  • Send us Mail
  • Follow us on Twitter
  • Join our Facebook Group
  • Subscribe to our RSS Feed