[Note: several hours after posting this article I realized the “Hide Object” calc could be streamlined. Screen shot and demo have been updated to reflect this.]
Demo file: virtual-portal-v2b.zip (requires FM 18 or later)
This is a quick follow up to the Virtual Portal article I posted the other day. As you may recall, the objective was to use virtual list to display disparate entities in a portal…
…via an array like this…
…which was auto-generated via a Hide Object calculation attached to this field:
Alex Zueiv demonstrated in the comments section that the SQL used to generate the array could be made more robust (thank you Alex). Another way to make the array more robust would, of course, be to generate it via JSONSetElement rather than ExecuteSQL… and today’s demo is almost identical to the one I posted the other day except:
a) the Hide Object calculation attached to zz_g_downstream_ownership has been revised to use While and JSONSetElement…
…and b) an ascending “name” sort has been added to the relationships from Company to the four child table occurrences.
For more information on While, see…