CODEWITHSUNDEEP
grailsgrails-ormgrails-domain-class
naimul64
naimul64

Reputation: 133

How to apply index in descending order in grails domain class?

I have written a domain class

class ReportCallByUser {
Integer userId;
String userName;
String reportName;
Date timeOfReportCall;

static constraints = {
}

static mapping = {

    timeOfReportCall index: 'time_of_report_call_index'
}

The last line creates an index in database but in ascending order. How can I create index on 'timeOfReportCall' with descending order?
Thanks in advance.

Upvotes: 2

Views: 543

Answers (2)

elixir
elixir

Reputation: 1442

I am assuming that you want the results in descending order by default when you query the database using GORM. If that is the case, you can specify sort order in your mapping as such.

static mapping = {
    sort timeOfReportCall:"desc"
}

Hope that helps.

Upvotes: 0

injecteer
injecteer

Reputation: 20699

There's no such thing as order in regards to index creation. It's the query's ability to specify the ordering:

ReportCallByUser.list( [ sort:'timeOfReportCall', order:'[desc|asc]' ] )

Upvotes: 1

Related Questions