Sign in Register
Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • lori ryan 239 posts 573 karma points
    May 10, 2018 @ 11:23
    lori ryan
    0

    publishing documenttype of type 'x' exec Store procedure

    Hi

    Unsure if this is possible. When I publish a documenttype of type 'x' is it possible to trigger a store procedure as well? Any help or pointers would be fantastic.

    Copy Link
  • Nathan Woulfe 447 posts 1665 karma points MVP 5x hq c-trib
    May 10, 2018 @ 11:40
    Nathan Woulfe
    100

    Hi Lori

    Sounds like this might be useful -> https://our.umbraco.org/documentation/Reference/Events/ContentService-Events

    N

    Copy Link
  • lori ryan 239 posts 573 karma points
    May 10, 2018 @ 11:44
    lori ryan
    0

    Hey Nathan Thank you so much for coming back to me so fast. I will give it a go :-) Lori

    Copy Link
  • Dan Diplo 1554 posts 6205 karma points MVP 6x c-trib
    May 10, 2018 @ 11:48
    Dan Diplo
    0

    Does it have to be a stored procedure?

    The simplest way I can think of would be to use the built-in events that can be raised when content is changed - see https://our.umbraco.org/Documentation/Reference/Events/ContentService-Events

    So you can raise an event when content is published, check the doctype alias and then conditionally execute some code. In your case you'd use the ContentPublished event to hook into.

    If you really need to then execute a stored procedure you could do so at this point via code. Umbraco exposes a Database class that you can access via ApplicationContext to run database queries. So it would be something like:

    ApplicationContext.Current.DatabaseContext.Database.Execute(";EXEC spMyProcedure"); See https://our.umbraco.org/forum/umbraco-7/using-umbraco-7/63877-Calling-a-stored-procedure-and-get-results

    Copy Link
  • lori ryan 239 posts 573 karma points
    May 14, 2018 @ 08:55
    lori ryan
    0

    works brilliantly Thank you so much for the help Dan Diplo and Nathan Woulfe

    Copy Link

  • This forum is in read-only mode while we transition to the new forum.

    You can continue this topic on the new forum by tapping the "Continue discussion" link below.

Please Sign in or register to post replies