does this support jsonb search ?

[fatkhanfauzi]

does this support jsonb search ?

[kibertoad]

Let me try writing a test for that; I think not yet, but it could.

[kibertoad]

Can you detail your use-case? That would make it easier to design a solution.

[fatkhanfauzi]

thanks for your quick reply.

here is my use case:
i have a column named status with this value
{ "history": [ "initial", "submitted" ], "currentState": "submitted" }

then i want to search the data by status -> currentState.
thanks

[kibertoad]

@fatkhanfauzi What kind of GET query would you like to use for that?

[fatkhanfauzi]

@kibertoad something like status[currentState]:eq or status[currentState]:like
i think that's the best one since we can't use dot (.) as it will be indicated as relationship.
thought ?

[afm-sayem]

You can write your own filter using registerFilter. Here's the documentation: https://github.com/Vincit/objection-find/blob/master/API.md#registerfilterstring-function---findquerybuilder

Here is an example of a custom full-text-search(search) filter: https://github.com/afm-sayem/ground-zero/blob/master/components/filters/text-search.js

[fatkhanfauzi]

@afm-sayem yep i know we can do that, thanks for your suggestion.
but could be great if this package supports the jsonb search.
as i mentioned above.

something like status[currentState]:eq or status[currentState]:like
i think that's the best one since we can't use dot (.) as it will be indicated as relationship.

[fatkhanfauzi]

@afm-sayem @kibertoad or probably using status->>currentState same as what i've done at the moment in my custom filter.

module.exports = function(propertyRef, value, modelClass) {
  const column = propertyRef.propertyName.split('->>')[0];
  const jsonbKey = propertyRef.propertyName.split('->>')[1];

  return {
    method: 'whereRaw',
    args: [`${column} ->> '${jsonbKey}' = ?`, value.toLowerCase()],
  };
};

[MoJo2600]

Query for jsonb fields seems to be possible with @fatkhanfauzi filter. But is there a way to have the result ordered by an jsonb property?

[fatkhanfauzi]

Query for jsonb fields seems to be possible with @fatkhanfauzi filter. But is there a way to have the result ordered by an jsonb property?

iirc, when I was working on the project that uses this package.
i added a monkey patch to build a necessary complex query based on the given params before the query execution.

however, apologize that I'm not on that project anymore.
but this could be a clue, good luck !!