Is there any way for a search to get a count of cu...
# suitescript
a
Is there any way for a search to get a count of custom child records attached to a custom parent record? Maybe with a formula filter? I need to do this strictly on the parent record without searching and looping through child records.
s
i'm still gonna ask what the usecase is simply because within your fixed route there is no good solution that can be provided
from what you're saying you can do one search on the child record, where parent is your custom parent and there is no looping required it's done
a
I need a saved search column that is a count of a certain child record, so I can't search on the child record
s
im assuming you cant search on the parent as well?
if the gap is the retrieval of information based on children, you can really look to see if objects can help you out
a
I'm trying to do this through the parent record
I'm really just looking for a search formula that will get the count, not necessarily a way to code this
s
mm to be honest i think i understand what you're saying
and it's do-able just requires some highly manipulative object mapping
since if it's that fking big you dont need multiple queries, you just need to if you like load the whole damn database and then each time just figure out from that database
the way Javascript is with objects that's very do-able
s
I'm confused why you cant just join to the child record from the parent and count on internalid of children?
s
i might be overthinking but if you were in MR and if you have a bunch of children and you are trying to find common parents or even just subsidiary idk, idk nvm lol
t
you have a parent hcild? Can't you just load the record and look at the sublits count?