I Got Error "unsupported Lookup 'icontains ' For Charfield Or Join On The Field Not Permitted."

I'm trying to make a dynamic query to get data, like follwing: query = request.GET.get('q') kwargs = { '{0}__{1} '.format('first_name','icontains'):query} if query: players_lis

Solution 1:

You have a space before the close quote; delete it.

Solution 2:

I had this very error. It turns out I had the "icontains" lookup twice, once explicit and a second one that I appended to every field. Removing the second lookup fixed the problem.