Using non-standard primary keys

[panchox9103]

Hi everyone.

I have a table that doesn't use the standar in the definition for the primary key.

When try to use will_filter, it generate a "ORDER BY id desc" but this column doesn't exists.

In the model I defined the correst name for the primary key: self.primary_key = 'name_primary_key'

What I need to do for will_filter use this primary key and not the "id" ?

Thanks.

[seuros]

Can you post the Log output ?

[panchox9103]

This is the error message:

"ID": invalid identifier: SELECT * FROM (
SELECT raw_sql_., rownum raw_rnum
FROM (SELECT "VMCLIENTES"._ FROM "VMCLIENTES" ORDER BY id desc) raw_sql_
)
WHERE raw_rnum_ between 1 and 30

My primary key for this table, is called "codigocliente".

Thanks.

[ajeetksingh]

hey @panchox9103 did u find any solution for the error you have mentioned.. I am kinda stuck at it..!

[panchox9103]

nop.

I'm using ransack (https://github.com/ernie/ransack http://railscasts.com/episodes/370-ransack?view=asciicast) for the filters.

[Seaborg]

Try:

def default_order
'yourPrimaryKey'
end