RE: Saved Search: How to check if different item records (Kit vs Assembly vs Inventory Item) have the same name?

Let’s say there’s inventory item with name ‘blue’

Then someone made an assembly with the name ‘blue123’, but did not attach that inventory item yet in any way. So there’s no connection between them.

How do I do a saved search to match inventory item record name with the name of the assembly? 

Like check if item.name is in assembly.name? 

 

Cyberpunk Rookie Asked on October 13, 2021 in Saved Searches.
Add Comment
2 Answers

Hi

This should work if the item name is included in the assembly name.  

In the saved search criteria add a formula(numeric)

CASE
WHEN {item.name} LIKE ‘%’||{assembly.name}||’%’ THEN 1
ELSE 0
END

Then set the operator greater than zero to return only the data with matching values.

Cheers

Edo

Beginner Answered on October 15, 2021.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.