Monday, March 3, 2008

Cross Database TreeList Field

Sometimes we would like to have an opportunity to get data from another database in sitecore field. Since we already have source code of TreeList field on SDN, I decided to adjust it a little bit to have such opportunity.
To allow cross db usage I had to add one parameter to the source query of TreeList field.
It's SourceDatabaseName parameter.
Here is example how to get users from security database in TreeList field.
DataSource=/sitecore/users&SourceDatabaseName=security

Here is the way it looks:


To get rid of broken links in this field I had to MultilistCrossDbField which is intended to validate links correctly in LinkDatabase. So, don't forget to add the line below into /App_Config/FieldTypes.config file:

<configuration>
............
<!-- Custom fields -->
<fieldtype name="tree list cross db" type="Custom.Data.Fields.MultilistCrossDbField,TreeListCrossDB">
</fieldtype>
</configuration>

I added support for "query:" definition into this field. Now you can use either "/sitecore/content" or "query:/sitecore/content/*" as a data source for the field.

Here is Sitecore Package for the field.
Here is source code.

4 comments:

Lars Nielsen said...

Cool,

very cool

gabrielboys said...

Is this code still available? The links seem to be broken.

gabrielboys said...

Nevermind on this question, did not see it in the shared source library.

Ivan said...

You can get latest version from SDN. Here is the link: http://sdn5.sitecore.net/Resources/Shared%20Source/Shell%20Extensions/Cross%20Database%20TreeList%20Field.aspx