Django filter charfield by greater than X principle
Possible duplicate, but no answers so far got any close to the solution.
Imagine you have a charfield like this: 1.1.1.1 arriving in the request.
I.e. basic semantic version.
You need to filter all the objects in the queryset, where their version charfield is greater than this.
For example we have such records in the DB:
0.0.0.0
0.0.0.1
1.0.0.0
1.1.1.1
1.1.1.2
2.2.2.2
And in the example provided I gave the version number as 1.1.1.1.
So filtering by "greater than this" principle we will get only [1.1.1.2, 2.2.2.2].
Right now I'm filtering just by using regex. But how to do this using django ORM?