To build applications with Evolutility the minimal set of required elements in the metadata are:
one form, one data, several panel, and many field.
This is enough to describes a simple CRUD (Create, Read, Update, Delete) application including all the necessary web forms for searching, viewing,
editing, deleting and exporting the data in a DRY (Don't Repeat Yourself) way.
dbcolumnicon
Name of the database column containing the item icon file name.
Example: dbcolumnicon="icon"
dbcolumnlead
Database column used as record identifiyer for the user (not the primary key).
Example: dbcolumnlead="LASTNAME"
dbcolumnpk
Name of the primary key column used as record identifiyer.
Example: dbcolumnpk="ID"
dbcolumnuserid
In multiple-users environment, specify the column name of the “who is
column” designing the specific user author of the record. Default is UserID.
dbcommentsformid
<for future enhancements>
userpage
Page name for the user profile information.
dborder
List of column names to include in the "order by" SQL clause. It is the default
sort option.
dbtable
Name of driving table for the component.
dbtablecomments
Name of the table to store comments for this component. This table can be
shared between components.
dbtableusers
Name of the user table which should have the following columns "ID", "login",
and "password". This property is only used if splogin
is not set.
dbwhere
SQL where clause to limit the dataset manipulated, must use the alias "T" for the driving table.
Example: dbwhere="T.publish=1"
entities
Plural for entity. Default value = "items".
entity
User's object name for the database object (for example: "contact" for the
AddressBook application). Default value = "item".
icon
Filename of the component icon (same one for all records).
Example: icon ="memo.gif"
spdelete
Name and parameters of the stored procedure for deleting records (or flagging them as deleted).
spget
Name and parameters of the stored procedure for loading a specific record.
Example: spget="EvoSP_Get @itemid" or
spget="EvoSP_Get @itemid, @userid"
splogin
Name and parameters of the stored procedure for checking users login and
password.
Example: splogin="EvoSP_Login @login, @password"
sppaging
Name and parameters of the stored procedure for paging search results.
Example: sppaging="EvoSP_PagedItem @SQLselect,
@SQLtable, @SQLfrom, @SQLwhere, @SQLorderby, @pageid, @pagesize"