SortingΒΆ
Sorting can be done over multiple fields in ascending or descending order.
Example showing how sorting can be dynamically created from a comma-separated string of fields.
query = pysnow.QueryBuilder()
fields = '-created_at,priority'.split(',')
query.field('priority').equals(['3', '4']).AND()
for (idx, field) in enumerate(fields):
if field[:1] == '-':
query.field(field[1:]).order_descending()
else:
query.field(field).order_ascending()
if idx != len(fields) - 1:
query.AND()
print(str(query)) # priorityIN3,4^ORDERBYDESCcreated_at^ORDERBYpriority