Hi All. Question. I have a non stored field (popul...
# suitescriptr
reza.seedin
05/24/2023, 11:12 PMHi All. Question. I have a non stored field (populated via search). Works great on the UI and can access the value via code no issues. But when I add it to a Saved search its blank? Any ideas what's going on?
d
David B
05/24/2023, 11:17 PMbecause its values are not stored, the field is not available in search results
👍 2
r
reza.seedin
05/24/2023, 11:18 PMDamm it. but via script I was able to get the value so I thought now NS might be allowing it
d
David B
05/24/2023, 11:20 PMI didn't know you could access the value via script. So thanks, TIL
r
reza.seedin
05/24/2023, 11:20 PMMight need another script to COPY over he the value to a stored field if they are different
Might have to have another script
reza.seedin
05/24/2023, 11:20 PMYeah I was surprised as well.
reza.seedin
05/24/2023, 11:20 PMreza.seedin
05/24/2023, 11:21 PMbut in script I access it via a search as well in 2.1
d
David B
05/24/2023, 11:21 PM"Might need another script"yeah, I've seen that solution before (UE/SS to persist values of non-stored fields)
David B
05/24/2023, 11:22 PMis there any chance you'd be able to replicate the results of the summary-search within the other saved search? Maybe using the PLSQL analytic functions?
r
reza.seedin
05/25/2023, 12:53 AMI have not used SuiteQL at all. The customer wants to add my NEW un-stored field into their existing saved searches
👍 1
d
David B
05/25/2023, 12:57 AMat risk of confusing things, I was meaning how you can make saved searches execute analytic functions in formulas. See here for an example. Definitely an advanced, unsupported method that requires knowledge for SQL queries
2 Views