jQuery Grid Plugin - jqGridForum

Topic RSS

Support multi PrimaryKey in grid

29/01/2010
10:42

irangame

Iran, Markazi

Member

Members

Forum Posts: 5

Member Since:
10/01/2010

Offline

Hi all,

I think that we need to support multi PrimaryKey in jqGrid, for example (data_id, user_id).

when I calll Navigator's Delete button, grid send only row id to server for deletting.

Do you have any idea about that?

-Mojtaba Ebrahimi-

01/02/2010
10:26

tony

Sofia, Bulgaria

Moderator

Members

Moderators

Forum Posts: 7721

Member Since:
30/10/2007

Offline

Hello,

You can post any other value when a row is deleted. By example you can use onclickSubmit event which should return object

onclickSubmit : function(postdata) {

// do somthing hrere

return {anotherid: value1,....}

}

Best Regards

Tony

For professional UI suites for Java Script and PHP visit us at our commercial products site - guriddo.net - by the very same guys that created jqGrid.

14/04/2010
02:04

ddotsenko

Member

Members

Forum Posts: 15

Member Since:
08/03/2010

Offline

A DBA (or at least I) would have an issue with referring to data combination by multiple PKs.

A proper solution could be to inject unique ID for each data row and operate on that. In cases of working on "database views" or other results of joins, no one can rely all the time on a combination of IDs to be unique because various join conditions can duplicate the records like there is not tomorrow and filters may obscure that.

I suggest that server (SQL server, or web app code) keeps the mapping of columns-data-combination-to-unique-id in ORM (object relational mapper) or on DB. jqGrid (in my tests) supports GUIDs (UUIDs) as row IDs quite fine. Every time I feed a "view" each row has a GUID assigned to it by the server. When "edit" "delete" comes back to it, it knows exactly what data combination (row in a view) this refers to.

14/04/2010
16:39

rodk

Member

Members

Forum Posts: 12

Member Since:
19/03/2010

Offline

ddotsenko, I think the OP meant multi-column PKs, not multiple PKs as he stated (I could be wrong).

All RSS

Forum Timezone: Europe/Sofia

Most Users Ever Online: 715

Currently Online:
58 Guest(s)

Currently Browsing this Page:
1 Guest(s)