Example - Page List
Database Item List Sources
The Page List and other database item list content sources work using enhancements of the CMS core database item list derived classes, so support filtering and attribute selection in the same way as you could with a core Page List block, but with a lot more choice on what to actually list and how to display it. The edit dialog provides selection of any attribute or property to pull.
The current limitation is that these content sources do not respond to external filter blocks like the core Page List block can. So choice of solution depends on whether you need greater control over the basic list in UCP, or live filtering with the core blocks.
Universal Content Puller can pull from CMS core lists:
- Calendar Event Lists
- Express Item Lists
- Page Lists
- User Lists
Page List
We used a list of pages as an example in Example - SQL Data. However, in that example what we were really demonstrating was an SQL query. If you need an actual Page List, the example here is usually a far better way to achieve it.
The example below is a list of Universal Content Puller pages, sorted alphabetically with a link to each page, the date added and the page description. It uses the Page List content source, no transform and the List Picker content display.
Example - Protecting contact details
2020-03-25 15:26:11
Protect contact details from spammers by pulling a stack with AJAX.
Example - Responsive tables
2020-04-21 11:03:06
Pulling CSV data and displaying it as a table responsively
Example - Rotated Charts
2022-12-23 14:35:53
Displaying tabular data as a chart
Example - RSS Feed
2020-03-17 19:49:45
An example on pulling and displaying and RSS feed.
Example - SQL Data
2020-03-30 16:14:02
Enter a simple SQL select statement to retrieve data from the concrete5 site database.
User List
The User List content source works in a similar way, but is a bit boring as there is only one user on this site - JohntheFish.
JohntheFish
2018-06-01 19:19:22
Express Entity List
Like the User List, the Express List content source is a tricky one to demonstrate because there is no complex Express data on this site. All we have is the standard contact form, used in a demonstration of splitting a form into tabs, so not actually used for contacts.
Nevertheless, there is a bit of test data from myself and Nour. We also have some helpful spammers who have kindly left contact posts with some content that is not suitable for display. Hence the Express List demonstration below is limited to just First Name, Date and Subject pulled from contact form submissions. All easily picked in the UCP edit dialog. This time the content display is List Picker with a series of tables, heading left.
