Data Tutorials

#7 App.Query with Params - Run multiple times

Using an App.Query multiple times

The previous examples showed how to use an App.Query. Now we want to run the query twice, which requires a Reset().
Note that the parameter PortalId is preset to be [Portal:PortalId].

Requirements

2sxc 12.08

Resources

App Query

Query Params

        @{
      // get the query and ask for the "Default" results as a dynamic List
      var query = App.Query["DnnFilesFromSql"];
      var currentFiles = AsList(query);
      query.Reset();
      query.Params("PortalId", "0");
      var rootFiles = AsList(query);
    }
    
  

files from the current Portal

home.css
background_header.gif
icon-btn-sm-circle-arrow.png
icon-btn-sm-circle-arrow-shadow.png
icon-social-facebook.png
icon-social-linkedin.png
icon-social-twitter.png
icon-social-youtube.png
logo.png
logo2.png

        <ul>
      @foreach(var file in currentFiles) {
        <li>@file.FileName</li>
      }
    </ul>
    
  

Files from the root portal

home.css
background_header.gif
icon-btn-sm-circle-arrow.png
icon-btn-sm-circle-arrow-shadow.png
icon-social-facebook.png
icon-social-linkedin.png
icon-social-twitter.png
icon-social-youtube.png
logo.png
logo2.png

    <ul>
  @foreach(var file in rootFiles) {
    <li>@file.FileName</li>
  }
</ul>

  

SQL data from an App.Query with Params

#7 App.Query with Params - Run multiple times

SQL data from a SQL query and DataTable

Source Code of this file

Below you'll see the source code of the file. Note that we're just showing the main part, and hiding some parts of the file which are not relevant for understanding the essentials. Click to expand the code

@inherits Custom.Hybrid.Razor14
<!-- unimportant stuff, hidden -->
@using ToSic.Razor.Blade;
@using System.Linq;
Using an App.Query multiple times The... <!-- unimportant stuff, hidden -->
<div class="row">
  <div class="col-lg-7">
    
    @{
      // get the query and ask for the "Default" results as a dynamic List
      var query = App.Query["DnnFilesFromSql"];
      var currentFiles = AsList(query);
      query.Reset();
      query.Params("PortalId", "0");
      var rootFiles = AsList(query);
    }
    
    

    <h2>files from the current Portal</h2>
    
    <ul>
      @foreach(var file in currentFiles) {
        <li>@file.FileName</li>
      }
    </ul>
    
    
  </div>
  <div class="col-lg-5">
    @fancybox.PreviewWithLightbox(App.Path + "/data/assets/sql-query-dnn-files.png", width, height, "float-left", label: "Query Tree") 
    @fancybox.PreviewWithLightbox(App.Path + "/data/assets/sql-query-configuration.png", width, height, "float-left", label: "Query Configuration with Params and Test-Values")
    @fancybox.PreviewWithLightbox(App.Path + "/data/assets/sql-query-select-statement.png", width, height, "float-left", label: "SQL Query using Params")
  </div>
</div>

<hr>
<h2>Files from the root portal</h2>

<ul>
  @foreach(var file in rootFiles) {
    <li>@file.FileName</li>
  }
</ul>



<!-- unimportant stuff, hidden -->