<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>idea Prompted Report which hits the database directly, at runtime, without having to preliminarily pull filter options. in Suggest an Idea</title>
    <link>https://community.qlik.com/t5/Suggest-an-Idea/Prompted-Report-which-hits-the-database-directly-at-runtime/idi-p/1940560</link>
    <description>&lt;P&gt;My previous reporting tool allows me to build a prompted report that runs SQL against a database with variable filters which the user enters manually prior to running the report.&lt;BR /&gt;&lt;BR /&gt;Today, in Qlik, I'm being told I have to preliminarily pull all possible filters options into a QVD so that the user can pick from those options (Dynamic View).&amp;nbsp; This is a massive overhead in my case and frankly, quite redundant. If I'm pulling each and every option for them to choose from, I might as well just add a couple more columns and just pull all the data they need into the QVD. Which would be fine if I was dealing with a smaller dataset. For my use-case, however, I will have to pre-pull something like 2.5 million IDs for this to work.&amp;nbsp;&lt;BR /&gt;&lt;BR /&gt;Today, the user simply knows the ID they're looking for and are perfectly capable of entering it manually without having to pull a list of options.&lt;BR /&gt;&lt;BR /&gt;To that end, I'm looking for the ability to allow users to enter their own filter parameter[s] into a pre-built query and utilize that dataset in a pre-built app.&amp;nbsp; Essentially, ODAG without the dynamic view piece.&amp;nbsp; Also note, for my use-case, I'd need this to work for BigQuery.&amp;nbsp; Thanks!&amp;nbsp;&lt;/P&gt;</description>
    <pubDate>Tue, 07 Jun 2022 16:36:20 GMT</pubDate>
    <dc:creator>JTSmall</dc:creator>
    <dc:date>2022-06-07T16:36:20Z</dc:date>
    <item>
      <title>Re: Prompted Report which hits the database directly, at runtime, without having to preliminarily pull filter options.</title>
      <link>https://community.qlik.com/t5/Suggest-an-Idea/Prompted-Report-which-hits-the-database-directly-at-runtime/idc-p/1941122#M9743</link>
      <description>&lt;P&gt;Yes, this would be a much needed feature where you just need the data from DB based on user selection instead of bringing everything in app first.&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Wed, 08 Jun 2022 14:51:01 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Suggest-an-Idea/Prompted-Report-which-hits-the-database-directly-at-runtime/idc-p/1941122#M9743</guid>
      <dc:creator>manish_gupta</dc:creator>
      <dc:date>2022-06-08T14:51:01Z</dc:date>
    </item>
    <item>
      <title>Re: Prompted Report which hits the database directly, at runtime, without having to preliminarily pull filter options. - Status changed to: Open - Not Planned</title>
      <link>https://community.qlik.com/t5/Suggest-an-Idea/Prompted-Report-which-hits-the-database-directly-at-runtime/idc-p/2015925#M11308</link>
      <description>&lt;P&gt;Thanks for the post.&amp;nbsp; Not on the roadmap at this point in time.&amp;nbsp;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Tue, 13 Dec 2022 12:58:53 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Suggest-an-Idea/Prompted-Report-which-hits-the-database-directly-at-runtime/idc-p/2015925#M11308</guid>
      <dc:creator>Andrew_Kruger</dc:creator>
      <dc:date>2022-12-13T12:58:53Z</dc:date>
    </item>
    <item>
      <title>Re: Prompted Report which hits the database directly, at runtime, without having to preliminarily pull filter options.</title>
      <link>https://community.qlik.com/t5/Suggest-an-Idea/Prompted-Report-which-hits-the-database-directly-at-runtime/idc-p/2450447#M17031</link>
      <description>&lt;P&gt;Hi all,&amp;nbsp;&lt;a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/134157"&gt;@Emile_Koslowski&lt;/a&gt;&amp;nbsp;&lt;a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/11063"&gt;@Andrew_Kruger&lt;/a&gt;&amp;nbsp;could this be done with App Automation &amp;amp; Reporting service today?&lt;/P&gt;</description>
      <pubDate>Wed, 08 May 2024 16:55:44 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Suggest-an-Idea/Prompted-Report-which-hits-the-database-directly-at-runtime/idc-p/2450447#M17031</guid>
      <dc:creator>Meghann_MacDonald</dc:creator>
      <dc:date>2024-05-08T16:55:44Z</dc:date>
    </item>
    <item>
      <title>Re: Prompted Report which hits the database directly, at runtime, without having to preliminarily pull filter options. - Status changed to: Closed - Archived</title>
      <link>https://community.qlik.com/t5/Suggest-an-Idea/Prompted-Report-which-hits-the-database-directly-at-runtime/idc-p/2457108#M17133</link>
      <description>&lt;P&gt;Hi, this idea has been in "Not Planned" status for over a year and is still not in consideration. If you'd like to open a new request, please visit the&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;&lt;STRONG&gt;&lt;A href="https://community.qlik.com/t5/Ideation/ct-p/qlik-product-insight" target="_self"&gt;Browse and Suggest page&lt;/A&gt;&lt;/STRONG&gt;&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;and click "Suggest features" and open a new request.&lt;/P&gt;
&lt;P&gt;Meghann&lt;/P&gt;</description>
      <pubDate>Tue, 28 May 2024 15:51:40 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Suggest-an-Idea/Prompted-Report-which-hits-the-database-directly-at-runtime/idc-p/2457108#M17133</guid>
      <dc:creator>Meghann_MacDonald</dc:creator>
      <dc:date>2024-05-28T15:51:40Z</dc:date>
    </item>
  </channel>
</rss>

