Unknown Column Name "$Criteria.COLUMN_NAME" in datasource

Smart GWT Technical Q&A
1

Hi Isomorphic,

I am using “$criteria.COLUMN_NAME” in whereclause of the DataSource.
Below is the code snippet.

<binding operationType="fetch">
            <selectClause>
                $defaultSelectClause,(select GAMEPLAN_ID from venues where id = positionView.venue_id) AS gameplan_id,
                (select positionView.id) AS temp_id
            </selectClause>
            <tableClause>$defaultTableClause</tableClause>
            <whereClause>
                ($defaultWhereClause)  
            AND positionView.venue_id in (select id from venues where gameplan_id = positionView.gameplan_id) 
            AND positionView.id != $criteria.temp_id
            AND (positionView.linked_positions != $criteria.set_id OR linked_positions is null)
            </whereClause> 
        </binding>

I attached this datasource with one of my listGrid, and the data in a grid loads well.
But, When i do a Filtering using the same ListGrid, I got an Error Popup like:
Unknown Column Name “$Criteria.temp_id”.

So Am I doing anything wrong ? if Yes, then how could I make these Filters work ?

2

You should always post the complete log of the server request whenever posting any server-based issue.

The problem is likely that AdvancedCriteria is being submitted. In the latest builds, we’ve made it easy to access criteria values in AdvancedCriteria even for a complex criteria object - use $advancedCriteria.fieldName.