[Django]-How to add an model instance to a django queryset?

No. A queryset is a representation of a query – hence the name – not an arbitrary collection of instances.

If you really need an actual queryset rather than a list, you could try accumulating the IDs of the objects you need and then getting the objects via an __in query:

list_of_ids = []
list_of_ids.append(my_id)
...
queryset = MyModel.objects.filter(id__in=list_of_ids)

This isn’t very efficient, though.

This can be done using union. After doing this, the type of the result can be seen as <class 'django.db.models.query.QuerySet'>. So two querysets can be combined. Lets see an example.

query1 = User.objects.filter(is_active=True)

query2 = User.objects.filter(is_active=False)

combined_query = query1.union(query2)

print (type(combined_query))

The above program will print result as below, confirming it is a queryset

<class 'django.db.models.query.QuerySet'>

So basically Django executes the below query for union.

(SELECT "auth_user"."id", "auth_user"."password", "auth_user"."last_login", "auth_user"."is_superuser", "auth_user"."username", "auth_user"."first_name", "auth_user"."last_name", "auth_user"."email", "auth_user"."is_staff", "auth_user"."is_active", "auth_user"."date_joined" FROM "auth_user" WHERE "auth_user"."is_active" = True) 
UNION 
(SELECT "auth_user"."id", "auth_user"."password", "auth_user"."last_login", "auth_user"."is_superuser", "auth_user"."username", "auth_user"."first_name", "auth_user"."last_name", "auth_user"."email", "auth_user"."is_staff", "auth_user"."is_active", "auth_user"."date_joined" FROM "auth_user" WHERE "auth_user"."is_active" = False)

This also means that there will be error(django.db.utils.ProgrammingError: each UNION query must have the same number of columns) if union is tried with two different tables.

Queryset is not a list

So

to_list = queryset.values()

To combine queryset

from itertools import chain
result_queryset = list(chain(queryset1, queryset2))

or

querysets = [queryset1, queryset2]
result_queryset = list(chain(*querysets))

I did now and I got it. Use filter to take multiple ids. Use get only takes a single element. For example, if you have a queryset called Product with many products already registered, that is, with several id’s. Do:

a= list(Product.objects.filter(id=7)) 
b= list(Product.objects.filter(id__in=['3','5'])) 
a.append(b) 
print(a)