Difference between data viewer web part and content query web part in MOSS

Posted on 2010-01-12
Medium Priority
Last Modified: 2012-08-13
I understand that both the content query web part and the data viewer web part are OOB MOSS web parts.
I have a requirement that I need to display data from a list based on a particular filter condition.
e.g. display fields : Title, Content, Supplier Name, Category Name,Expiry date,Active flag and AttachementsFiles
from a list 'MyCustomList'
where supplier name ='ABC' and Expiry Date> Todays date.

Which OOB MOSS web part can do this?
Also what is a better approach to do such thing?Is creating a custom web part a good approach, because I think it can be done by OOB MOSS features.
Please help me out.
Question by:subhorachana
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions

Accepted Solution

aspehar earned 2000 total points
ID: 26298021
I can't speak to the content query webpart, but the dataview should work if you are looking to filter the view by a specific supplier name and a date greater than the current date.  A data view is easy to setup in SP Designer. See here for more info:
Data Views: http://office.microsoft.com/en-us/sharepointdesigner/HA100948041033.aspx
Adding a filter to a dataview: http://office.microsoft.com/en-us/sharepointdesigner/HA101030411033.aspx 

Expert Comment

ID: 26300815
In your case, I think you are looking for data views as the gentleman said above. And I am sure you can get your job done if you follow his instruction.
Here is a thing you may need to consider though.
If the lists you are intend to pull data from are nested in the same site, then every thing is OK. However, if the lists are in different sites under the same site collection. You need to know tools like SharePoint List Collection.
And if those list are located in other site collection, I think it will be very hard for you.    

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When installing SharePoint 2010 RTM I came across a strange error, I was getting timeouts during the installation. I searched the web and found the best solution to be found here (http://social.msdn.microsoft.com/Forums/en-US/sharepoint2010genera…
These days socially coordinated efforts have turned into a critical requirement for enterprises.
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question