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?
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
You can Filter by Name and then chose a selector that best fists such as has keywords, contains, starts with … etc.
I think there is more to your question.