Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Support filter expressions for numbers #3688

Open
ndr-brt opened this issue Dec 5, 2023 · 4 comments
Open

Support filter expressions for numbers #3688

ndr-brt opened this issue Dec 5, 2023 · 4 comments
Labels
enhancement New feature or request
Milestone

Comments

@ndr-brt
Copy link
Member

ndr-brt commented Dec 5, 2023

Feature Request

Currently if we try to filter an asset by a numeric field with postgresql database, e.g.:

{
    "@context": {
        "odrl": "http://www.w3.org/ns/odrl/2/"
    },
    "@type": "QuerySpec",
    "offset": 0,
    "limit": 10,
    "filterExpression": [
        {
            "operandLeft": "https://w3id.org/edc/v0.0.1/ns/month",
            "operator": "=",
            "operandRight": 12
        }
    ]
}

we'll receive this error:

SEVERE 2023-12-05T10:59:28.1771974 JerseyExtension: Unexpected exception caught
org.eclipse.edc.spi.persistence.EdcPersistenceException: org.postgresql.util.PSQLException: ERROR: operator does not exist: text = double precision
  Hint: No operator matches the given name and argument types. You might need to add explicit type casts.

It would be nice to have numbers supported as it was done for boolean.

Which Areas Would Be Affected?

postgres statement building

Why Is the Feature Desired?

Are there any requirements?

Solution Proposal

If possible, provide a (brief!) solution proposal.

@ndr-brt ndr-brt added feature_request New feature request, awaiting triage triage all new issues awaiting classification labels Dec 5, 2023
@ndr-brt ndr-brt added enhancement New feature or request and removed feature_request New feature request, awaiting triage triage all new issues awaiting classification labels Dec 13, 2023
Copy link

This issue is stale because it has been open for 14 days with no activity.

@github-actions github-actions bot added the stale Open for x days with no activity label Dec 28, 2023
Copy link

github-actions bot commented Jan 4, 2024

This issue was closed because it has been inactive for 7 days since being marked as stale.

@github-actions github-actions bot closed this as not planned Won't fix, can't repro, duplicate, stale Jan 4, 2024
Copy link

github-actions bot commented Jan 4, 2024

This issue was closed because it has been inactive for 7 days since being marked as stale.

@ndr-brt ndr-brt removed the stale Open for x days with no activity label Jan 8, 2024
@ndr-brt ndr-brt reopened this Jan 8, 2024
Copy link

This issue is stale because it has been open for 14 days with no activity.

@github-actions github-actions bot added the stale Open for x days with no activity label Jan 23, 2024
@ndr-brt ndr-brt removed the stale Open for x days with no activity label Jan 23, 2024
@ndr-brt ndr-brt added this to the Backlog milestone Jan 23, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request
Projects
None yet
Development

No branches or pull requests

1 participant