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

Rafael Ramos shared this question 8 months ago
Answered

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..

Comments (4)

photo
1

Hi Rafael,


Apologies, it seems that my previous response was lost.


You should be able to achieve this, one of two methods. Firstly, you can use Reference Codes to encode the values. I'm unsure if you are after a one to one mapping, however, if that's the case then this would be the best solution.


Otherwise, you can create a Freehand SQL Calculated Field, with the syntax of LEFT(<field>, 2) to get the first two letters of the field. You can then use this as a filter, to filter on the untrimmed field. Screenshots explaining this are below.


/a6dfa6d13dc22da57495d2ee85c5b30f


/2af8cfffb7e42c113c4a61c37ff7711f

/3bc8b22e57a9b33922ab1cd89e1ac9e5


Let me know if you have any further questions.


Kind regards,

Simon

photo
1

Thanks Simon,

Kind Regards,

 

Rafael Ramos  /  Customer Software Support Analyst

p. +61 (08) 8379 8200   /support@integratedaviationsoftware.com

Unit 9 202 Glen Osmond Rd Fullarton, South Australia 5063, Australia

8f610d4bd1403aac57e86a51e97a820b

www.integratedaviationsoftware.com

From: Yellowfin Support <support@yellowfin.bi>

Sent: Wednesday, 1 December 2021 12:45 PM

To: Rafael Ramos <rafael@integratedaviationsoftware.com>

Subject: New Comment in "How to configure a selectable list of 'starts with' or likes' trimmed from the report filter?"

photo
1

Hi Rafael,


No problem! Did you have any further questions on this topic, or am I able to go ahead and mark this as answered?


Kind regards,

Simon

photo
1

Hi Simon,

Sure no problems.

Kind Regards,

 

Rafael Ramos  /  Customer Software Support Analyst

p. +61 (08) 8379 8200   /support@integratedaviationsoftware.com

Unit 9 202 Glen Osmond Rd Fullarton, South Australia 5063, Australia

aa273bfd0c64f9fcd6dbee782729a0d3

www.integratedaviationsoftware.com

From: Yellowfin Support <support@yellowfin.bi>

Sent: Friday, 3 December 2021 5:00 PM

To: Rafael Ramos <rafael@integratedaviationsoftware.com>

Subject: New Comment in "How to configure a selectable list of 'starts with' or likes' trimmed from the report filter?"