Weird… I am receiving an invalid summary type erro...
# suitescripts
suitedev
10/25/2021, 11:21 PMWeird… I am receiving an invalid summary type error when attempting to return or run a search in a M/R script. The search is counting transaction types, and it works fine in the UI, but if I return the same search in the M/R script > getInputData()
I receive an invalid summary type error.
c
creece
10/25/2021, 11:56 PMI'd build a custom data object of the search results and get around it. I'd recommend doing that regardless really. Not sure why it would freak out on the return though.
s
suitedev
10/25/2021, 11:58 PMThe summary criteria is needed because there are tens of thousands of results otherwise
b
battk
10/26/2021, 12:41 AMwhat doe the search code look like
s
suitedev
10/26/2021, 2:44 AMPutting kids down.. will reply in a bit
suitedev
10/26/2021, 2:46 AMIt’s an Entity search counting transaction types greater than 1. Will share code..
suitedev
10/26/2021, 4:01 AM@battk it’s an entity search, with only joined transaction fields defined for columns… with no columns grouped.
In order for the summary criteria to pass validation, I need to group on the entity internalid. The result in the UI works without grouping, and returns the transaction fields (main line only) without error.
b
battk
10/26/2021, 4:03 AMthe ui will ignore summary criteria without summary columns
battk
10/26/2021, 4:03 AMscripts wont
👍 1
battk
10/26/2021, 4:03 AMif your search works as you wanted it to, then you may not need the summary criteria in the first place
2 Views