Forum Discussion

KevinHaigler's avatar
KevinHaigler
Qrew Member
5 years ago

Filter Saved Report with API

I have a saved report that I need to manipulate externally.
However I need to filter by month, and this month is not consistent (Not always this month, or last month).

How do I either:
1)Add a filter parameter to an established query
2)Find the query string associated with a saved report
3) Utilize the "Ask the user" option in filters via API

Edit: Report is a summary report, or I could build the query string.



------------------------------
Kevin Haigler
------------------------------
APIs and custom code
reports and charts
  • JohnNiumata's avatar
    JohnNiumata
    Qrew Trainee
    5 years ago
    which api, then restful api?

    ------------------------------
    Johnny
    ------------------------------
    • KevinHaigler's avatar
      KevinHaigler
      Qrew Member
      5 years ago
      Hi Johnny,

      I was initially trying to use the Do_Query, I haven't looked much into the Restful APIs at this point.
      Though since I've hit a wall, I'm open to other suggestions.

      Thanks,

      ------------------------------
      Kevin Haigler
      ------------------------------
      • JohnNiumata's avatar
        JohnNiumata
        Qrew Trainee
        5 years ago
        you can do it by building the query 
        example of query in url
        https://[realm].quickbase.com/db/?a=API_DoQuery&query={'14'.BF.'today'}&apptoken=[appToken]

        {'14'.BF.'today'} - field 14 (end date) , occurs before today
        {'6'.OAF.'today'} - field 6 (start date), occurs either today or after today

        there is documentation, but its not simple.

        ------------------------------
        Johnny
        ------------------------------
    • KevinHaigler's avatar
      KevinHaigler
      Qrew Member
      5 years ago

      Is there a way that you know of to view the existing query string? Or how do I build a query string for a summary report?

      Original question has now been updated to show that the original report is a summary report.



      ------------------------------
      Kevin Haigler
      ------------------------------
      • JohnNiumata's avatar
        JohnNiumata
        Qrew Trainee
        5 years ago
        yes, there is a feature when you are viewing a report
        in the top right there is a "more" link, it will list options, one of them shows the the current link
        It does not show up on every view of the report for some reason.

        ------------------------------
        Johnny
        ------------------------------