AdvancedCriteria to SQL

[kshamir]

Hi, is there a Framework method to convert AdvancedCriteria to SQL on the client-side?

[Isomorphic]

See DataSource.getAdvancedCriteriaDescription().

[kshamir]

According to your documentation, DataSource.getAdvancedCriteriaDescription() 'returns a human-readable string describing the clauses in this advanced criteria or criterion'.

I've checked this method with this show-case: https://www.smartclient.com/smartcli...OperatorFilter
and I got these results:
1. input: DataSource.getAdvancedCriteriaDescription(countryList.initialCriteria.criteria[0],countryList.dataSource)
output: "Code contains SW"
2. input: DataSource.getAdvancedCriteriaDescription(countryList.initialCriteria.criteria[1],countryList.dataSource)
output: "Country does not contain i"

This is not what I'm looking for.
I need to convert criteria values to SQL syntax e.g: Code like '%SW%'

[Isomorphic]

There is a server side method to do that, but no client side method. There is a little point in generating SQL on the client since it would be insecure to send it to the server.