Many Thanks. I can reproduce the issue now.
> Paginate(
... Intersection(
..... Join(
....... Range(Match(Index("PeriodicIncomePaymentDateByWallet"),[Ref(Collection("Wallet"),"284905087731499525")]), ["2021-01-01"],["2021-12-31"]),
....... Lambda(["date", "ref"],Match(Index("PeriodicIncomePaymentRefByRef"),[Var("ref")]))
....... ),
..... Union([Match(Index("PeriodicIncomePaymentByPaymentStatusAndWallet"),[Ref(Collection("Wallet"),"284905087731499525"), 3])])
..... ),
... {size:64}
... )
{
data: [ Ref(Collection("PeriodicIncomePayment"), "293405882402743809") ]
}
> Paginate(
... Intersection(
..... Join(
....... Range(Match(Index("PeriodicIncomePaymentDateByWallet"),[Ref(Collection("Wallet"),"284905087731499525")]), ["2021-01-01"],["2021-12-31"]),
....... Lambda(["date", "ref"],Match(Index("PeriodicIncomePaymentRefByRef"),[Var("ref")]))
....... ),
..... Union([Match(Index("PeriodicIncomePaymentByPaymentStatusAndWallet"),[Ref(Collection("Wallet"),"284905087731499525"), 3])])
..... ),
... {size:70}
... )
{
data: [
Ref(Collection("PeriodicIncomePayment"), "293405882402743809"),
Ref(Collection("PeriodicIncomePayment"), "293517732543991301"),
Ref(Collection("PeriodicIncomePayment"), "293517732543992325"),
Ref(Collection("PeriodicIncomePayment"), "293517732543993349"),
Ref(Collection("PeriodicIncomePayment"), "293517732543994373"),
Ref(Collection("PeriodicIncomePayment"), "293517732543995397"),
Ref(Collection("PeriodicIncomePayment"), "293517732543996421"),
Ref(Collection("PeriodicIncomePayment"), "293517732543997445"),
Ref(Collection("PeriodicIncomePayment"), "293517732543998469"),
Ref(Collection("PeriodicIncomePayment"), "293755536226124289"),
Ref(Collection("PeriodicIncomePayment"), "293755536226125313"),
Ref(Collection("PeriodicIncomePayment"), "293755536226127361"),
Ref(Collection("PeriodicIncomePayment"), "293755536226128385")
]
}
> Paginate(
... Intersection(
..... Join(
....... Range(Match(Index("PeriodicIncomePaymentDateByWallet"),[Ref(Collection("Wallet"),"284905087731499525")]), ["2021-01-01"],["2021-12-31"]),
....... Lambda(["date", "ref"],Match(Index("PeriodicIncomePaymentRefByRef"),[Var("ref")]))
....... ),
..... Union([Match(Index("PeriodicIncomePaymentByPaymentStatusAndWallet"),[Ref(Collection("Wallet"),"284905087731499525"), 3])])
..... ),
... {size:100000}
... )
{
data: [
Ref(Collection("PeriodicIncomePayment"), "293405882402743809"),
Ref(Collection("PeriodicIncomePayment"), "293517732543991301"),
Ref(Collection("PeriodicIncomePayment"), "293517732543992325"),
Ref(Collection("PeriodicIncomePayment"), "293517732543993349"),
Ref(Collection("PeriodicIncomePayment"), "293517732543994373"),
Ref(Collection("PeriodicIncomePayment"), "293517732543995397"),
Ref(Collection("PeriodicIncomePayment"), "293517732543996421"),
Ref(Collection("PeriodicIncomePayment"), "293517732543997445"),
Ref(Collection("PeriodicIncomePayment"), "293517732543998469"),
Ref(Collection("PeriodicIncomePayment"), "293755536226124289"),
Ref(Collection("PeriodicIncomePayment"), "293755536226125313"),
Ref(Collection("PeriodicIncomePayment"), "293755536226127361"),
Ref(Collection("PeriodicIncomePayment"), "293755536226128385"),
Ref(Collection("PeriodicIncomePayment"), "293755536226129409"),
Ref(Collection("PeriodicIncomePayment"), "293755536227172865"),
Ref(Collection("PeriodicIncomePayment"), "293755536227173889"),
Ref(Collection("PeriodicIncomePayment"), "293755536227174913"),
Ref(Collection("PeriodicIncomePayment"), "293755536227175937"),
Ref(Collection("PeriodicIncomePayment"), "293755536227176961"),
Ref(Collection("PeriodicIncomePayment"), "293755551313035783"),
Ref(Collection("PeriodicIncomePayment"), "293755551313036807"),
Ref(Collection("PeriodicIncomePayment"), "293755551313037831"),
Ref(Collection("PeriodicIncomePayment"), "293755551313038855"),
Ref(Collection("PeriodicIncomePayment"), "293755551314084359"),
Ref(Collection("PeriodicIncomePayment"), "293755551316181511"),
Ref(Collection("PeriodicIncomePayment"), "293755551316182535"),
Ref(Collection("PeriodicIncomePayment"), "293755551316183559"),
Ref(Collection("PeriodicIncomePayment"), "293755551316184583"),
Ref(Collection("PeriodicIncomePayment"), "293755551316185607")
]
}
>