Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 802
  • Last Modified:

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

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.
1 Solution
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 
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

Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now