I would like to get a set of data between two dates which is working fine if I’m using the Standard filter the Workflow has but since we need to select few fields, so we’re using $filter this is not possible to do using the filter in the image below.
Standard filter BPA
So, tested in Postman we applied the same filter in the BPA but is not working as expected. The result in the image below should have two records.
Filter (the same in Postman) is not working in BPA
Can someone please advise?
Thank you
Page 1 / 1
$filter is not supported in workflow in the way you tried.
for selecting specific records, you can directly use the standard filter with equal condition or use parameter option to filter the records
Moreover, we would like to use the filter standard option but we encountered the ERROR ORA-00904, please see screenshot below. PS. This is a custom API, but the same happens with an IFS standard API, please see screenshots below
Custom API
The same happens with another IFS API, please see the screenshots below, how can we solve this error? Can you please advise?
With NO $select → ERROR
With $select → OK
Thank you,
Eleazar
@Eleazar_AyaviriCarrillo
Im not familiar with this particular message, would you be able to do the same request directly using Postman and see if the response is the same?
Hi @kamnlk ,
Doing it with Postman I have the same type of error (the attribute changed btw).
BPA
Postman
Hi @Eleazar_AyaviriCarrillo ,
I think there might be an error in the projection, as the same error occurs in both Postman and the workflow: DATE_REQUIRED_PART_OFS is an invalid identifier. Since you have tried this before, I suggest using $select to fetch only the necessary parameters instead of selecting all parameters to proceed with your workflow. I believe this issue should be resolvable, but I am not entirely sure if this is exactly what you need.
@Eleazar_AyaviriCarrillo does all your entity and it dependicies are published ?
hi @Eleazar_AyaviriCarrillo
Looks like there is something wrong with the projection. If possible, please log a support case for this to analyze further