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");~
------------------------------
Ayoub Salhi
------------------------------
Original Message:
Sent: 03-10-2023 09:28
From: Ayoub Salhi
Subject: Exact form embedded report
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 :
https://dlas.quickbase.com/db/bgwh72y8f?act=API_GenResultsTable^query={%276%27.EX.%27231132%27}^clist=7.8.10.11.13.14.15.16.17.18.19.21^options=nvw.ned.phd.nfg
This is what it should be requesting :
https://dlas.quickbase.com/db/bgwh72y8f?act=API_GenResultsTable^query={%276%27.EX.1132%27}^clist=7.8.10.11.13.14.15.16.17.18.19.21^options=nvw.ned.phd.nfg
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");~
------------------------------
Ayoub Salhi
Original Message:
Sent: 03-09-2023 21:02
From: Keith Jusas
Subject: Exact form embedded report
Try changing &options to ^options
------------------------------
Keith Jusas
Original Message:
Sent: 03-09-2023 20:10
From: Ayoub Salhi
Subject: Exact form embedded report
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 ?
------------------------------
Ayoub Salhi
------------------------------