More query condition delegations?

[oxf71]

I have studied the structure of the delegations table. I can use SQL queries to retrieve the data I need, such as querying all stakers under finality_provider_pk_hex. Add more query conditions at the API ?

query fields:

1. stake_tx.start_height
2. state
3. is_overflow
4. finality_provider_pk_hex

sort fields:

1. stake_tx.start_height

example find:

from pymongo import MongoClient

# Requires the PyMongo package.
# https://api.mongodb.com/python/current

client = MongoClient('mongodb://admin:admin@localhost:27017/?directConnection=true')
filter={
    'staking_tx.start_height': 857910
}

result = client['staking-api-service']['delegations'].find(
  filter=filter
)

from pymongo import MongoClient

# Requires the PyMongo package.
# https://api.mongodb.com/python/current

client = MongoClient('mongodb://admin:admin@localhost:27017/?directConnection=true')
filter={
    'finality_provider_pk_hex': '2f8ec74d558fe7a97d10be230bf1485db9be675228abfbf957ba050c714b679a', 
    'state': 'active', 
    'is_overflow': False
}
sort=list({
    'staking_tx.start_height': -1
}.items())

result = client['staking-api-service']['delegations'].find(
  filter=filter,
  sort=sort
)

from pymongo import MongoClient

# Requires the PyMongo package.
# https://api.mongodb.com/python/current

client = MongoClient('mongodb://admin:admin@localhost:27017/?directConnection=true')
filter={
    'finality_provider_pk_hex': '2f8ec74d558fe7a97d10be230bf1485db9be675228abfbf957ba050c714b679a', 
    'state': 'active', 
    'is_overflow': False,
'staking_tx.start_height': 857910
}

result = client['staking-api-service']['delegations'].find(
  filter=filter
)