Apex Code Development You need to sign in to do that
Don't have an account?
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?
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