Using Custom Inventory Rule String Return in a Smart Label data structure?
When using data from a Custom Inventory Rule String Return in a Smart Label, the logic for the label requires using "begins with" or "does not begin with" or "contains" instead of the "=" or "!=", I'm guessing there's other characters that are getting returned with the inventoried data but I've been unable to find it in the documentation on it.
Here's my example:
I'm guessing it needs to be Enable.String or Enable [String] or something similar. Changing to "begins with" works, but that starts to complicate the smart label logic pretty quickly.
Answers (1)
Have you thought about just writing the SQL and then applying that to the smart label?
So write the SQL that does what you need, then create a smart label, view SQL and insert your SQL into the smart label, that way you are not relying on having to use the smart label wizard and its restrictions to create the smart label.