Guriddo » Topic: Grid as SubGrid – beforeShowForm

Grid as SubGrid – beforeShowForm – Set Value

Guriddo
Grid as SubGrid – beforeShowForm – Set Value

This topic has 7 replies, 2 voices, and was last updated 17 years, 4 months ago by tony.

Creator

Topic
November 22, 2008 at 9:40 am #72392

Barry.Breaux
Participant

Great job on jqgrid. The more I learn the more I like! I've got my reads and edits working great. Trying to iron our the add controls.

In the parent grid I have a key column “ID_1”. It is a FK of the child grid.

I click on the + button and the child grid and all the fields are correctly displayed.

I am using the navGrid Add button.

I've been reading the forums for hours and haven't found an example. I found comments and instructions for accessing a selected row in the parent grid, but since I clicked on the + button, the parent row is NOT selected.

When the ADD form is created I want to insert the value of ID_1 from the parent row.

I don't know how to access the value from the parent grids row.

I don't know how to set this value in the ADD form.

beforeShowForm : function(form_id){
Creator

Topic

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

Author

Replies
November 22, 2008 at 8:24 pm #84335

Barry.Breaux
Participant

Ok, I figured out how to set the $ID_1 value in the form!

beforeShowForm : function(form_id)
{

November 24, 2008 at 1:05 am #84343

tony
Keymaster

Hello,

I suppose you use grid as subgrid

When you open the subgrid in subGridRowExpanded the

second parameter is the id of the row – then

subGridRowExpanded : function (sub_id, row_id) {

…

$(“#mygrid”).setSelection(row_id);

…

}

This will select your row.

Regards

Tony

November 24, 2008 at 8:40 am #84354

Barry.Breaux
Participant

Tony,

That makes sense!. I was thinking that since the row was not selected in the exampe that there might be a way of getting the row if it was not selected.

For my project, in this case, it is correct to select the row. I suppose that in trees expand and select node are distinct operations often. In a grid it probably the case that select on expand is almost always correct.

Thanks for you help on this!

Barry

November 25, 2008 at 7:46 am #84377

Barry.Breaux
Participant

Tony,

SubGrid as Grid configuration (Master-Detail):

I set the row to selected on expand. When I click add to open the modal add dialog the FK index is correctly set in the Add Form.

Here is a problem. The user can select another row in the master grid. If the user selects another row then the add form dialog wil contain the FK value from the new (currently) selected row.

What the SubGrid needs to know is the ID of the row that caused it to open. Have you considered this? Is there a built in solution?

Thanks!

Barry

November 26, 2008 at 1:06 am #84392

tony
Keymaster

Hello,

Sorry but It is difficult to understand.

What is FK index?

Where is your add button? Where the user click to add

November 26, 2008 at 7:31 am #84404

Barry.Breaux
Participant

Tony,

Foreign Key Index – The key that linkes a master – a foreign key is a referential constraint between two tables. Its the key that makes a master-detail relationship.

Add button… both the master table and the detail table has an add button on the bottom of the grid. The problem is with the detail table (sub grid). The sub grid needs to know the FK of the master table . The subgrid needs to know which row is the master. I am currently doing that by setting the selected row and then getting the value from the selected row. That works until the user clicks on another row.

Barry

November 27, 2008 at 3:23 am #84416

tony
Keymaster

Hello,

One
Author

Replies