Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsReportsReportsAbout Reports "Saltspring"About Reports "Saltspring"
Previous
 
Next
New Post
3/2/2009 5:06 PM
 

Andrew, you wrote in your blog:

Introducing a new Parameters framework which allows users to define custom SQL Parameters for their queries, which pull their value from various different sources (DNN Objects, Query String, Text Fields, etc.)

  • This framework would be extensible, so that new “Parameter Sources” can be installed, just as Data Sources and Visualizers are

Would this mean I can pre define a list of parameters the "user" can select or add a textbox wherer the usre can type a text, which will be used as a parameter in the query (which would be really great ;-)

Or are the parameters always from a query?

Thanks, Timo

 
New Post
3/12/2009 6:34 PM
 

I see the parameters framework working as follows (NOTE: I haven't finished designing it yet, so no guarantees :D):

On the Settings page, the module editor would add "parameters."  Each parameter would have a Name (i.e. "UserID" or "CustomerName") and a Source (i.e. "Current User ID" or "Text Field Prompt").  Some Sources have no UI, such as the "Current User ID" source which simply pulls the currently logged-in user ID.  Others, like "Text Field Prompt", would display a UI in the View page which allows the user to specify the value.  Additional "Sources" could be installed by SuperUsers.

Once the module editor has configured the list of parameters, they can be used by the Query.  Exactly how depends on the type of Data Source.  Essentially, every Data Source gets a Hash Table containing the Parameter Name and the associated Value.  The SQL Server Data Source, for example, would then prepend an "@" character to the front (i.e. "UserID" => "@UserID") and pass the Parameter Name and Value on to SQL Server.  An RSS Feed Data Source (purely an example, no current plans for such a data source, but anyone could make one :D) could use the parameters in the URL instead.

I think what you're looking for is the ability for the module viewer to select additional parameters to filter the query by.  I don't have plans to do this in "Saltspring" simply because I didn't think of it, but I don't think there's enough time to get it in for that version (I want to release it before I start at Microsoft in September :D).


Andrew Nurse
DotNetNuke Core Team Member and Reports Module Project Lead
Microsoft Certified Professional Developer

 
New Post
3/27/2009 1:25 PM
 

Andrew Nurse wrote


I think what you're looking for is the ability for the module viewer to select additional parameters to filter the query by.  I don't have plans to do this in "Saltspring" simply because I didn't think of it, but I don't think there's enough time to get it in for that version (I want to release it before I start at Microsoft in September :D).

Right, that's what I'm looking for :-D

Thanks, Timo

 
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsReportsReportsAbout Reports "Saltspring"About Reports "Saltspring"


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out