I have a picklist new_Company in a Custom Entity.
When we select the Company in the Header of the View, the sort is by int
Value, not by the Label (Company Name). Is this a problem because with the
Custom Entity?

I noticed the Case Type in Cases sorts Alphabetically, not by the Value.

Any workarounds?

Thank you!

RE: Can I select Picklist Value in View to sort by name instead of val by FrankLee

FrankLee
Wed May 07 01:03:00 CDT 2008

Something is wrong. We have many custom enities with new picklist attribute.
In a view, it is sorted alphabetically. I'd just confirmed it in one of our
4.0 environments.

Try testing it out with another new picklist attribute to see if it behaves
the same.


Frank Lee, Microsoft Dynamics CRM MVP
http://microsoft-crm.spaces.live.com
http://www.workopia.com/Links.htm


"Marty" wrote:

> I have a picklist new_Company in a Custom Entity.
> When we select the Company in the Header of the View, the sort is by int
> Value, not by the Label (Company Name). Is this a problem because with the
> Custom Entity?
>
> I noticed the Case Type in Cases sorts Alphabetically, not by the Value.
>
> Any workarounds?
>
> Thank you!

Re: Can I select Picklist Value in View to sort by name instead of val by Ian

Ian
Wed May 07 07:30:31 CDT 2008

do you have the sort ascending set in the attribute of the entity?

Ian
"Frank Lee" <FrankLee@discussions.microsoft.com> wrote in message
news:EF389584-0DE7-46DF-8E05-01B729CE98C7@microsoft.com...
> Something is wrong. We have many custom enities with new picklist
> attribute.
> In a view, it is sorted alphabetically. I'd just confirmed it in one of
> our
> 4.0 environments.
>
> Try testing it out with another new picklist attribute to see if it
> behaves
> the same.
>
>
> Frank Lee, Microsoft Dynamics CRM MVP
> http://microsoft-crm.spaces.live.com
> http://www.workopia.com/Links.htm
>
>
> "Marty" wrote:
>
>> I have a picklist new_Company in a Custom Entity.
>> When we select the Company in the Header of the View, the sort is by int
>> Value, not by the Label (Company Name). Is this a problem because with
>> the
>> Custom Entity?
>>
>> I noticed the Case Type in Cases sorts Alphabetically, not by the Value.
>>
>> Any workarounds?
>>
>> Thank you!



RE: Can I select Picklist Value in View to sort by name instead of by Marty

Marty
Wed May 07 08:43:01 CDT 2008

We're using 3.0. I created a new picklist COTEST, assigned the values as
follows 1=b, 2=c, 3=a; then I sorted the default View by COTEST, edited the
records to include this new picklist attribute's value, and looked at the
View.
The COTEST sorts by the b,c,a order. When I select the Header COTEST, it
reverse sorts a,c,b.

Do you know for a fact that 3.0 sorts the picklist by name, or was the name
coincidentally entered in alpha order (1=a,2=b,3=c)?

Thank you!

"Frank Lee" wrote:

> Something is wrong. We have many custom enities with new picklist attribute.
> In a view, it is sorted alphabetically. I'd just confirmed it in one of our
> 4.0 environments.
>
> Try testing it out with another new picklist attribute to see if it behaves
> the same.
>
>
> Frank Lee, Microsoft Dynamics CRM MVP
> http://microsoft-crm.spaces.live.com
> http://www.workopia.com/Links.htm
>
>
> "Marty" wrote:
>
> > I have a picklist new_Company in a Custom Entity.
> > When we select the Company in the Header of the View, the sort is by int
> > Value, not by the Label (Company Name). Is this a problem because with the
> > Custom Entity?
> >
> > I noticed the Case Type in Cases sorts Alphabetically, not by the Value.
> >
> > Any workarounds?
> >
> > Thank you!

Re: Can I select Picklist Value in View to sort by name instead of by Marty

Marty
Wed May 07 08:43:01 CDT 2008

Yes - that did not change it. We are on 3.0.

"Ian Watson" wrote:

> do you have the sort ascending set in the attribute of the entity?
>
> Ian
> "Frank Lee" <FrankLee@discussions.microsoft.com> wrote in message
> news:EF389584-0DE7-46DF-8E05-01B729CE98C7@microsoft.com...
> > Something is wrong. We have many custom enities with new picklist
> > attribute.
> > In a view, it is sorted alphabetically. I'd just confirmed it in one of
> > our
> > 4.0 environments.
> >
> > Try testing it out with another new picklist attribute to see if it
> > behaves
> > the same.
> >
> >
> > Frank Lee, Microsoft Dynamics CRM MVP
> > http://microsoft-crm.spaces.live.com
> > http://www.workopia.com/Links.htm
> >
> >
> > "Marty" wrote:
> >
> >> I have a picklist new_Company in a Custom Entity.
> >> When we select the Company in the Header of the View, the sort is by int
> >> Value, not by the Label (Company Name). Is this a problem because with
> >> the
> >> Custom Entity?
> >>
> >> I noticed the Case Type in Cases sorts Alphabetically, not by the Value.
> >>
> >> Any workarounds?
> >>
> >> Thank you!
>
>
>

RE: Can I select Picklist Value in View to sort by name instead of by FrankLee

FrankLee
Wed May 07 12:10:32 CDT 2008

Ok, there maybe an issue with 3.0, please check KB or submit it support case.
Has your 3.0 updated with the lastest Update Rollup?

With 4.0, it works fine - it is not sort on the picklist ID, but the display
value.

"Marty" wrote:

> We're using 3.0. I created a new picklist COTEST, assigned the values as
> follows 1=b, 2=c, 3=a; then I sorted the default View by COTEST, edited the
> records to include this new picklist attribute's value, and looked at the
> View.
> The COTEST sorts by the b,c,a order. When I select the Header COTEST, it
> reverse sorts a,c,b.
>
> Do you know for a fact that 3.0 sorts the picklist by name, or was the name
> coincidentally entered in alpha order (1=a,2=b,3=c)?
>
> Thank you!
>
> "Frank Lee" wrote:
>
> > Something is wrong. We have many custom enities with new picklist attribute.
> > In a view, it is sorted alphabetically. I'd just confirmed it in one of our
> > 4.0 environments.
> >
> > Try testing it out with another new picklist attribute to see if it behaves
> > the same.
> >
> >
> > Frank Lee, Microsoft Dynamics CRM MVP
> > http://microsoft-crm.spaces.live.com
> > http://www.workopia.com/Links.htm
> >
> >
> > "Marty" wrote:
> >
> > > I have a picklist new_Company in a Custom Entity.
> > > When we select the Company in the Header of the View, the sort is by int
> > > Value, not by the Label (Company Name). Is this a problem because with the
> > > Custom Entity?
> > >
> > > I noticed the Case Type in Cases sorts Alphabetically, not by the Value.
> > >
> > > Any workarounds?
> > >
> > > Thank you!

Re: Can I select Picklist Value in View to sort by name instead of by Marty

Marty
Wed May 14 17:16:00 CDT 2008

I logged a ticket with Microsoft - turns out you can only sort by the
picklist int value; the workaround...enter in A-Z order (that's fine, until
you add more values!) And it's unsupported to create a temp SQL table to
store old and new values and update the current list in A-Z order.

Marty

"Marty" wrote:

> Yes - that did not change it. We are on 3.0.
>
> "Ian Watson" wrote:
>
> > do you have the sort ascending set in the attribute of the entity?
> >
> > Ian
> > "Frank Lee" <FrankLee@discussions.microsoft.com> wrote in message
> > news:EF389584-0DE7-46DF-8E05-01B729CE98C7@microsoft.com...
> > > Something is wrong. We have many custom enities with new picklist
> > > attribute.
> > > In a view, it is sorted alphabetically. I'd just confirmed it in one of
> > > our
> > > 4.0 environments.
> > >
> > > Try testing it out with another new picklist attribute to see if it
> > > behaves
> > > the same.
> > >
> > >
> > > Frank Lee, Microsoft Dynamics CRM MVP
> > > http://microsoft-crm.spaces.live.com
> > > http://www.workopia.com/Links.htm
> > >
> > >
> > > "Marty" wrote:
> > >
> > >> I have a picklist new_Company in a Custom Entity.
> > >> When we select the Company in the Header of the View, the sort is by int
> > >> Value, not by the Label (Company Name). Is this a problem because with
> > >> the
> > >> Custom Entity?
> > >>
> > >> I noticed the Case Type in Cases sorts Alphabetically, not by the Value.
> > >>
> > >> Any workarounds?
> > >>
> > >> Thank you!
> >
> >
> >