Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Status Reason Field RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    I am trying to find the behind the scene view for the Status Reason. Where is that located in the opportunities in SQL?
    Tuesday, May 19, 2015 1:35 PM

Answers

  • Question
    Sign in to vote
    1
    Sign in to vote

    The option set values are stored in StringMap, and the mapping between the Status Reason (statuscode) and Status (statecode) are in Status Map.

    You can use the following queries (objecttypecode = 3 is the opportunity entity):

    select * from stringmap where objecttypecode = 3
and attributename = 'statuscode'

select * from StatusMap where ObjectTypeCode = 3

    Microsoft CRM MVP - http://mscrmuk.blogspot.com/ http://www.excitation.co.uk

    • Proposed as answer by Jason CosmanMVP Wednesday, May 20, 2015 11:15 AM
    • Marked as answer by wsilage Wednesday, May 20, 2015 1:43 PM
    Wednesday, May 20, 2015 10:56 AM
    Moderator
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hello Wsilage;

    Can I ask what version of CRM you are using for this? The Status Reason is just an option set within CRM that is modifiable in any solution or the system configuration. You can start with the AttributeMapBase table; which will provide all of the attributes by entity. You can find the Status Reason attribute GUID from within there. I believe it can be cross referenced to PickListMappingBase. I am currently looking at a CRM 2015 database but I think this holds up in 2013 and 2011 as well.

    Let me know if this doesn't direct you to the right location and which CRM your using. I can most likely find it directly for you. Thanks!

    Jason Cosman

    • Marked as answer by wsilage Wednesday, May 20, 2015 1:43 PM
    Tuesday, May 19, 2015 8:07 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hello Wendy!. There isn't a way of modifying that screen. In CRM 2015 your able to modify as it has it's own form and entity; but in CRM 2011 your stuck with what it has.

    I haven't explored any unsupported changes in this form; in the past I've always left it that way. If it really needed a bunch of changes I'd create a section on the form for Closing it and the same fields filled out with a workflow that would close it etc.

    Jason Cosman

    • Marked as answer by wsilage Wednesday, May 20, 2015 6:19 PM
    Wednesday, May 20, 2015 1:48 PM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hello Wsilage;

    Can I ask what version of CRM you are using for this? The Status Reason is just an option set within CRM that is modifiable in any solution or the system configuration. You can start with the AttributeMapBase table; which will provide all of the attributes by entity. You can find the Status Reason attribute GUID from within there. I believe it can be cross referenced to PickListMappingBase. I am currently looking at a CRM 2015 database but I think this holds up in 2013 and 2011 as well.

    Let me know if this doesn't direct you to the right location and which CRM your using. I can most likely find it directly for you. Thanks!

    Jason Cosman

    • Marked as answer by wsilage Wednesday, May 20, 2015 1:43 PM
    Tuesday, May 19, 2015 8:07 PM
  • Question
    Sign in to vote
    1
    Sign in to vote

    The option set values are stored in StringMap, and the mapping between the Status Reason (statuscode) and Status (statecode) are in Status Map.

    You can use the following queries (objecttypecode = 3 is the opportunity entity):

    select * from stringmap where objecttypecode = 3
and attributename = 'statuscode'

select * from StatusMap where ObjectTypeCode = 3

    Microsoft CRM MVP - http://mscrmuk.blogspot.com/ http://www.excitation.co.uk

    • Proposed as answer by Jason CosmanMVP Wednesday, May 20, 2015 11:15 AM
    • Marked as answer by wsilage Wednesday, May 20, 2015 1:43 PM
    Wednesday, May 20, 2015 10:56 AM
    Moderator
  • Question
    Sign in to vote
    0
    Sign in to vote
    David's got it; good job! I didn't get a chance to dig into to much; I'll make sure to note this for personal knowledge as well. Cheers

    Jason Cosman

    Wednesday, May 20, 2015 11:15 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Thanks that helped a lot.

    We are using 2011. I have another question. The image that I have in my post is there any way to add a field to that box. I am thinking it won't be easy and if it was done, it would have to be coded in. What are the CONS of doing this? I personally rather not do it, but had to ask because a user may want this.

    Thanks!

    Wendy

    Wednesday, May 20, 2015 1:45 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hello Wendy!. There isn't a way of modifying that screen. In CRM 2015 your able to modify as it has it's own form and entity; but in CRM 2011 your stuck with what it has.

    I haven't explored any unsupported changes in this form; in the past I've always left it that way. If it really needed a bunch of changes I'd create a section on the form for Closing it and the same fields filled out with a workflow that would close it etc.

    Jason Cosman

    • Marked as answer by wsilage Wednesday, May 20, 2015 6:19 PM
    Wednesday, May 20, 2015 1:48 PM