In Exact Forms, if you're linking to a report via field id (ex: ~132~) then it will only pull up the default report for the table that it's linking to.
To do a full-fat version of the table report, you'll need to
invoke an api instead of the field id. The example query below may not suit your exact needs/purpose, but it will give you a solid foundation to build from. If you copy and paste the code below into your exact form, replacing the 'bold' bits with the info specific to your app - it will work:
~=qdb.GetURL("
childtable id","API_GenResultsTable
^qid=childReportId#^query={'
childfieldid#'.EX.'"+ field["
parentfield name"]+"'}");~
A breakdown of how that works/where to find some of the info in your system:
- ~=qdb.GetURL("childtable id",
- You'll find this in the browser's address bar when navigating through records of that table.
- "API_GenResultsTable
- This is the API that you're invoking. Information about how to customize what it pulls up is linked at the top of this post (which will also direct you to API_Doquery - they both follow the same rules/instruction set).
- ^qid=childReportId#
- You can find this number in a few different places. The easiest would be to just open the report in your browser and it'll be the last bit of the webaddress.
- Edit note: Including the QID of the report will override any customization/filters done through the next step, including filtering for just a parent record.
- ^query={'childfieldid#'
- This is the id# of the field relating the child records to the parent record.
- .EX.
- This means to 'find an exact match'
- '"+ field["parentfield name"]+"'}");~
- This is the field name of the field in the Parent table that the child field references to relate.
------------------------------
Brad Lemke
------------------------------
