OData plugin for jqGrid

This plugin queries odata $metadata service and automatically generates jqgrid columns. It is the easiest way for implementing tables with basic CRUD operations, almost no code is required. In addition to simple column types this plugin supports odata ComplexTypes as well as odata NavigationProperties. Both data and metadata can be provided as json or atom+xml.
Atom+xml data can be received in 2 formats (see useXmlSerializer):

<ArrayOfClientModel>
  <ClientModel>
    ...
  </ClientModel>
</ArrayOfClientModel>

<feed>
  <entry>
    <link>...</link>
    <content>
       <properties>...</<properties>
    </content>
  </entry>
</feed>

When data is provided in json format the jqGrid parameters like records, page, total, userdata can be obtained via odata annotations. Annotation object name is defined in annotationName: "@jqgrid.GridModelAnnotate"

Function odataGenColModel

$("#grid").jqGrid({
  beforeInitGrid: function () {
    $("#grid").jqGrid('odataGenColModel', {...});
  }
});

This function generates jqgrid style columns by requesting odata $metadata. It is called by odataInit when gencolumns: true.

Arguments:

Name: default value	Description
metadatatype: 'xml'	ajax dataType, can be json, jsonp or xml(atom)
async: false	set ajax sync/async for $metadata request (when calling from odataInit only async=false is supported)
entityType: null	required field, odata entityType name
expandable: (link | json | subgrid*)	the expansion type for ComplexTypes and NavigationProperties, for details see "odata colModel parameters".
metadataurl: (odataurl || p.url) + '/$metadata'	set ajax url for $metadata request
successfunc: null	odataGenColModel callback to see when metadata request is over and jqGrid can be refreshed
parsecolfunc: null	event for converting parsed metadata data array in form of {name,type,nullable,iskey} to the jqGrid colModel array
parsemetadatafunc: null	event for converting unparsed metadata data (xml or json) to the jqGrid colModel array
errorfunc: null	error callback

Events:

Event name	Description
jqGridODataParseMetadata	the same as parsemetadatafunc
jqGridODataParseColumns	the same as parsecolfunc

Function odataInit

$("#grid").jqGrid({
  beforeInitGrid: function () {
    $("#grid").jqGrid('odataInit', {...});
  }
});

This is the main plugin entry point function. It should be called before the colModel is initialized. When columns are defined manually it can be called from events beforeInitGrid or onInitGrid. When columns are created automatically it can be called from event beforeInitGrid only.
Even when gencolumns: true we can still add column definitions manually (colModel: colModelDefinition). Thus columns generated by $metadata will be overwritten by manual definitions.

Arguments:

Name: default value	Description
gencolumns: false	automatically generate columns from odata $metadata (calls odataGenColModel)
odataurl: p.url	required field, main odata url
datatype: 'json'	ajax dataType, can be json, jsonp or xml(atom)
entityType: null	required field, odata entityType name
annotations: false	use odata annotations for getting jqgrid parameters: page,records,count,total
annotationName: "@jqgrid.GridModelAnnotate"	odata annotations class and namespace
useXmlSerializer: true	use XmlSerializer as default serializer for XML data
version	odata version (3/4), used to set $count=true or $inlinecount=allpages
errorfunc: null	error callback
metadatatype: datatype || 'xml'	when gencolumns=true, alternative ajax dataType for $metadata request
odataverbs: {	http verbs for odata and their corresponding actions in jqgrid (this feature requires thorough testing)

**inlineEditingAdd**: **'POST'**, | 
**inlineEditingEdit**: **'PATCH'**, |
**formEditingAdd**: **'POST'**, |
**formEditingEdit**: **'PUT'** |

} |

odata colModel parameters

odataunformat: function (searchField, searchString, searchOper) - works analogous to xmlmap/jsonmap,
                          for example the function body can be: { return searchString !== '-1' ? 'cltype/Id' : null; }
odataexpand: (link|json|subgrid*) - defines data expansion types for complex and navigation properties,
                          it works only with custom formatters specified in odata cmTemplates.
link - the link to the property is displayed
json - the property data is displayed in a json string form
subgrid - jquery subgrid is opened when clicking on a link inside column (this feature is not available yet).

odata column templates (cmTemplate)

Name	Description
odataComplexType	column template for odata Complex type.
odataNavigationProperty	column template for odata Navigation property.

Examples

For http://www.odata.org/odata-services

$("#grid").jqGrid({
    ...,
    beforeInitGrid: function () {
        $(this).jqGrid('odataInit', {
           annotations: false,
           metadatatype: 'xml',
           datatype: 'jsonp',
           version: 4,
           gencolumns: true,
           expandable: 'json',
           entityType: 'Product',
           odataurl: "http://services.odata.org/V4/OData/OData.svc/Products",
           metadataurl: 'http://services.odata.org/V4/OData/OData.svc/$metadata',
           errorfunc: function (jqXHR, parsedError) {
               jqXHR = jqXHR.xhr || jqXHR;
               parsedError = $('#errdialog').html() + parsedError;
               $('#errdialog').html(parsedError).dialog('open');
          });
    }
});

For https://github.com/mirik123/jqGridSamples

$("#grid").jqGrid({
    colModel: colModelDefinition,
    ...,
    // when columns are defined manually (gencolumns=false) the odataInit call
    // can be also put in onInitGrid event.
    beforeInitGrid: function () {
        $(this).jqGrid('odataInit', {
            version: 3,
            gencolumns: false,
            odataurl: 'http://localhost:56216/odata/ODClient'
        });
    }
});

$("#grid").jqGrid({
    colModel: colModelDefinition,
    ...,
    beforeInitGrid: function () {
        $(this).jqGrid('odataInit', {
            version: 4,
            datatype: 'json',
            annotations: true,
            gencolumns: true,
            entityType: 'ClientModel',
            odataurl: 'http://localhost:56216/odata/ODClient',
            metadataurl: 'http://localhost:56216/odata/$metadata'
        });
    }
});

$("#grid").jqGrid({
    colModel: colModelDefinition,
    ...,
    beforeInitGrid: function () {
        $(this).jqGrid('odataInit', {
            version: 4,
            datatype: 'xml',
            annotations: false,
            gencolumns: true,
            useXmlSerializer: false,
            entityType: 'ClientModel',
            odataurl: 'http://localhost:56216/odata/ODClient',
            metadataurl: 'http://localhost:56216/odata/$metadata'
        });
    }
});