Hi,

Does anyone know what table stores opportunity status reason value? I tried
doing mail merge for email and i need that status reason value to be
included. I tried using &opportunity.statuscode; however it returned the
numerical value.

Could someone help me on this?

Thanks
Carrie

RE: Opportunity status reason value by MattNC

MattNC
Wed May 25 07:55:01 CDT 2005

For picklists you always have two values: a numerical value and the text
value. Where opportunity.statuscode returns the numerical value,
opportunity.statuscodename should give you the text value.
--
Matt Wittemann
http://icu-mscrm.blogspot.com


"Carrie" wrote:

> Hi,
>
> Does anyone know what table stores opportunity status reason value? I tried
> doing mail merge for email and i need that status reason value to be
> included. I tried using &opportunity.statuscode; however it returned the
> numerical value.
>
> Could someone help me on this?
>
> Thanks
> Carrie

RE: Opportunity status reason value by Carrie

Carrie
Fri May 27 02:54:01 CDT 2005

Hi Matt,

I tried using &opportunity.statuscodename; however it did not return any
values. I also checked the schema for opportunity table and status code name
was not there. Is that the right table to refer to when we need the value of
status code name??

Carrie

"MattNC" wrote:

> For picklists you always have two values: a numerical value and the text
> value. Where opportunity.statuscode returns the numerical value,
> opportunity.statuscodename should give you the text value.
> --
> Matt Wittemann
> http://icu-mscrm.blogspot.com
>
>
> "Carrie" wrote:
>
> > Hi,
> >
> > Does anyone know what table stores opportunity status reason value? I tried
> > doing mail merge for email and i need that status reason value to be
> > included. I tried using &opportunity.statuscode; however it returned the
> > numerical value.
> >
> > Could someone help me on this?
> >
> > Thanks
> > Carrie

Re: Opportunity status reason value by Peter

Peter
Fri May 27 07:01:20 CDT 2005

Are trying to use the unpublished slugs method to populate a workflow
generated email (not a template) ? If so, it is not feasible to get slugs to
pull back picklist values (well, at least no-one has yet found a way and
published it in this newgroup). Believe me, many have tried. That's one of
their disadvantages.

"Carrie" <Carrie@discussions.microsoft.com> wrote in message
news:310E4F02-135B-46C8-9E7F-CF589E5FA101@microsoft.com...
> Hi Matt,
>
> I tried using &opportunity.statuscodename; however it did not return any
> values. I also checked the schema for opportunity table and status code
> name
> was not there. Is that the right table to refer to when we need the value
> of
> status code name??
>
> Carrie
>
> "MattNC" wrote:
>
>> For picklists you always have two values: a numerical value and the text
>> value. Where opportunity.statuscode returns the numerical value,
>> opportunity.statuscodename should give you the text value.
>> --
>> Matt Wittemann
>> http://icu-mscrm.blogspot.com
>>
>>
>> "Carrie" wrote:
>>
>> > Hi,
>> >
>> > Does anyone know what table stores opportunity status reason value? I
>> > tried
>> > doing mail merge for email and i need that status reason value to be
>> > included. I tried using &opportunity.statuscode; however it returned
>> > the
>> > numerical value.
>> >
>> > Could someone help me on this?
>> >
>> > Thanks
>> > Carrie



Re: Opportunity status reason value by Carrie

Carrie
Tue May 31 22:33:01 CDT 2005

Hi Peter,

Thanks for your feedback. If you find the way later on, let me know.

Carrie

"Peter Lynch" wrote:

> Are trying to use the unpublished slugs method to populate a workflow
> generated email (not a template) ? If so, it is not feasible to get slugs to
> pull back picklist values (well, at least no-one has yet found a way and
> published it in this newgroup). Believe me, many have tried. That's one of
> their disadvantages.
>
> "Carrie" <Carrie@discussions.microsoft.com> wrote in message
> news:310E4F02-135B-46C8-9E7F-CF589E5FA101@microsoft.com...
> > Hi Matt,
> >
> > I tried using &opportunity.statuscodename; however it did not return any
> > values. I also checked the schema for opportunity table and status code
> > name
> > was not there. Is that the right table to refer to when we need the value
> > of
> > status code name??
> >
> > Carrie
> >
> > "MattNC" wrote:
> >
> >> For picklists you always have two values: a numerical value and the text
> >> value. Where opportunity.statuscode returns the numerical value,
> >> opportunity.statuscodename should give you the text value.
> >> --
> >> Matt Wittemann
> >> http://icu-mscrm.blogspot.com
> >>
> >>
> >> "Carrie" wrote:
> >>
> >> > Hi,
> >> >
> >> > Does anyone know what table stores opportunity status reason value? I
> >> > tried
> >> > doing mail merge for email and i need that status reason value to be
> >> > included. I tried using &opportunity.statuscode; however it returned
> >> > the
> >> > numerical value.
> >> >
> >> > Could someone help me on this?
> >> >
> >> > Thanks
> >> > Carrie
>
>
>

Re: Opportunity status reason value by Peter

Peter
Wed Jun 01 03:34:39 CDT 2005

There is a clumsy workround that consumes lots of space. For every picklist
field you need to grab data from in slugs, add a corresponding text field.
Then write a jscript OnChange event that writes the text value of the
picklist to the text field. Grab the text from text field in your slug. Hide
all the nasty text fields in tab or section that no-one needs to use.




"Carrie" <Carrie@discussions.microsoft.com> wrote in message
news:C911EAE0-9BF9-4E5F-A517-BB71072945E8@microsoft.com...
> Hi Peter,
>
> Thanks for your feedback. If you find the way later on, let me know.
>
> Carrie
>
> "Peter Lynch" wrote:
>
>> Are trying to use the unpublished slugs method to populate a workflow
>> generated email (not a template) ? If so, it is not feasible to get slugs
>> to
>> pull back picklist values (well, at least no-one has yet found a way and
>> published it in this newgroup). Believe me, many have tried. That's one
>> of
>> their disadvantages.
>>
>> "Carrie" <Carrie@discussions.microsoft.com> wrote in message
>> news:310E4F02-135B-46C8-9E7F-CF589E5FA101@microsoft.com...
>> > Hi Matt,
>> >
>> > I tried using &opportunity.statuscodename; however it did not return
>> > any
>> > values. I also checked the schema for opportunity table and status code
>> > name
>> > was not there. Is that the right table to refer to when we need the
>> > value
>> > of
>> > status code name??
>> >
>> > Carrie
>> >
>> > "MattNC" wrote:
>> >
>> >> For picklists you always have two values: a numerical value and the
>> >> text
>> >> value. Where opportunity.statuscode returns the numerical value,
>> >> opportunity.statuscodename should give you the text value.
>> >> --
>> >> Matt Wittemann
>> >> http://icu-mscrm.blogspot.com
>> >>
>> >>
>> >> "Carrie" wrote:
>> >>
>> >> > Hi,
>> >> >
>> >> > Does anyone know what table stores opportunity status reason value?
>> >> > I
>> >> > tried
>> >> > doing mail merge for email and i need that status reason value to be
>> >> > included. I tried using &opportunity.statuscode; however it returned
>> >> > the
>> >> > numerical value.
>> >> >
>> >> > Could someone help me on this?
>> >> >
>> >> > Thanks
>> >> > Carrie
>>
>>
>>