tony on sopt (advanced search) not null option

Sun, 30 May 2010 13:39:09 +0300

Hello,

Thanks for this.

Currently the way that this is organized is not good. There is a work on this, but the main purpose not to implement it is that we need to save the code of all existing users.

Best Regards

Tony

betty on sopt (advanced search) not null option

Tue, 25 May 2010 23:28:45 +0300

There are already 14 options defined in sopt, and each of the option can be mapped to a sql operator. But it looks like none of them can be mapped "is not null" easily. So I got a requirement of adding "not null" (has data) option in my application.

I have these mapping coded in my source. And sql statement will be generated automatically based on a selected sopt option. Any suggestion about adding the "not null" option? My idea is that I have to modify the jqgrid source file to add one more option to define the "not null" option. Any other ideas?

   protected static final String[] sopt   = {"eq","ne","lt", "le", "gt","ge", "bw",
      "bn",
      "in",
      "ni",
      "ew",
      "en",
      "cn",
      "nc"};

   protected static final String[] sqlopt = {"=", "!=", "<", "<=", ">", ">=", " LIKE 'val%' ",
      " NOT LIKE 'val%' ",
      " IN (val) ",
      " NOT IN (val) ",
      " LIKE '%val' ",
      " NOT LIKE '%val' ",
      " LIKE '%val%' ",
      " NOT LIKE '%val%' "};

Best regard.

jQuery Grid Plugin - jqGrid - Topic: sopt (advanced search) not null option

tony on sopt (advanced search) not null option

betty on sopt (advanced search) not null option