Azure-docs: Performing search.in on an Int32 field

[ADringer]

Is it possible to do search.in on a numeric field, or number only? I have a productId field that is defined as Edm.Int32 and would like to filter on this e.g. `search.in(productId, '1,2,5', ','). However this comes up with an error which I believe is because it's an int, not a string,

---

Document Details

⚠ Do not edit this section. It is required for docs.microsoft.com ➟ GitHub issue linking.

• ID: bc76a7a5-efde-2381-e9f0-24c0a054e56a
• Version Independent ID: 4ea33585-77a7-f994-f7f2-29e3912fb0da
• Content: OData search.in function reference - Azure Search
• Content Source: articles/search/search-query-odata-search-in-function.md
• Service: search
• GitHub Login: @brjohnstmsft
• Microsoft Alias: brjohnst

[AjayKumar-MSFT]

@ADringer, Thanks for the question! We are taking a look into this and will get back to you soon.

[brjohnstmsft]

@ADringer The search.in function supports string fields only.

[AjayKumar-MSFT]

@ADringer, As Bruce mentioned 'The search.in function supports string fields only'. Kindly let us know if this helps and this issue is good to be closed. Thanks again for your feedback!

[HeidiSteen]

@ADringer here is a link to the $filter reference doc, if that helps at all: https://docs.microsoft.com/en-us/azure/search/search-query-odata-filter#examples.

I can also recommend this forum if you want engineering or community feedback on your approach: https://stackoverflow.com/questions/tagged/azure-search

[HeidiSteen]

please-close

[drhumlen]

This is still unsolved as far as I can see? I can't a good solution to this anywhere online. Do you have a recommended solution? If not, imo the issue should still be open.

The only "solution" I can think of is to add another field to my document with a stringified version of the int alongside the actually int id. Like so:

{id: 123, name: "James", idAsString: "123"}

Then I would be able to use search.in on it. However, that is quite a hack imo. It seems strange that there is no way to filter on a list of (int) ids?

[HeidiSteen]

Hi @drhumlen, you can filter on numeric data: https://docs.microsoft.com/en-us/azure/search/search-filters#numeric-filter-fundamentals

You just can't use search.in on a numeric field. Does this help?