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

Parents

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

Reply

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

Children

No Data