Skip to Content
author's profile photo Former Member
Former Member

SetFilter limitation and how it works

Hello Experts,

I am using setFilter function in my design studio 1.5 application on HANA as backend. If we want filter the data set using a key, which is not there in the data set, it returns all data, considering the key value as "ALL_Members". By I want no data to be returned for that scenario.

Seem, like this is how setFiler functionality works, and we do not have any option there.

One alternative could be using setVariableValue, but wanted to check what would be the performance impact.

In other wards, if I do a setfilter does it go back to the backend and execute the query there like setVariableValue or it only does the filtering at design studio end? If setFilter goes back to the backend, I do not see think there would be any difference on performance on using setVariableVal instead of setFilter.

Note -- I am not using any merged prompt for my application, so using setVariableValue not going to initiate execution of any other backend Model.

Thanks,

Supriya Das

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jan 14, 2016 at 11:01 AM

    Hello Supriya,

    In other wards, if I do a setfilter does it go back to the backend and execute the query there like setVariableValue or it only does the filtering at design studio end?

    No it doesn't execute the query again. It uses the result dataset which is in runtime.

    Regards,

    Bogdan

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 14, 2016 at 09:57 AM
    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.