[Answer]-How to filter based on either one of the columns

You can use django.db.models.Q which can be combine using | (OR).

from django.db.models import Q

...

Table.objects.filter(Q(col1=myValue) | Q(col2=myValue))