🍉 Meet Flexmonster Pivot Table & Charts 2.9.Check out all hot features!
Get Free Trial

Apply filter query to calculated data from Flexmonster Data Server

Answered
Vladislav Kurochkin asked on May 19, 2021

Hi, team!

I have started flexmonster data server and connected my flexmonster client app to it.  After that I am trying to apply the following filter query (I want to get top 10 rows):

"query": {
"top": 10
}

and it does not work. I still see all the rows.  If i apply query like this:

"query": {
"greater": 120
}

it works as expected.

So for unknown reason ‘greater’ works, but ‘top’ does not for the data that is fetched from flexmonster data server.

But both of this filter queries work if i apply them to data that is fetched from JSON, like here:

https://jsfiddle.net/ch71tw3f/

On screenshots you can see my slice object and the result i get in both cases: with ‘greater’ query and with ‘top’ query

1 answer

Public
Vera Didenko Vera Didenko Flexmonster May 21, 2021

Hello, Vladislav,
 
Thank you for writing to us.

For custom data source API (Flexmonster Data Server included), value filters are currently disabled for calculated values (this can be seen in the UI filter pop-up).
Please see the following Support Forum thread for details.
 
You are welcome to reach out to us if additional questions arise.
 
Kind regards,
Vera

Please login or Register to Submit Answer