Hey ya'll - I'm executing an existing search in a ...
# generals
Sirus Badiee
10/21/2019, 6:49 PMHey ya'll - I'm executing an existing search in a scheduled script, but it looks like the pageRangeLength is 0 (which I imagine it's just not returning any results). When I run the search in the UI, I get 5 results! Anybody experience a similar issue?
b
battk
10/21/2019, 7:04 PMSounds weird
battk
10/21/2019, 7:04 PMWhat are the filters of the search
s
Sirus Badiee
10/21/2019, 8:35 PMThanks for the response! Nothing really that out of the ordinary, except for one filter >
Type = Sales Order
Main Line = True
Date = After 8/1
Formula = case when {name} <> {applyingtransaction.name} then 1 else 0 end
Basically, the formula is supposed to look at discrepancies between the Sales Order Customer and the Customer Deposit (Applying Transaction) Customer.
e
ericbirdsall
10/21/2019, 8:51 PM@Sirus Badiee Could you post your code?
s
Sirus Badiee
10/21/2019, 8:52 PMSure thing - much appreciated @ericbirdsall
Sirus Badiee
10/21/2019, 8:54 PMMerge SO Cust to CD Cust.txt
Sirus Badiee
10/21/2019, 8:55 PMThe only relevant bit is before * // This is where the code breaks because pageRangeLeangth = 0, so the code never enters in the for loop*
e
ericbirdsall
10/21/2019, 9:20 PMI cant seem to find anything in the documentation about this property
ericbirdsall
10/21/2019, 9:20 PMpagedData.pageRanges.length
ericbirdsall
10/21/2019, 9:24 PMAre you possibly looking for pagedData.count?
s
Sirus Badiee
10/21/2019, 9:25 PMHm, it's worked before...
Sirus Badiee
10/21/2019, 9:25 PMBut yes, count would make sense as well.
b
battk
10/21/2019, 11:23 PMWhats the value of mySearch.filterExpression
4 Views