'Getting error when passing more than 1000 values in Django IN filter

I have list which contains more than 1000 entires. I have to check out of those 1000 entries how man exist in my table so I am using Django IN filter but it is giving me error

Error: ('07002', u'[07002] [Microsoft][ODBC Driver 17 for SQL Server]COUNT field incorrect or syntax error (0) (SQLExecDirectW)')

and when I reduce the list of values to around 400 it works.

Can anyone suggest me a better way to approach this. Thank You

pythonsqldjangodjango-rest-framework


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions