Skip to content

ability to filter assets based on multiple nested data values in GetAllAssets #198

@bsushmith

Description

@bsushmith

Is your feature request related to a problem? Please describe.
In the v1beta1/assets api, we can filter based on query fields. Even though multiple query_fields can be supplied in the request, only one query value is taken.

For example -
with this API -

v1beta1/assets?types=table&q_fields=data.landscape.properties.entity,data.landscape.properties.attribute&q=mkns

It is possible to build a filter query like this ✅ -

WHERE type IN ('table') 
AND (data->'landscape'->'properties'->>'entity' ILIKE '%mkns%' 
OR data->'landscape'->'properties'->>'attribute' ILIKE '%mkns%')

But if we want to build a query like below, it is currently not possible. ❌

WHERE type IN ('table') 
AND (data->'landscape'->'properties'->>'entity'= '%abcd%' 
OR data->'landscape'->'properties'->>'entity' = '%mkns%')

Describe the solution you'd like
Make the Filter.Data field type to be map[string][]string, and in this block, handle it accordingly.

Describe alternatives you've considered
One of the alternative is to let the caller of this API, call it multiple times with different filters - but that would defeat the purpose of sorting, filtering and page-offsets in this API.

Additional context
Add any other context or screenshots about the feature request here.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions