A field that is specified in record selection is getting selected.which i dont want to happen.i tried googling didnt find any possibilities.is there a way to do that?
Example
Record selection:
testDB.testTable.versionID = {?versionID}
SQL Query that is getting generated is as follows
select testDB.testTable.column1,testDB.testTable.versionID from testDB.testTable where testDB.testTable.versionID = {?versionID}
Here i dont want the testDB.testTable.versionID to get selected.since it spoils the distinct record selection.Is there a way to do that?
thanks
Mellison