Further filtering API_GenResultsTable when calling by qid

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

Hello! I did a search for this question and wasn't able to find much in search of answers, but it does appear that other people have been interested in this in the past, so I'm hoping maybe something has come up since then!

Basically, I have this query that runs within an Exact Form:

~=qdb.GetURL("xxxxxxxxx","API_GenResultsTable^qid=25^ts="+ new Date().getTime());~

That qid there references a report that I created in the table, as I'm sure you probably know.

What I would like to do is further filter that report based on the record from which the report was called. What I'm trying to do is add the link to the Exact Form as a button in a form. When the button is clicked and the form/report load up, it'll further filter the report based on the Record ID# of the record that the button was clicked from, kind of like this:

~=qdb.GetURL("xxxxxxxxx","API_GenResultsTable^query={'180'.EX.'"+ field["Record ID#"]+"'});~

I guess I'd like to somehow combine the power of both qid and query. Is it possible? I realize it's asking a lot, but it would really be nice!

Photo of Shaun Grey

Shaun Grey

  • 0 Points

Posted 3 years ago

  • 0
  • 1
Photo of Eric

Eric

  • 40 Points
You have two options. First is to call a qid as a part of your API_GenResultsTable call, and that will use the selected filters on that report. Second, you can omit the qid and instead provide your own query parameters. Please see the API documentation here for more details: http://www.quickbase.com/api-guide/index.html#gen_results_table.html. I'm not aware of a way to combine the two however.
Photo of Shaun Grey

Shaun Grey

  • 0 Points
ah, that's too bad! Maybe one day!