Menu

#974 SAIL filtered grid - wire up filter logic

Foraker
open
3
2016-04-22
2016-04-22
drrwebber
No

Currently code generated does not action filters - so adding this Filter: logic with fix that:

           selection: a!querySelection(columns: {
                        a!queryColumn(field: "id"),
                        a!queryColumn(field: "contractid"),
                        a!queryColumn(field: "documentid"),
                        a!queryColumn(field: "notes"),
                        a!queryColumn(field: "processid"),
                        a!queryColumn(field: "initiatedDate"),
                        a!queryColumn(field: "initiatedBy"),
                        a!queryColumn(field: "approvers"),
            }),
            filter: {
              if(isnull(local!filtercontractid),
                  if(isnull(local!filterinitiatedBy),
                    if(isnull(local!filterinitiatedDate),"",
                     a!queryFilter(field: "initiatedDate", operator: "<=", value: local!filterInitiatedDate)),
                     a!queryFilter(field: "initiatedBy", operator: "=", value: local!filterInitiatedBy)),
                     a!queryFilter(field: "contractid", operator: "=", value: local!filtercontractid))
              },
            pagingInfo: local!gridSelection.pagingInfo

Discussion


Log in to post a comment.