filter not taking the format of the column properly

martinc8721 over 7 years ago

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.

Discussion posts and replies are publicly visible

0 chandu
A Score Level 2
over 7 years ago

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.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 abhinavg712
Certified Lead Developer
over 7 years ago

@Martin, change the formatting of said column to Normal Text from Number and then try searching using column filter.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 aloks0189
Certified Lead Developer
over 7 years ago

@martinc872 i agree with @abhinavg712 you can try formatting that column as Text and then filtering with 000004774 as a Text Value
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel