Is your feature request related to a problem? Please describe.
Currently, each time I need to extract/tag new operations for ops_learning, I have to read the full dataset (~19.5K rows and growing). This process is slow, inefficient, and risks performance issues or system instability over time.
Describe the solution you'd like
Introduce a dedicated API endpoint that returns only:
This would allow faster queries and reduce the need to process the full dataset when identifying new operations.
Describe alternatives you've considered
Using existing API query parameters. However, these appear to operate at the row level rather than the column level, so they don’t solve the performance issue (happy to be corrected if this is not accurate).
Additional context
This is a recurring need for ops_learning workflows, and the dataset size is increasing steadily, which will continue to amplify the issue.
Where does the data come from and how is it maintained?
The data comes from the ops_learning dataset, which is maintained internally and updated as operations are processed and validated.
Should there be any restrictions around viewing or updating information related to this feature
The ops_learning dataset is:
Public when is_validated = True
Restricted to super admin users when is_validated = False
For this endpoint (only exposing appeal_code and is_validated), it could be made fully public, as it does not expose sensitive details.
Links to documentation
N/A
@szabozoltan69
Is your feature request related to a problem? Please describe.
Currently, each time I need to extract/tag new operations for ops_learning, I have to read the full dataset (~19.5K rows and growing). This process is slow, inefficient, and risks performance issues or system instability over time.
Describe the solution you'd like
Introduce a dedicated API endpoint that returns only:
This would allow faster queries and reduce the need to process the full dataset when identifying new operations.
Describe alternatives you've considered
Using existing API query parameters. However, these appear to operate at the row level rather than the column level, so they don’t solve the performance issue (happy to be corrected if this is not accurate).
Additional context
This is a recurring need for ops_learning workflows, and the dataset size is increasing steadily, which will continue to amplify the issue.
Where does the data come from and how is it maintained?
The data comes from the ops_learning dataset, which is maintained internally and updated as operations are processed and validated.
Should there be any restrictions around viewing or updating information related to this feature
The ops_learning dataset is:
For this endpoint (only exposing appeal_code and is_validated), it could be made fully public, as it does not expose sensitive details.
Links to documentation
N/A
@szabozoltan69