jQuery Grid Plugin - jqGridForum

Topic RSS

how to fill a select in editing form with a query

10/10/2010
16:32

bogoa666

Malaga (Spain)

Member

Members

Forum Posts: 21

Member Since:
23/09/2010

Offline

Hi, i have two tables and one of them depends of the other. So, when I want to add or edit a row of the second table, I need to fill a select with a query where the result are the diffents rows of the first table. Is it possible?

Thanks

13/10/2010
19:07

whoknows

Member

Members

Forum Posts: 4

Member Since:
27/09/2010

Offline

Hi,

I have exactly the same problem, so if you find the answer let me know about it :).

14/10/2010
00:30

bogoa666

Malaga (Spain)

Member

Members

Forum Posts: 21

Member Since:
23/09/2010

Offline

it's work!!!

The solution is to use de dataUrl option in editoptions of colModel

jquery code:

colModel :[{name:'notification', index:'notification', width:110, align:'center', editable:true, edittype:'select', editoptions:{dataUrl:'/application/getNotificationSelect'}, searchoptions: { sopt: ['eq'], value:"true:Yes;false:No" }, stype: 'select'}]

server code:

public static void getNotificationSelect(){
String xml = "<select><option value='true'>Yes</option><option value='false'>No</option></select>";
renderXml(xml);
}

You only have to change the xml with other which was generated with your query items. This is only an example.

Note: renderXml(String xml) is a method of playframework which is the framework I use but you can use the same mothod to load the rows in the grid.

14/10/2010
10:05

whoknows

Member

Members

Forum Posts: 4

Member Since:
27/09/2010

Offline

Nice !

Thanks a lot :).

All RSS

Forum Timezone: Europe/Sofia

Most Users Ever Online: 715

Currently Online:
68 Guest(s)

Currently Browsing this Page:
1 Guest(s)