Discussions

 View Only
  • 1.  Exact form embedded report

    Posted 03-09-2023 20:11

    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
    ------------------------------


  • 2.  RE: Exact form embedded report

    Posted 03-09-2023 21:02

    Try changing &options to ^options



    ------------------------------
    Keith Jusas
    ------------------------------



  • 3.  RE: Exact form embedded report

    Posted 03-10-2023 09:29

    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
    ------------------------------



  • 4.  RE: Exact form embedded report

    Posted 03-10-2023 10:23

    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
    ------------------------------