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

Question

Question

Quick Fields Real Time Lookup column tokens from Stored Procedures

asked on December 18, 2018

When Setting up a Custom Query Lookup, after running a successful test, the returned columns show up in the token picker as available tokens.  When I set up the Real Time Lookup to use a Stored Procedure, even after a successful test, there are no columns to choose from in the token picker.  I can manually type in the token name %(Column.ColumnName) and Quick Fields will underline it with red to indicate a problem, but if I save and run it, the token works.

Are the columns from a Stored Procedure results supposed to populate the token picker?  If not, is just manually entering it like I did the way we are supposed to access the results?

0 0

Replies

replied on December 18, 2018

It's possible that because it's a stored procedure, the tool can't enumerate the fields at design time. This isn't an uncommon thing in other software that I've worked with.

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

Sign in to reply to this post.