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

does the setFilter api not support ocsv file type?

Evan asked on June 11, 2019

Does setFilter method support the oscv file type?
Can I only use runQuery method to filter data? runQuery is running normally for me.  setFilter is a more flexible way. So could I get a definite answer. Look forward to your reply.
        “members”: [“date.[2019-02-25]”, “date.[2019-02-26]”, “date.[2019-02-28]”]

2 answers

Dmytro Zvazhii Dmytro Zvazhii Flexmonster June 11, 2019

Hello Evan,
Thank you for your questions.
Please find our answers below:

  1. The setFilter() API call is supported for the OCSV data source. You can always refer to our docs for more information: https://www.flexmonster.com/api/setfilter/. Also, please make sure that you are defining the uniquenames of the members correctly. They could differ depending on the date type. Please find more information about available date types here: https://www.flexmonster.com/doc/data-types-in-csv/. For example, the suggested definition could work for the "date string" data type. At the same time it will not work for the "date" data type. The easiest way to find out the correct template for your case is defining the filter with the UI tools and then pressing the "Save" button to save the configs to JSON. You will find the correct definition of the column uniquename and member uniquenames there.
  2. Filtering through runQuery() API call is not supported. Please find more information in our docs: https://www.flexmonster.com/api/runquery/.

Please let us know in case of any other question.

Evan June 11, 2019

Yes, I knew this. There are some issues about setFilter method in version 2.7.4, bt they were disappeared after i update to 2.7.7.
These are not mentioned in release note.
thanks ur replay!

Please login or Register to Submit Answer