Skip to main content

jqgrid grails : editing rows with drop-downs/combo boxes

Jqgrid is a jquery plugin that allows formatting data as table and has number of options - paging, sorting, filtering, inline editing etc. There are few good tutorials explaining the process to integrated jqgrid in your grails application.
http://pramodnepal.com.np/?p=119
http://www.grails.org/plugin/jqgrid

Following is a typical jquery script that can be used in a grails application. The property 'editable=true' make any of the field in grid as editable.






Often it is required to provide a drop down list for certain fields. To make any field as a combobox or a drop-down list make type as 'select' and provide 'editoptions'. eg: editoptions:{value:{1:'One',2:'Two'}}

The 'editoptions' list has to be hard coded or generated at the time of rendering. To dynamically generate the list using Ajax, we need to use the dataUrl as given below.


editoptions:{dataUrl:'${createLink(controller:"expenseType",action:"listAsSelect")}'}}


Controller action:


def listAsSelect={

def lst = ExpenseType.findAllByExpenseFlag('Y')

println (lst.size())


StringBuffer buf = new StringBuffer("")

render buf.toString()

}


Comments

  1. Thank you very match. you save me

    ReplyDelete
  2. Thanks a lot.You help me.Be happy because your post very helpful.Thanks..............

    ReplyDelete
  3. Very Nice, you saved my day

    ReplyDelete

Post a Comment

Popular posts from this blog

Grails - cross-field Date validation

Often we run into domain classes with date fields. If the domain class has two datefields, startDate and endDate, and the rule for a valid combination is "endDate to be greater than startDate", how do we handle? I listed below two of the options, either using domain level constraints or using the domain classes. Option 1: Using domain constraints. Let us take a sample Grails Domain class class Student{ String name String school Date startDate Date endDate } Add the following constraints to enforce validation rules where name, school, startDate cannot be blank and endDate if present should be greater than startDate.

Grails - Querying complex associations

Criteria class allows performing complex searches on grails objects. There are number of shortcut methods for performing queries but these methods have limitations in terms of number of conditions used in "where clauses". Traditional sql "joins" are not possible as shown in some of the Grails "Finder" methods shown below. Sample 1: def list = AccountTransaction.findAllByCompanyCodeAndVoucherDateBetween(branch, fromDate, toDate, params) Sample 2: def list = AccountTransaction.findAllByCompanyCodeAndVoucherDateGreaterThanEquals(branch, fromDate, params) Sample 3: def list = AccountTransaction.findAllByCompanyCodeAndTransGroup(branch, group, params) "params" contains attributes related to sorting, paging etc. It is very easy to use finder methods but when you want to filter objects by more conditions we need to look for alternatives. For understanding the relationships used in this sample, I listed the grails domain classes. class TransactionTyp

Implementing advanced sort in Grails

The "list" pages generated by inbuilt scaffolding/template features of grails have pagination and sorting features. However, if the domain object displayed in the list is a nested object having another domain object as a property, you may notice that sort is not enabled for that field. Boiler plate code for the header of the list is shown below. As you would have noticed few columns have sortable columns automatically generated by Grails command, generate-all or generate-views. The properties 'partyAccount' and 'bankAccount' in this sample are domain classes nested in the domain class 'partyTransaction'. We could convert them to sortable columns by using the tag g:sortableColum