Guriddo » Topic: Combo Select Values: Simple Search

Combo Select Values: Simple Search

Guriddo
Combo Select Values: Simple Search

This topic has 4 replies, 2 voices, and was last updated 14 years, 10 months ago by p2pow350.

Creator

Topic
May 26, 2011 at 6:49 pm #78454

p2pow350
Participant

Hi,

again on Combobox/Form Editing.

I'm facing a question about combos, especially for searching values..

I have a decoding table, for ex. PAYMENT_TYPES with this values:

ID | TYPE

1 -> CASH

2 -> CREDIT CARD

And in my customer orders table I have those values:

ORDER_ID | NAME | PAYMENT_ID

567 -> SMITH -> 1

789 -> FOO -> 2

For showing Orders grid I'm using a MySql query that join IDs to show Text inside Grid (for ex. I will show “CASH” and not “1” when listing orders), but this will be a problem for searching because the filter refer to “CASH” and not 1

How to fix this? How to pass the query the correspondant ID, or how to let the grid to decode itself the IDs and show Values?

Thanks

Max
Creator

Topic

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

Author

Replies
May 26, 2011 at 9:40 pm #98092

tony
Keymaster

Hello,

I suppose you do not have time to read the documentation. Is this right?

What about if you look into the documentation for

May 26, 2011 at 10:07 pm #98093

p2pow350
Participant

Hi Tony,

no, it's not a lack of time…

The coltype for column Payment_id is declared in this way:

{name:'fk_id_payment',index:'fk_id_

1

{name:'fk_id_payment',index:'fk_id_

payment

1

payment

', editable: true,edittype:"select", editoptions:{value:"1:CASH;2:CREDIT CARD;"}},

But in my tests using all features I found always this result:

ORDER_ID | NAME | PAYMENT_ID

567 -> SMITH -> 1

789 -> FOO -> 2

If I can I will post a sample page with code to show you.

Thanks

Max

May 27, 2011 at 12:21 am #98095

tony
Keymaster

http://www.trirand.com/jqgridwiki/doku.php?id=wiki:predefined_formatter#formatter_type_select

May 27, 2011 at 11:13 am #98100

p2pow350
Participant

Hi Tony,

using this option “formatter:'select', ” in the colmodel make the difference, now it show exactly the Value and not the ID; in my example it show “CREDIT CARD” and not “2”.

OK, but the problem I'm getting now is for searching and for editing…

For searching: I am making search with the value and not the ID, I'm looking for all orders done with “CREDIT CARD” and the database contain an ID for this column, so the search string the user type contain “CREDIT CARD” and not “2” and no records can be found

For Editing: The grid actually show a combobox for the value, but it's not showing the current record value, it's showing the list from the beginning. If the order has been done with CREDIT CARD, it means it's the second value in the combo, however it always show “CASH” for any record I'm editing. For two elements will be not a problem, for many and many this could be a problem for the user memory….

Thanks

Max
Author

Replies