Guriddo » Topic: Select editoptions displaying value instead of name

Select editoptions displaying value instead of name

Guriddo
Select editoptions displaying value instead of name

This topic has 6 replies, 4 voices, and was last updated 16 years ago by tony.

Creator

Topic
March 19, 2010 at 10:39 pm #75816

ColinKahn
Participant

Hi,

I'm using an edittype:select with editoptions{value:'0:Op1;1:Op2'} and when grid data is loaded it will display '0', '1', instead of 'Op1', 'Op2'. It will only display the name if I edit the cell. When I add a new row it correctly displays the drop down, but once it reloads the grid it will display the '0'/'1' values instead of the names.

Any suggestions?
Creator

Topic

Viewing 6 replies - 1 through 6 (of 6 total)

Author

Replies
March 20, 2010 at 1:08 am #93434

tim
Participant

My guess is that you are storing 0 & 1 as the actual value in your database, and your 'dataurl' webservice is not translating 0 & 1 to their respective display values. When you look at the raw data what's initially being fed into your grid? 0 or Op1?

tim

March 20, 2010 at 1:36 am #93435

ColinKahn
Participant

You're exactly right, the database sends 0 and 1, not the name. But if what you're saying is that it should send 'Op1' what's the point of having value/name pairs when all you're really working with is names?

March 20, 2010 at 2:41 am #93436

tim
Participant

good question …

I am guessing that Tony expects people store the display value in the database for ease when using the search text entered, when I (like you) would rather store the key and have jqGrid translate the display on the client side and let us write code to translate the 'Search Text' back to the key value for look up. Maybe Tony can add an option to handle both ?

tim

March 20, 2010 at 10:33 am #93437

ColinKahn
Participant

Ah, I see what you're saying about the search text. It really seems like a bug, to me though. If you send it values from the DB, and then edit the post, it will show you the name when your finished editing it. It's like some kind of event is triggering that subs the value for the name, but that trigger is only happening after you edit the post.

I guess if there's no known work around for now I could digg around with Firebug…

April 4, 2010 at 3:34 pm #93698

mzazzali
Participant

I was looking for the same thing and I ended up hacking the jqgrid code to get it to show the value instead of the id.

April 8, 2010 at 12:37 pm #93738

tony
Keymaster

Hello,

Yes – formatter select is your solution. It is good first to search the docs

Best regards

Tony
Author

Replies