Report Designer Slike and Rlike

Hi ​@dreycruz,

LLike and RLike in Acumatica Report Designer are Boolean string comparison functions used in filters and expressions.

They behave similarly to SQL LIKE, but are simplified helper functions.

RLike (Right Like → Starts With):-

Returns True if the field value starts with the specified text.

Example: =RLike([Customer.AcctCD], "C")

Matches:

• C0001

• CUST100

Equivalent SQL:Customer.AcctCD LIKE 'C%'

LLike (Left Like → Ends With):-

Returns True if the field value ends with the specified text.

Example: =LLike([Customer.AcctCD], "01")

Matches:

• C0001

• A1001

Equivalent SQL: Customer.AcctCD LIKE '%01

These functions are typically used in Schema Builder filters, VisibleExpr, or conditional formatting rules.

 

Hi ​@dreycruz,

LLike and RLike in Acumatica Report Designer are Boolean string comparison functions used in filters and expressions.

They behave similarly to SQL LIKE, but are simplified helper functions.

RLike (Right Like → Starts With):-

Returns True if the field value starts with the specified text.

Example: =RLike([Customer.AcctCD], "C")

Matches:

• C0001

• CUST100

Equivalent SQL:Customer.AcctCD LIKE 'C%'

LLike (Left Like → Ends With):-

Returns True if the field value ends with the specified text.

Example: =LLike([Customer.AcctCD], "01")

Matches:

• C0001

• A1001

Equivalent SQL: Customer.AcctCD LIKE '%01

These functions are typically used in Schema Builder filters, VisibleExpr, or conditional formatting rules.

 

 

Thanks!

​@dreycruz,
Glad it helped. Let me know if you need any additional clarification.

Hi ​@dreycruz,
This link will help you better understand the usage of RLike conditions.