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

Question

Question

How to Format the result of a Custom Query ?

Quick Fields
Updated January 29, 2015
asked on January 28, 2015

In Quick Fields 9, I' ve added a real time Processes in order to simulate a lookup from my DB.

I want the user to key in the beginning of a name and get it from the DB. 

I used a simple Request to find the first match : 

 

SELECT TOP 1 Name FROM [dbo].[Supplier] WHERE UPPER(Name) LIKE '%' + UPPER(?) +'%'

 

In the "Configure Result Action" I used %(Column.Name) as Value.

But it doesn't work. I've tested the request it was good so the issue should be in the "Configure Result Action"

Is the formatting good ?

 

Thanks

0 0

Answer

APPROVED ANSWER
replied on January 29, 2015

The settings you indicated look fine, but I'm not sure if that's the complete picture. I used your settings and was able to configure a working session in Quick Fields. Please see this linked video of how I set this up in Quick Fields.

If you are unable to get your Quick Fields session working properly, I'd recommend signing up for a consultation forum webinar with our Presales group and they can look over your session to see if something may have been missed. If they determine that the session looks fine, but that there may be a problem with the Quick Fields software, then they'll notify Support and a case can be opened to investigate the matter.

0 0
replied on January 29, 2015

Hey Sebastian,

 

If you're not familiar with Consultation Forum Webinars (CFW), you can find a list of the available CFWs for the week from the VAR Portal by selecting the CFW with Presales option under the "Training" section.

0 0

Replies

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

Sign in to reply to this post.

Details
Related Posts
Loading ...