Would anyone know why when I set my filter to [ "t...
# suitescriptc
Craig Schellenbach
09/17/2024, 10:24 PMWould anyone know why when I set my filter to [ "tranid", "is" ,transactionId ] and the transactionaId = 485 I get results that include 485, ETK0000485 and A0000485? This happens on my saved search through netsuite as well.
a
Anthony OConnor
09/17/2024, 10:35 PMthere's another filter that's also for "tranid" ? that's using contains instead of is?
c
Craig Schellenbach
09/17/2024, 10:36 PMNot that I know of. All of those records are in the tranid field.
Craig Schellenbach
09/17/2024, 10:37 PMIt's treating it as a sql's like '%485'
Craig Schellenbach
09/17/2024, 10:39 PMimage.png,image.png
Craig Schellenbach
09/17/2024, 10:40 PMIn the screen shots that same fieldId has different labels. I am just trying to understand why when I give a specific record = 485 that it returns a wildcard.
a
Anthony OConnor
09/17/2024, 10:41 PMgenerally we would use internalid if you want a specific record
c
Craig Schellenbach
09/17/2024, 10:42 PMYeah, I am thinking I might have to but in my filters I am trying to pull in all SO/Item Fullfilments/Returns
m
mbrewer
09/18/2024, 1:35 PMmay be able to write it as formulatext and get the results you expect
✅ 1
6 Views