You are viewing limited content. For full access, please sign in.

Question

Question

Feature Request: create identity token in Custom Query Activity.

asked on October 15, 2018

Currently, in Workflow if you use an Insert Data activity it allows you to “check” create identity token so that you can access that identity token from a later activity. However, the custom query activity doesn’t allow a similar feature. This would be very helpful if there was some option that allowed us to do that.

 

I had to do in 6 activities what I might have been able to do in 2 (maybe 3). I need to a GUID which means I need to use a custom query so I can take advantage of SQL’s “newid()” function to create it. But Insert Data activities won’t accept SQL query functions, only values. Instead, I had to use the Insert Data activity and put in a placeholder for my GUID. Then query the identity record it created to get the Instance. Then use the Instance in a custom query to update the GUID. Then run another query to get the GUID it created.

 

1 0

Replies

replied on October 15, 2018

I agree this would be nice, another option for you though might just be doing this quickly in a script as it is only 2 lines of code.

 

protected override void Execute()
        {
            String guid = Guid.NewGuid().ToString();
            this.SetTokenValue("CurrentGUID", guid);
         }

 

 

2 0
You are not allowed to follow up in this post.

Sign in to reply to this post.