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