Joined: 14 Jun 2013
Online Status: Offline
Posts: 4
Topic: Select Expert: How to filter specific words? Posted: 16 Feb 2016 at 12:05pm
Hi,
I am a newbie here :)
I am trying to show only some part of short description on my report using Select Expert. Can you please help me on how I can do this?
I tried to use "is like" and put "archived" but when I ran the report, it went blank. I tried a formula from Report> Selection Formulas>record and put the following but I still got a blank report.
{PR_Activity.short_description}like "archived"
Basically, I am trying to show on my report anything that has "archived" on Short Description field. I have CR v. 11
Joined: 14 Jun 2013
Online Status: Offline
Posts: 4
Posted: 16 Feb 2016 at 1:44pm
Hi kevlray,
Thanks for checking my issue. I tried is like from Select Expert and typed *archived (this word is on my short description field) but I am still getting blank report. Basically when I clicked the formula, it shows:
{PR_Activity.short_description} like "*archived"
I also tried ?archived but still the same result. I don't know what to do anymore.
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Posted: 17 Feb 2016 at 2:40am
as kevlray indicates the * replaces many and the ? replaces 1 character.
The way you have your select written it will only find records that end with 'archived'.
To look for the word anywhere in the string add the * to the front and back of the word
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum