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

HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...how to show the recently added news or recently added blog entry to home similar to dotnetnuke.comhow to show the recently added news or recently added blog entry to home similar to dotnetnuke.com
Previous
 
Next
New Post
2/22/2010 2:04 AM
 

Please provide some example how you did this to show the blog entry from another page to home page

 
New Post
2/22/2010 4:21 AM
 

I am newbie, please tell me what query I should write (with example) to get the latest blog entry using report module so that I can solve my pupose. Please do answer me.

 
New Post
2/22/2010 11:53 AM
 

Use the following SQL in one of several grid display modules available:

select top 5
  '<a href="'+PermaLink+'">'+ble.Title+'</a>' as [Latest Blog Entries]
from
    blog_entries ble
    inner join blog_blogs bb on bb.Blogid = ble.Blogid
where
    ble.Published = 1
    and bb.Portalid = 2    -- change as needed
    and bb.[public] = 1    -- ensure blog is public
order by
    ble.AddedDate desc

Note: you will need to change the PortalID accordingly -- probably it's 1.   Also this report only the "Top 5", so adjust as needed.

You can see this code in action on my home page at www.tressleworks.ca

Examples of grid display module:

  • Reports module - part of the core
  • SQLView from DNNStuff.com
  • SQLGridSelectedView from Tressleworks.ca
  • SimpleQuery from Tressleworks.ca

Hope this helps,
Paul.

 
New Post
2/23/2010 8:17 AM
 

Hi Paul

Thanks for your kind reply.I also did in similar way and it is working fine. I have used XSLT visualizer as active visualizer and it is coming properly. Thing is that I want to display the announcement as well in the same way and it is coming also but to do this I had to add one more report module in the content pane (requirement is output must be displayed in content pane) to the page so now output is coming one below to other means at top output is for blog and its bottom output is for announcement. But I want to show it side by side means as inline in the content pane so how can I do this or if I can write two select statement query in one report module so that one select query's output will be for blog and another for annoncenment. So that I can format the out using XSLT If it is possible how can I do it please provide some example as you shown previously.

 
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...how to show the recently added news or recently added blog entry to home similar to dotnetnuke.comhow to show the recently added news or recently added blog entry to home similar to dotnetnuke.com


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