ok this is a new one.. with a new guy attempting a...
# suiteql
k
ok this is a new one.. with a new guy attempting a user input Suitelet parameter.. Does the braintrust have a correct method of using this similar request?
select * from transaciton where ExternalID LIKE '%'+?+'%'
. Basically I am trying to wrap the end-user's input within wildcards. Any guidance would be greatly appreciated.
m
Try using
||
rather than
+
to perform the concatenation.
👍 1
k
Freakin awesome.. it is always the simplest of things!! TYSM😁
i
not sure if it helps in your use case or if you are already using but if using 2.1 you can use template/string literals
👍🏻 1
👍 1
thisline 1