645
Hey I need to change entity -Incident- status from resolved - 0 to active -1, I'm trying to use SQL the values have changed after I run my query but when I refresh the incident I see that it still at Resolved mode, Am I missing something ? how can I change the state or can I change the state?
*This post is locked for comments
It appears that the button reactivate case is only available for individual record. As these are just 6 records, I would suggest to perform the action for each case record. Alternatively as suggested aboce, you can create a workflow which changes the status and then run that workflow on all required records.
Hope this helps.
If its only 6 records then you can do this from UI/ application itself. There is no benefit of doing this with sql/code or workflows. Login to CRM, search for the required records and click "Reactivate Case".
Hi,
If you want no code approach then create a workflow which change the status from resolved to active and then run workflow on all the required records.
Hope this helps.
Hi,
using SQL query is highly not recommended. Please do not use it next time. You can refer below article on how to change the status.
docs.microsoft.com/.../gg308277(v%3Dcrm.8)
www.dynamict.eu/.../update-status-statecode-statuscode-of-a-crm-record-using-c
https://nishantrana.me/2012/02/06/reactivate-case-in-crm-2011/
Hi ,
Why you are using sql query directly , change using code. Check here -
Using c#
community.dynamics.com/.../271648
Using web api javascript-
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,321
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
