Guriddo » Topic: Inline Editing : Dynamic Select

Inline Editing : Dynamic Select

Guriddo
Inline Editing : Dynamic Select

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

Creator

Topic
December 16, 2009 at 4:44 pm #74981

admin
Keymaster

Let me first explain a sample scenario:

I have 6 columns of data.(A, B, C, D, E, F)

I have my jqGrid setup for inline editing. Each of these columns performs a dataUrl in the editoptions param.

Column A is a standard lookup, however the remaining columns depend on the select:value of column A. Right now I am using beforeEditCell to capture the rowID of the selected/edited row and I call $.getJSON and pass that rowID to my controller to identify the value of Column A and then perform the lookup for Columns B, C, D, E, F depending on what column's cell the user is trying to edit.

Is there a better way to do this? Perhaps a way when a user goes to edit a cell I can tell the grid to get the value of Column A and pass that to the lookup call?
Creator

Topic

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

Author

Replies
December 18, 2009 at 8:11 pm #91534

tony
Keymaster

Hello,

You can use a dataEvent object to define a event for every select.

More you can find here:

http://www.trirand.com/jqgridwiki/doku.php?id=wiki:common_rules#editoptions

Best Regards

Tony

December 18, 2009 at 10:54 pm #91555

admin
Keymaster

Tony:

Yes, I understand that. However in the dataEvent, I would have to pass the value of ColumnA into the dataEvent for columnB so that my results from that dataEvent would be filtered based on the value of ColumnA.

This was pretty critical and I had to abandon this. Right now I limit the grid display to a specific ColumnA value so that all my other lookup columns can already know what the id of my old ColumnA.

Thanks though!

December 22, 2009 at 9:22 am #91587

tony
Keymaster

Hello,

Look here:

Forum

The trick is maybe if you change the select in A to be to set additional attribute in B which is the value from A and etc.

Best Reagrds

Tony

December 22, 2009 at 3:12 pm #91606

admin
Keymaster

As I understand it, a lot of the form elements are generated 'live'/dynamically. Is the form element for the additional columns even available in the DOM for me to attach a change event on columnA?

December 26, 2009 at 12:05 pm #91650

tony
Keymaster

Hello

Using dataEvents you can attach what you want to what you want if I understand the problem ok.

Best Regards

Tony

December 30, 2009 at 10:17 pm #91773

admin
Keymaster

Thanks for your help Tony. We ended up modifying the way the grid on this page is displayed and auto-setting a filter for ColumnA, that way all the other columns will know to load only the data related to the value for ColumnA.
Author

Replies