SAP CAP Node JS - how to extract filter parameters?

[MinhTriLe]

Hi,

For example, I have a CAP service request: /helloworld/Users?$filter=companyCode eq '123456'.

I have implemented a custom handler for Users entity - READ. 

I've been looking at Events and Requests | CAPire (cloud.sap) but I couldn't find any way to extract filter values. In this case, it is companyCode 123456

What is the correct way to extract filter values?

Regards,

Minh

[smok1]

Hi @MinhTriLe, did you ended coding your own to extract?

[MinhTriLe]

Hi smok1, yeah i had to write my own code to extract.

[RahulL · Accepted solution]

Hi @MinhTriLe,
You can fetch the filter results from filterValue = req.query.SELECT.where || {}; and use JSON.stringify(filterValue) to get those in readable format we will get the filterValue in ref and values format like below:

[{"ref":["companyCode"]},"=",{"val":"123456"}]

If we use the below code the desired output will be achieved:

function extractFilters(filters) {

    let result = {};

    for (let i = 0; i < filters.length; i++) {

        if (filters[i].ref) {

            // Extract the reference

            let ref = filters[i].ref[0];

            // Check if the next element is '=' and the element after that has a value

            if (filters[i + 1] === "=" && filters[i + 2] && filters[i + 2].val) {

                // Store the reference and its value

                result[ref] = filters[i + 2].val;

                // Skip the next two elements

                i += 2;

            }

        }

    }

    return result;

}

// Extracting the filters and their values

let filterValues = extractFilters(filters1);

console.log("Extracted filter values:", filterValues);

You'll get the output as Extracted filter values: { companyCode: '123456' }, now you can use the value for the business logic.

[MinhTriLe · Accepted solution]

Hi RahulL, thanks for the hint. I'll try it.