Hello,

We are facing some problem with Elastic Search. The RD is generating SQL query instead of non-sql query. We are not facing this in our dev environment, but after deployment in QA facing this issue.

Please note the following:

• We have a dedicated data table on which the RD is created
• Custom search properties and dedicated index created
• all the search and stream nodes are on line
• Dedicated index showing available
• The following DSS are set true
  • indexing/distributed/enabled
  • indexing/distributed/index_enabled
  • indexing/distributed/search_enabled
  • indexing/distributed/search/fuzzy/enabled
  • indexing/useDataInstances
• In Custom Search properties - Enable search results for all properties is checked

Now, while debugging what we have found - when we start adding specific property in custom search properties instance, the RD is generating the Elastic query for some of the columns (while you put that in where clause), but for some of the field even though you add that in custom search properties instance, it is generating sql query.

Please note  - this behaviour with same configuration we have not encountered in dev environment.

Any insight on this issue will be really helpful.

Thanks