filter not taking the format of the column properly

Hi people,
I am currently working on reports and would like to filter a column using the legacy designer report view.

The issue I am facing is: the report has a text formatting column with data like this 000004774 so every time I try to search for the whole text value 000004774 and hit apply the filter field automatically takes it as number value and removes the zeros thus, no matches.

However, filtering using a!queryProcessAnalytics() works properly.

attaching screen shot, please advise.

OriginalPostID-270204



  Discussion posts and replies are publicly visible

Parents
  • while configuring the properties for the report metric, i guess for the display name "text_column" the formatting is ""number"" that why you can see that all filtering conditions applicable to number are visible(=, <>,<=,>=,>,<). if you format the display name(text_column) as ""normal text"" you will see a text box while does takes the input as text(in the screen shot you can see for Related Action?) please let know if this helps.
Reply
  • while configuring the properties for the report metric, i guess for the display name "text_column" the formatting is ""number"" that why you can see that all filtering conditions applicable to number are visible(=, <>,<=,>=,>,<). if you format the display name(text_column) as ""normal text"" you will see a text box while does takes the input as text(in the screen shot you can see for Related Action?) please let know if this helps.
Children
No Data