+ Start a Discussion
Mona Verma 2Mona Verma 2 

How to Paginate combined lists from two objects order by distance

Hi All,
I am struggling to find best way to create a lightning component which lists Accounts as well as Person Account records created within a time range ordered by distance from a certain location (lat/lng) along with pagination.

I already have a working components which lists all accounts created within time specified ordered by distance with Offset value for 10 records each time. But now to include all Person accounts in that list with ordering to work together on (Account+Person Accounts), is it possible to achieve with one query?

are you getting any error when you are running a query

can you post the query and error