Hi Isomorphic,
please see this modified sample (v12.1p_2023-01-05).
As you can see here after filtering, the GUI looks like it would filter using startsWith, but in reality it uses contains. The request also does not use advancedCriteria, but

Either adding filterOperator to the ListGridField or setting alwaysShowOperatorIcon: true on the ListGrid fixes the issue, the request is then:
Best regards
Blama
countryDS:
databound.js (broken like this with filterOperator commented out):
please see this modified sample (v12.1p_2023-01-05).
As you can see here after filtering, the GUI looks like it would filter using startsWith, but in reality it uses contains. The request also does not use advancedCriteria, but
Code:
data:{ countryName:"d" },
Either adding filterOperator to the ListGridField or setting alwaysShowOperatorIcon: true on the ListGrid fixes the issue, the request is then:
Code:
data:{ operator:"and", criteria:[ { fieldName:"countryName", operator:"startsWith", value:"d" } ] },
Blama
countryDS:
Code:
isc.DataSource.create({ ID: "countryDS", fields:[ {name:"countryCode", title:"Code"}, {name:"countryName", title:"Country", validOperators:["startsWith", "iStartsWith", "endsWith", "iEndsWith", "iregexp", "regexp"]}, {name:"capital", title:"Capital"} ], clientOnly: true, testData: countryData })
Code:
isc.ListGrid.create({ ID: "countryList", width: 500, height: 224, alternateRecordStyles: true, showAllRecords: true, dataSource: countryDS, autoFetchData: true, showFilterEditor: true, fields: [ { name: "countryCode" }, { name: "countryName"}, //, filterOperator: "startsWith" }, { name: "capital" } ], dataProperties: { useClientFiltering: false } })
Comment