Skip to main content
Question

Report Designer visible condition: Shop Order


Forum|alt.badge.img+1

I was wondering what the correct syntax is for the “starts with” operator. In the technical documentation, I’ve only come across the operator shown in the screenshot below.

Does IFS Report Designer support “starts with” and “doesn’t start with” operators?

I need to add a visible condition to exclude any records where CHARACTERISTIC_DESC starts with "B36", so they don’t appear in the report.

Here’s what I’ve tried so far, but none of these worked:

contains(tns:CHARACTERISTIC_DESC, 'b-36')  
starts-with(tns:CHARACTERISTIC_DESC, b36)  
starts-with(CHARACTERISTIC_DESC, b36)  

 

I would appreciate any tips.

Operator Description
and Logical-and
or Logical-or
not() Negation
= Equality
!= Not equal
< Less than
<= Less than or equal
> Greater than
>= Greater than or equal

 

2 replies

dsj
Ultimate Hero (Partner)
Forum|alt.badge.img+22
  • Ultimate Hero (Partner)
  • 868 replies
  • April 7, 2025

Hi ​@jyoti.sah 

 

You can use a formula such as below

 

Visible condition for Starts with

vldtstr:strCompare(vldtstr:strLeft(tns:CHARACTERISTIC_DESC,3),'B36') = 0

Visible condition for Not starts with

vldtstr:strCompare(vldtstr:strLeft(tns:CHARACTERISTIC_DESC,3),'B36') != 0

 

Hope it helps!

Damith


Forum|alt.badge.img+1
  • Author
  • 3 replies
  • April 7, 2025

That did work. Thanks a lot for help. 😊😊


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings