24 November, 2008 · less than a minute to read
Use MOSS filter webparts with Data Viewer Web Part
One of my existing customers is currently trialling the Data Viewer Web Part in order to display the timetable from Facility CMIS. He was quite happy writing the SQL to retrieve it from the database, but wanted a quick and easy way to display it. He was delighted with how simple it was to retrieve the information for the logged in pupil by using a parameterised query with the pupil's Student ID was is stored in Active Directory.
For the staff though, he wanted them to be able to display a selected pupil's timetable and suggested using the MOSS filter webparts. I hadn't actually come across these before so did some investigation and decided it would be nice if the Data Viewer could be connected to them, and it didn't look too difficult. In the end it took longer than anticipated due to where in the web part lifecyle the connection was made, and how that interacted with the sorting and paging functionality, but now the Data Viewer Web Part can be connected to the MOSS filter web parts. The value from a filter web part can now be used in the parameterised SQL query, just like Active Directory attributes can.
Managing Director / Founder
Richard started SalamanderSoft in 2007 after a successful career as a software developer. Wanting to start his own company and with experience in integrating school systems he set out to build the best integration system for schools and to exceed customer expectations. He starting out on his own, doing all the coding, support and sales until finally the growing number of customers meant he needed to start growing the team. He is still heavily involved in coding the core Integration Suite product in addition to running the company and being the first point of contact for prospective customers.