New Topic

Community Topic Question Report Builder

Mark McGuire

Yellowfin Support Team

Assigned

Category Report Builder

Product Version 9.0

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

Rafael Ramos shared this question 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..

The same question

Replies (7)

Rafael Ramos ●

Thanks Simon,

Kind Regards,

Rafael Ramos

Reply URL

Rafael Ramos ●

Hi Simon,

Sure no problems.

Kind Regards,

Rafael Ramos

Reply URL

ndaru sekar ●

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

Reply URL

Mark McGuire ●

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

Reply URL

Mark McGuire ●

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

Reply URL

ndaru sekar ●

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

URL

Mark McGuire ●

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

URL

Mark McGuire ●

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

URL

Mark McGuire ●

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

URL

ndaru sekar ●

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

URL

Mark McGuire ●

Hi Ndaru,

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

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

Regards,

Mark

URL

ndaru sekar ●

actually, i don't know about this, because BMC centre handle this, i am at site, but i need to know about the answer, thank you Mark

URL

Mark McGuire ●

Hi Ndaru,

Thank you for getting back to me. If you are using Yellowfin and have this installed then one can obtain the info.jsp by adding this to the end of the URL; /info.jsp

Alternatively you can reach out to BMC (Your Account Manager etc.) to obtain this information.

Regards,

Mark

URL

Mark McGuire ●

Hi Ndaru,

I have raised a new Private ticket for you here; https://community.yellowfinbi.com/ticket/29744

Further communications can be held within that ticket.

Regards,

Mark

URL

Rafael Ramos ●

Hi all,

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

Kind Regards,

Rafael Ramos

Reply URL

Mark McGuire ●

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

Reply URL