Azure Open AI Studio not filtering any data when the cognitive search index has a mixture of string and double values.

Question

Azure Open AI Studio not filtering any data when the cognitive search index has a mixture of string and double values. When it is just string then azure open ai is able to query but it gives all useless data and does not filter appropriately as it perform’s string comparison for numeric values.

 

Sample of the issue when cognitive search index has both string and double fields that is attached to azure open ai studio.

Cognitive search field mapping.

Cognitive search field mapping.

Sample filter check.

Azure Open AI studio setup to bring in cognitive search‘s index

Mapping only searching fields (string)… as other fields will give an error in openai if selected.

In this case chat will not fund anything. If the index was all string then it would work but would give all incorrect results as the field’s data comparison is all text based then.

Answer 1

@Anonymous Apologies for delayed response. I have confirmation that the service only support string values in the index with Azure OpenAI. Thanks!!

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.