wiki:qTopic

Version 6 (modified by chervol, 18 years ago) (diff)

--

qTopic

Build SmarFolder queries on custom catalogs

The idea of qTopic is to allow building SmartFolder queries on custom catalogs added to Plone site. We had to update atct tool to keep the track of all catalogs indexes and metadata, cause standard implementation supports only portal_catalog.

Example of Usage

Send newsletter with PloneGazette to custom set of CMFMembers

Starting conditions:

  • we have 'gazette' a Newslettertheme created in the root of site
  • we have several members for tests
  • we have set up group membership for members

We have to configure Smart Folder. Select member_catalog in the catalogs dropdown to edit searchable indexes list for it.

Add getGroups index, set Allowed Criteris to 'List of values' and 'Text'.

Then Switch to metadata tab and add getGroups, getFullname, getEmail columns to make them visible in SmartFolder view table or CSV file.

Adding 'subscribers' qTopic in the root of site. In our sample qTopic we will set working catalog to 'members_catalog'.

On the export scheme select 'Short Name','Full Name', 'Email'.

Now on the criteria tab set Sorting on Creation date and preview the data

On the 'export in csv' tab you will see

Now lets filter Groups to Administrators and Designers

Resulting set of Memebers will look this way

You can also export your data into CSV in one click clicking icon

The last step let add the custom list of subscribers to PloneGazete . Add new 'newsletter' to the gazette and check the send tab it should view the number of extra recipients, that we just generated with help of qTopic.

Attachments (10)

Download all attachments as: .zip