• State Suggested Answer
  • Locked Locked
  • Replies 2 replies
  • Answers 1 answer
  • Subscribers 96 subscribers
  • Views 4463 views
  • Users 0 members are here
Options
Related
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Unsubscribe all request

lerodriguezdiez
over 7 years ago

Hi all

We need to know if there is anyway to unsubscribe some request based on some where clause we have. We don't want to modify dynamic roles for ITShop as we need to also in some cases retain items on relocation.

We had execute SQLComponent updating OrderState to OrderUnsubscribe as we need to also perform an approvalworkflow but sometimes it doest perform the operations.

Parents
  • 0 over 7 years ago
    Hello,

    Are they just IT Shop requests you want to set as unsubscribed? And the users are not able to unsubscribe themselves?

    The problem with doing this is that you may have orphaned records elsewhere depending on what's been requested, ie a Business Role or AD group.

    Can you provide additional details? A SQL query would do this, but again, you need to confirm a few things ahead of doing this.

    Trevor
Reply
  • 0 over 7 years ago
    Hello,

    Are they just IT Shop requests you want to set as unsubscribed? And the users are not able to unsubscribe themselves?

    The problem with doing this is that you may have orphaned records elsewhere depending on what's been requested, ie a Business Role or AD group.

    Can you provide additional details? A SQL query would do this, but again, you need to confirm a few things ahead of doing this.

    Trevor
Children
No Data