Querying transferprocess with certain state not possible #3319
Labels
Comments
tuncaytunc-zf
added
bug_report
|
this is not a bug. the Sticking with the example, the correct expression would be: "filterExpression": [
{
"operandLeft": "state",
"operandRight": 800,
"operator": "="
}
],Just tried this our successfully in a test. Can you try again with that? Please check out the codes in |
|
If I use the suggested request, I'm getting a error message |
|
can you post the stacktrace? |
|
Unfortunately it is partially in German thefore I didn't post the whole stacktrace :-) |
|
No i meant to ask if there is a stacktrace with the |
|
For that I don't get a single line of logs, even I'm running it in debug log level :-) |
|
I think I found the culprit: //JsonObjectToCriterionTransformer.java#l48
builder.operandRight(transformString(operandRight, context));Technically there are two ways to solve this:
The latter seems to be the better approach. |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Bug Report
Describe the Bug
Queriying all transfer process in certain state by using 'filterExpression' is not possible.
Expected Behavior
It should be possible to query all transferprocesses with certain sate.
Observed Behavior
If you try to query all transferprocess in certain by using 'filterExpression' fails with a HTTP 500 error.
Steps to Reproduce
Steps to reproduce the behavior:
Use following json to query all
transferprocesseswith statusCOMPLETED{ "@context": { "edc": "https://w3id.org/edc/v0.0.1/ns/" }, "@type": "QuerySpec", "filterExpression": [ { "operandLeft": "state", "operandRight": "COMPLETED", "operator": "=" } ], "limit": 100, "offset": 0 }Context Information
Detailed Description
Error message from Controlplane::
The field
statein database is defined as int but the API is using string and produces a SQL query with...WHERE state = 'COMPLETED'which fails because the database expects a int value forstate.Possible Implementation
The API should convert the string states into corresponding int values when querying the database.
The text was updated successfully, but these errors were encountered: