jQuery Grid Plugin - jqGrid - Topic: Select editoptions displaying value instead of name http://www.trirand.com/blog/?page_id=393/help/select-editoptions-displaying-value-instead-of-name Simple:Press Version 5.7.5.3 tony on Select editoptions displaying value instead of name http://www.trirand.com/blog/?page_id=393/help/select-editoptions-displaying-value-instead-of-name#p16291 Help http://www.trirand.com/blog/?page_id=393/help/select-editoptions-displaying-value-instead-of-name#p16291 Hello,

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

Best regards

Tony

]]> Thu, 08 Apr 2010 12:37:01 +0300 mzazzali on Select editoptions displaying value instead of name http://www.trirand.com/blog/?page_id=393/help/select-editoptions-displaying-value-instead-of-name#p16229 Help http://www.trirand.com/blog/?page_id=393/help/select-editoptions-displaying-value-instead-of-name#p16229 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.  However I just came across this post which seems to be the real solution.  I haven't tried it yet but it seems to be what both of us were looking for.

/blog/?page_id=393/help/select-boxes-view-in-grid/&value=select%20value&type=1&include=1&search=1&ret=all

]]> Sun, 04 Apr 2010 15:34:59 +0300 ColinKahn on Select editoptions displaying value instead of name http://www.trirand.com/blog/?page_id=393/help/select-editoptions-displaying-value-instead-of-name#p15853 Help http://www.trirand.com/blog/?page_id=393/help/select-editoptions-displaying-value-instead-of-name#p15853 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...

]]> Sat, 20 Mar 2010 10:33:38 +0200 tim on Select editoptions displaying value instead of name http://www.trirand.com/blog/?page_id=393/help/select-editoptions-displaying-value-instead-of-name#p15851 Help http://www.trirand.com/blog/?page_id=393/help/select-editoptions-displaying-value-instead-of-name#p15851 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

]]> Sat, 20 Mar 2010 02:41:59 +0200 ColinKahn on Select editoptions displaying value instead of name http://www.trirand.com/blog/?page_id=393/help/select-editoptions-displaying-value-instead-of-name#p15850 Help http://www.trirand.com/blog/?page_id=393/help/select-editoptions-displaying-value-instead-of-name#p15850 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?

]]> Sat, 20 Mar 2010 01:36:49 +0200 tim on Select editoptions displaying value instead of name http://www.trirand.com/blog/?page_id=393/help/select-editoptions-displaying-value-instead-of-name#p15849 Help http://www.trirand.com/blog/?page_id=393/help/select-editoptions-displaying-value-instead-of-name#p15849 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

]]> Sat, 20 Mar 2010 01:08:29 +0200 ColinKahn on Select editoptions displaying value instead of name http://www.trirand.com/blog/?page_id=393/help/select-editoptions-displaying-value-instead-of-name#p15848 Help http://www.trirand.com/blog/?page_id=393/help/select-editoptions-displaying-value-instead-of-name#p15848 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?

]]> Fri, 19 Mar 2010 22:39:43 +0200