Announcement

Collapse
No announcement yet.
X
  • Filter
  • Time
Clear All
new posts

  • Isomorphic
    replied
    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.

    Leave a comment:


  • kshamir
    replied
    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%'

    Leave a comment:


  • Isomorphic
    replied
    See DataSource.getAdvancedCriteriaDescription().

    Leave a comment:


  • kshamir
    started a topic AdvancedCriteria to SQL

    AdvancedCriteria to SQL

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