We have updated Flexmonster Software License Agreement, effective as of September 30, 2024. Learn more about what’s changed.

How to filter on an whole Pivot table a user´s typed string

Answered
Leonel Braginski asked on November 9, 2020

Hi, I have a flat table where I´m needing that the user could be able to write on a text input outside the table any data to use as filter to query in all the columns and rows of the table and make only that line displayable.
Is there any way to do a runQuery() where the filters make only displayable the line where is a value equal to the typed?
Thank you for your time!

3 answers

Public
Vera Didenko Vera Didenko Flexmonster November 10, 2020

Hello, Leonel,
 
Thank you for writing to us. 
 
We would like to mention that recently our team has added a live member search feature that can be enabled with the liveFiltering: true option.
We have prepared a JSFiddle example for illustration: https://jsfiddle.net/flexmonster/20es6ax4/
 
Please let us know if this would work fine for your case.
Looking forward to your reply.
 
Kind regards, 
Vera

Public
Leonel Braginski November 10, 2020

Hello Vera, thank you for your support.
It´s good to know about the function of liveFiltering but what I need is an input outside the pivot table where anybody could write something to search on the whole table, so it shows the user the complete line of that value. It´s not necessary to be live
I attached a image of the pivot table

Attachments:
example.PNG

Public
Vera Didenko Vera Didenko Flexmonster November 11, 2020

Hello, Leonel,
 
Thank you for your response. 
 
For such cases, we kindly suggest the following approach: 

  1. When the search string is entered, filter the data based on the input outside of Flexmonster (for example, on your backend).
    Could you please specify your data source type?
  2. Then update Flexmonster with the filtered data.
    The data in Flexmonster can be updated with the updateData() API call

We hope this helps. If further questions arise, please feel free to reach out.
 
Kind regards, 
Vera

Please login or Register to Submit Answer