Returning API data with sort order but without filters


#1

I’d like to query a table via the Javascript API with the following requirements:

  1. The query uses a “View” for sort order
  2. The query uses a custom filter that overrides any filters existing on that view.

Is it possible to accomplish this? Right now, it seems that filters in Airtable always affect the API results.


#2

No it can’t override the view filters. It would just filter within the view. But you could easily create a new view that doesn’t have your current views filter and query against that.


#3

If I create a new view, then I don’t get the sort order from the original view, right?


#4

you can set up the new view to use same sort as original, right?

You can also provide a sort in the api call to sort any way you want to.


#5

Our view sort is not formula-based, it’s based on manual reordering. Thus, even if the view is duplicated, it will not stay in sync with the “master” view.


#6

Also, the filtering is additive. So, although I can provide a filter to the API, it doesn’t replace the existing filter, hence my original question.


#7

why not add an ‘Order’ field that you modify manually with a number that corresponds with your manual sorting so that you can sort it easily in another view or via api sort functionality


#8

If we implement numbered ordering, we’d lose the nice drag-and-drop functionality which makes our workflow so fast.