Grid Filter Expression for Starts Not Working

Kinetic ERP
,
1

Using all the information from yesterday I’ve been cracking on updating our forms but am having trouble with a starts with expression.

I am working between what I can find on here, the Epicor guide and ChatGPT but can’t seem to crack this expression.

I want to filter if the BAQ result for the part number starts with the Part Number on Part Entry. I’ve tried a filter against Where and Where List but am getting all the BAQ results returned. If I hard code a part number in the Where expression then it all works fine…

image
image390×426 5.76 KB

image
image398×396 5.89 KB

2

Lowercase “S” in starts if using the Where List.

Part_PartNum LIKE '??{Part.PartNum}%' for the Where Clause.

3 Likes
3

Thank you!

1 Like
4

And if using the other, use a single ? if you only want records when that other matches.

2 Likes