Skip to main content

I am trying to query files based on their metadata template that contain an ampersand ex: “A/7-8&9/389-399” using node box sdk metadata query method but it does not return values. It matches other values that do not have ampersand. Is there a way to handle special characters when trying to query them.



I notice it works only if the query is setup as shown below



       var from = 'enterprise_someid.somekey',

ancestorFolderId = 'somefolderid',

options = {

query : "DocumentId ILIKE :arg1 OR bookAndPageNumber = :arg2",

query_params: {

arg1: '%' + params + '%',

arg2: params

},

limit: 10

};

type or paste code here



If i include the pattern matching operation it does not work



        var from = 'enterprise_someid.somekey',

ancestorFolderId = 'somefolderid',

options = {

query : "DocumentId ILIKE :arg1 OR bookAndPageNumber ILIKE :arg2",

query_params: {

arg1: '%' + params + '%',

arg2: '%' + params + '%'

},

limit: 10,

//fields:

};

Be the first to reply!

Reply