1 Reply Latest reply: Oct 10, 2011 10:40 PM by Kiran Rokkam RSS

    Show Search Criteria used on Expression in Straight Table.

    Kelly Donahue
      Hello!   I have a straight table with a few expressions, one of which is:
      =
      sum({<invoice_status = {'Current'}>} amount_open)
      This column is called "Current AR", and I have marked it as "searchable" on the presentation tab of the chart properties.  I would like to be able to show the user what they searched in that field.  I'm flexible about where I will show this- chart title, column name, or in a separate text box.    Basically, if they search for >5000 in the "Current AR" column, I would like them to know what is filtered.  Since it is not a field, I am unable to use GetFieldSelections().  Any help would be greatly appreciated!