I'm trying to query the embedded report in the extract form, but for some reason no data. Looking at the network when the print page loads shows these requests, which the last one might have some URL encoding issues:
~=qdb.GetURL("bgwh72y8f","API_GenResultsTable^query={'6'.EX.'"+field["Order #"]+"'}^clist=7.8.10.11.13.14.15.16.17.18.19.21&options=nvw.ned.phd.nfg");~
How to fix this ?
Try changing &options to ^options
Hi Keith, it didn't work. I took a look at the request being made in the network tab and it looks like it's adding %27 in the url. This is what the form is requesting :
This is what it should be requesting :
Order # : 231132
My exact form function :
~=qdb.GetURL("bgwh72y8f","API_GenResultsTable^query={'6'.EX.'"+field["Order #"]+"'}^clist=7.8.10.11.13.14.15.16.17.18.19.21^options=nvw.ned.phd.nfg");~
Hi Keith, I was able to fix this, the solution was to get rid of the single quotes in my function since they get encoded to %27 in the url. and also use the Record ID# instead of the Order #. Thanks for your help.
Working query looks like :
~=qdb.GetURL("bgwh72y8f","API_GenResultsTable^query={6.EX."+field["Record ID#"]+"}^clist=7.8.10.11.13.14.15.16.17.18.19.21^options=nvw.ned.phd.nfg");~
