collective.datagridcolumns

by Luca Fabbri last modified Oct 17, 2012 09:16 AM

Additional columns for Plone and DataGridField

Project Description

Introduction

This is an additional set of column types for DatagridField product for Plone.

New columns

TextAreaColumn

Like the base Column type, just display a textarea HTML element.

Additional parameters:

rows
Default: 3. Number of rows of the textarea.
cols
Default: 0. Number of columns of the textarea. If not provided the html cols attribute is omitted and an inline style "width: 100%" wil be used instead.

Example:

...
DataGridField('foo',
          columns=("type", "description"),
          widget = DataGridWidget(
                    columns={
                         'type' : Column(_(u"Type")),
                         'description' : TextAreaColumn(_(u"Description"),
                                                        rows=10,
                                                        cols=20),
                    },
         ),
),
...

SelectColumn

Like the default SelectColumn from DataGridField product, but explicitly support the vocabulary_factory way to provide vocabularies.

Additional parameters:

vocabulary_factory
Provide the name of a registered vocabulary using a Zope Component Utility. See the Archetypes Develop Manual for more.
vocabulary
As default SelectColumn, required only if you don't provide vocabulary_factory. Use this to call a method on the context to obtain the vocabulary.

Example:

...
DataGridField('foo',
          columns=("type", "description"),
          widget = DataGridWidget(
                    columns={
                         'type' : SelectColumn(_(u"Type"),
                                               vocabulary_factory='plone.app.vocabularies.PortalTypes'),
                         'description' : Column(_(u"Description"),),
                    },
         ),
),
...

Note: the base SelectColumn of DataGridField 1.8 already have some kind of support for Zope-3-like vocabularies, however the use of it is not clean (and this version also works on Plone 3).

ReferenceColumn

This is a complex column type that store an unique object "UID". The default view rendering of this column will display a proper link to the referenced object.

You can use this is different ways. In the simpler example, just use it as a textual column:

...
DataGridField('foo',
          columns=("uid", "comment"),
          widget = DataGridWidget(
                    columns={
                         'uid' : ReferenceColumn(_(u"Reference")),
                         'comment' : Column(_(u"Comment")),
                    },
         ),
),
...

So you are on your own to store a propert UID in the field (not very interesting, isn't it?).

If you want something more, you can enable an additional JavaScript module and you'll get an autocomplete feature of referenced objects:

...
DataGridField('foo',
          columns=("uid", "comment"),
          widget = DataGridWidget(
                    helper_js= ('datagridwidget.js', 'datagridautocomplete.js'),
                    columns={
                         'uid' : ReferenceColumn(_(u"Reference")),
                         'comment' : Column(_(u"Comment")),
                    },
         ),
),
...

So you will add to the default datagridwidget.js (automatically provided by the widget) a new datagridautocomplete.js ones.

When using autocomplete text field, you can query Plone in two different way:

  • starting a query with the "/" character will query documents by path, so you can manually surf the whole site.
  • starting as query with other character will perform a full-text query on titles.

This will required jQueryUI autocomplete. Please, read also the "Dependencies" section below.

Additional parameters:

object_provides
When using the full-text query, only return results of objects that provide those interfaces. Default is an empty list (no filter).
surf_site
Choose to be able to surf the site tree using a "/dir/dir/..." term. Default to True (allowed).
search_site
Choose to be able to search items in the site by full-text query or not. Default to True (allowed).

Dependencies

This product has been tested on Plone 3.3 and DataGridField 1.6. Tests and feedback with Plone 4 and DataGridField 1.8 are welcome!

jQuery

The ReferenceColumn need jQuery 1.4.1 or better to work. Plone 3.3 is shipped with jQuery 1.3. You can fix this dependency by your how, or using a 3rd party library.

An alternative Generic Setup import step ("DataGridField: register jQuery 1.4") is provided with the product. Run this and the default Plone jQuery version will be disabled, then a 1.4 version will be registered.

Do not run this on Plone 4!

jQueryUI

A column above need that Plone provide jQueryUI library. This product will not cover this requirement, even by dependency.

If you have already jQueryUI autocomplete behaviour in your Plone site, you are already ok.

If you need it, take a look at collective.jqueryui.autocomplete (or read it's documentation page to understand how cover this need).

Authors

This product was developed by RedTurtle Technology team.

RedTurtle Technology Site

Contribute!

You are welcome to help us, contributing and adding new columns!

Credits

Developed with the support of Regione Emilia Romagna; Regione Emilia Romagna supports the PloneGov initiative.

Self-Certification

[ ] Internationalized

[ ] Unit tests

[X] End-user documentation

[X] Internal documentation (documentation, interfaces, etc.)

[X] Existed and maintained for at least 6 months

[ ] Installs and uninstalls cleanly

[ ] Code structure follows best practice

Current Release
collective.datagridcolumns 0.3.2

Released Oct 17, 2012 — tested with Plone 3

Bugfix release
More about this release…

Download file Get collective.datagridcolumns for all platforms
collective.datagridcolumns-0.3.2.zip
If you are using Plone 3.2 or higher, you probably want to install this product with buildout. See our tutorial on installing add-on products with buildout for more information.

All Releases

Version Released Description Compatibility Licenses Status
0.3.2 Oct 17, 2012 Bugfix release More about this release…
Plone 3
GPL final
0.3.1 Jun 27, 2012 More about this release… final
0.2.0 Simpler to be used without collecctive.javascript.jquery and more extensible More about this release…
Plone 3
GPL beta
0.1.1 Bug fix release More about this release…
Plone 3
GPL beta
0.1.0 First release, tested on Plone 3.3 More about this release…
Plone 3
GPL alpha