Most Powerful Open Source ERP

Developer Documentation

Guideline ZSQL Method Is Lowercase And Uses Z Prefix And Underscore Separator

For consistent naming.

Guideline SQL Column Id Is Lowercase

To ensure consistency in SQL tables.

Guideline SQL Column Id Use Singular For Related Key

To ensure consistent SQL naming.

Technical Note on Catalog Uid Handling

Specifications of catalog uid handling

Quick Search Area

How the Quick Search Area works.

Technical Note on SQL Catalog Structure

showing the structure of the portal catalog SQL tables used in ERP5.

How To Edit Listbox Data Source

showing different ways to display data in a listbox from predicate to running custom catalog queries.

How To Add Custom Table to SQL Catalog

showing how to add custom tables to the SQL Catalog to more easily search for custom properties.

How To Create Related Keys

How To showing how to extend the CatalogTool from ERP5Catalog to add new search keys.

How To Search Portal Catalog

How To showing a tool that indexes all documents in a site, making it easy to search for documents.