Client-side "Fetch Data from Other Sources" and Advance SQL for Local Storage

On our radar

Sometimes I need to prepare custom list to be used as data source in List.

Right now, I'm doing it in On-Ready event.

New Option for Client-side Fetch Data from Other Sources would be nice.

Also please add Advance Local Storage SQL in client action.

I have use case that need to use nested query / subquery:

select avg(maxval) from (

   select max() maxval from... group by...


And I don't know how to use such nested query/subquery using Aggregate alone.

My only option was to Fetch the subquery, then do a loop and processing it by myself, which is not efficient.

Created on 7 Mar
Comments (0)