-
Hi,
I think you might want to use .z.ps/.z.pg for this, does the below do what you want?
q)admin:([]query:();time:`timestamp$();user:`$();handle:`int$()) q).z.ps:{`admin upsert enlist ( x 0;.z.p;.z.u;.z.w);value x;} q).z.pg:{`admin upsert enlist ( x 0;.z.p;.z.u;.z.w);value x} q)0 (+;1;2) / run on local p q)admin query time user handle -------------------------------------------------- + 2022.03.01D13:14:16.858901000 pm 0