I need to add a specific price level to the result...
# generali
Isabella
04/14/2020, 5:29 PMI need to add a specific price level to the results tab of a saved search, I know I'll need to use the formula (numeric) for it but I don't know what the actual formula should be... can anyone help me out?
s
Suitestallion
04/14/2020, 5:33 PMUsing Search for Price Lists
Published 03/11/2013 01:36 AM | Updated 09/16/2019 10:31 AM | Answer Id: 28153
did you look at this SA?
i
Isabella
04/14/2020, 5:36 PMYes, but that doesn't help me. This is a giant item search that I need only one price level to appear on the results section, and we have like 10 price levels.
s
Suitestallion
04/14/2020, 5:37 PMoo, I see, SQL guru required, which I am not.
i
Isabella
04/14/2020, 5:38 PMYea, that's my issue...
b
battk
04/14/2020, 5:39 PMhave you tried adding a filter on the pricing join?
☝️ 1
i
Isabella
04/14/2020, 5:40 PMI will give that a shot, thank you!
Isabella
04/14/2020, 5:41 PMCan I default the filter so we don't have to select everytime the search is run?
b
battk
04/14/2020, 5:42 PMim not sure what you are describing, normally filters are the same every time they are run
battk
04/14/2020, 5:42 PMavailable filters are filters that you can change the value of
i
Isabella
04/14/2020, 5:43 PMOkay I guess I'm not understanding, I didn't realize there was a way to add a filter that wasn't the available filters tab
Isabella
04/14/2020, 5:46 PMbut this actually works better with having the filter at the top of the search for the person I'm building it for
Isabella
04/14/2020, 5:46 PMthank you for the help I really appreciate it !
5 Views