Skip to main content

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

 

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


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


Reply