SmartClient 11 Pro filterData Criteria Isnull operator

[mabboud]

i am trying to accomplish the following Query

SELECT * 
FROM 
TableA 
LEFT JOIN TableB ON tableA.pk = tableB.pk 
WHERE tableB.pK is null

how do you configure IS NULL where clause in the ListGrid.filterData criteria or in the Datasource XML file field configuration

[Isomorphic]

Please see the documentation for AdvancedCriteria.