How to configure a selectable list of 'starts with' or likes' trimmed from the report filter?

Rafael Ramos shared this question 2 years ago
Completed

Greetings all,

Hope you're all well.

I would like to trim the results of a field to display the first two characters that I am after for my selection and then be able to select these values from the filter (as a list) when running the report.

For example 'AD2012-23-05' would show 'AD' in the report filter and when selected, display all the records that start with AD in the report.

The same goes for 'EO139-2500M-0083-FMS1' which would be 'EO' and show all the records when this is selected from the report filter from the same list.

Is there any way of doing this?

Appreciate your help and much thanks in advance.

Rafael..

Replies (7)

photo
1

Thanks Simon,

Kind Regards,

Rafael Ramos

photo
1

Hi Simon,

Sure no problems.

Kind Regards,

Rafael Ramos

photo
1

Hay Rafael, i have same problem with you, where i also only want to take part of the existing content, used filter starts with ,,,but not worked, thank you for your respon

photo
2

Hi Ndaru,

I hope all is well,

In order to better support this, I think we should jump on a remote session. Kindly let me know of your availability today. I am UK based, so I can make myself available between the hours of 10:30-14:00 UK Time.

In addition could you please provide me with a copy of your info.jsp, more information here. Please upload to our FTP; https://ftp.yellowfin.bi, with the reference of 23585.

I look forward to your response.

Regards,

Mark

photo
1

Hi Ndaru,

I hope all is well,

I know it's only been 24 hours since my last response, however I am keen to get this looked at for you asap. If you can get back to me with the requested information that would be great.

Regards,

Mark

photo
1

Hay Mark, nice to meet you

i am from Indonesia, i have same problem with Rafael Ramos

my problem is...example

description 1 = effective server backup until end bla bl bla

description 2 = about server backup will be restored at the end of june


and i will only retrieve all sentense that start with BACKUP SERVER (not include effective and about)

i have used start with at the filter but doesnt work


Thank you Mark, and i hope you have good day

photo
1

Hi Ndaru,

In order for me to continue with the support can you please provide me with a copy of your info.jsp more information here. Please upload to our FTP; https://ftp.yellowfin.bi, with the reference of 23585.

Regards,

Mark

photo
1

Hi Ndaru,

I hope all is well,

I just want to touch base to see if you had chance to read through my last response;

"In order for me to continue with the support can you please provide me with a copy of your info.jsp more information here. Please upload to our FTP; https://ftp.yellowfin.bi, with the reference of 23585."

If you could get back to me with this information, that would be great.

I look forward to your response.

Regards,

Mark

photo
1

Hi Ndaru,

I hope all is well,

Just to inform you, I will be marking this back to Completed if I do not hear from you in the coming days. Going forward, if you would like to discuss this further we can do so in this ticket by providing me with the information requested, or we can raise a new ticket to address this issue.

Have a great weekend and speak soon.

Regards,

Mark

photo
1

Hay Mark, sorry for delay, because we had long week end last week

anyway, i am a consiltant from BMC Software, site in Indonesia, and i have this issue,

i tried the various features, but i can't find it

photo
1

Hi Ndaru,

Thank you for getting back to me. As per my previous responses;

"In order for me to continue with the support can you please provide me with a copy of your info.jsp more information here. Please upload to our FTP; https://ftp.yellowfin.bi, with the reference of 23585."

If you could get back to me with this information, that would be great.

Regards,

Mark

photo
photo
1

Hi all,

Can you please remove me from these notifications as I am not sure why I am receiving them.

Kind Regards,

Rafael Ramos

photo
1

Hi Rafael,

I hope all is well,

As this was a Question (Public facing) ticket submitted by yourself this has since had activity by another user within the Yellowfin Community; hence the notifications. Going forward and as requested I have since removed you from the Subscribed list, you should no longer receive these.

Regards,

Mark

Leave a Comment
 
Attach a file