Serious problem in using Sort functionality.

[Mayur Ahir]

I am having big trouble in using Sort functionality of YiiMongoDbSuite. Please help me here is my code.

http://pastebin.com/raw.php?i=gfbha56Y

The thing is I am able to execute above things except SORT rest all filters are working fine.

[Attila Nagy]

On Fri, Nov 25, 2011 at 1:42 PM, Mayur Ahir <ahir...@gmail.com> wrote:
> I am having big trouble in using Sort functionality of YiiMongoDbSuite.
> Please help me here is my code.
>
> http://pastebin.com/raw.php?i=gfbha56Y

your code seems to be fine to me. Are you aware, that MongoDB does not
support locales in sorting? It will sort only by the default english
alphabet, and also case sensitive: uppercase letters will precede the
lower case letters.

So this is a 'valid' alphabetical sort by the mongo:

1984, December, February, January, apple, banana, foobar

--
Nagy Attila Gabor

[Mayur Ahir]

Yes I am aware of that and that isn't my real concern the problem is it just doesn't sort anything. I have tried with both options EMongoCriteria::SORT_DESC and EMongoCriteria::SORT_ASC on last_modified which is MongoDate() Object.

[Attila Nagy]

does it work for other fields? (string or number type?)

--
Nagy Attila Gabor

[Mayur Ahir]

I have tried it with almost all kinds of types e.g. category, msg_body etc but still no success... :(

[Attila Nagy]

On Fri, Nov 25, 2011 at 3:03 PM, Mayur Ahir <ahir...@gmail.com> wrote:
> I have tried it with almost all kinds of types e.g. category, msg_body etc
> but still no success... :(
>

hmm, what is this 'tenant()' method doing on your Messages::model()?
does it return the original model?

--
Nagy Attila Gabor

[Mayur Ahir]

tenant() is just a chained method which return original model with required data. I have also tried without using
i.e.

$return_messages = Messages::model()->findAll($criteria);

[Mayur Ahir]

Ok this is working now problem was with overlapping sort queries.