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 ForumsEventsEventsFilter events by user selected date range?Filter events by user selected date range?
Previous
 
Next
New Post
7/29/2009 4:11 PM
 

I have a need to create a list view of events that is generated by what the user selects as a date range. 
I thought of using Advanced Data Grid or Reports module.   I was wondering if anyone had any tips or examples for something like this (the date selections)?

Thanks!

 
New Post
7/31/2009 6:53 AM
 

I would be very interested in something like that too...

 

Best,

 

Bart

 
New Post
8/5/2009 8:33 AM
 

While I continue to research how to do this can someone explain to me how to enter this feature as a new request in Gemini?  I created an ID but don't see this as an option when logged in.

Thanks...

 
New Post
8/5/2009 10:40 AM
 

Create it against DNN Core Framework and Modules (DNNP). It will then get moved to the right project.

Cheers
Roger


DNN MVP
Events - Get the latest version - Upgrade now!!
Feedback 6.4.2 - Now available - Give it a go!
Find us on Codeplex - DNN Events, DNN Feedback
Requirements/Bugs - Please submit them on Codeplex
 
New Post
8/12/2009 4:08 PM
 

I said I would post my solution when I found one so here it is.   Not yet complete but still helpful.
Thank you to Brian at Engage for his SQL help, and the TressleWorks PDF help file.

Using Tressleworks.ca SQLGridSelectView (SGSV) I was able to create a calendar view where the user could select a begin and end date and display a list of events in a grid.  There is no formatting applied yet.   So far that's all I have.   Here are the details.

Install SGSV module and place on a page.
Edit SGSV settings
Add this SQL to the SQL Statements box:  (add object qualifier if you have one and ModuleID is obtained from the URL for the Events->Settings page) 

SELECT EventTimeBegin, DATEADD(minute, Duration, EventTimeBegin), EventName, EventDesc
FROM Events
WHERE ModuleID=xxx

Expand Date Range Selections and use these settings:
Check box for "Enable"
Parm Name: Date
Prompt:  Select Date Range (yyyy-mmmm-dd)
From Date:  *** Use a resonable date or something not to far in the past***  (2009-jan-01)
To Date:  s;-1;MM/dd/yy
Clause:  EventDateEnd Between '[Date:From] and '[Date:To]'
Check box for "Show Calendars"

Optional items:
Under Processing Options I have selected "Display Reset" "Display Record Count" "Display Time Stamp"

 
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsEventsEventsFilter events by user selected date range?Filter events by user selected date range?


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