Start a new topic

Custom Query as filter in Named Query or API Filter

Hi,


We are trying to find all the source records that was submitted for processing, but due to job failure or any other issue not persisted in MD and GD tables and with B_ERROR_STATUS = NULL in SD table,  so that these can be reprocessed again either by stewards  or an external application.


We are looking for options to retrieve these data in API as well using named query or normal API call with the custom query as filter., can anyone help me understand if the below custom query can be directly applied as filter in API or named query.


Would really appreciate your inputs and any suggestions that can help achieving the use case.



Thanks,

Vinoth

1 Comment

Hello Vinoth,


It sounds to me like getting the list of records that belongs to a SUSPENDED or ERROR batch would answer the requirement.


And to do so, you can do it either via named query, with something like this:

  • Filter: LoadStatus in ('ERROR','SUSPENDED')

  • Endpoint: Execute named query xxx for view SD


Or directly via the native endpoint:

  • Endpoint: Query xxx SD records
  • Filter: $f=LoadStatus in ('ERROR','SUSPENDED')


Hope that helps.

Login to post a comment