Assistant Creator

2.27.13

  • New tool creation consists of the creation of the following
    • Integration of existing tables
      • User (required)
      • Roles (required)
      • Other tables from other tools
    • Creation of additional tables
      • Create tables as data-dictionary style items
        • Columns can be visible or hidden
        • Columns can be editable or not
        • Columns can have JavaScript associated with them
        • Tables can be published to other tools or private
          • Read/Write
          • Read only
    • Draw links between tables to establish relations
    • Queries
      • Each Query is a button
      • Each query contains SQL statements
      • Queries are initialy run as tests, where the result goed into a text box
      • Publishing a query
        • Creates a entry in the database that has an owner, a name, and some xml metadata.
      • Once a query is “published”, the results go into a data grid
        • Sortable
        • Exportable to Excel
        • Some level of charting
      • Published queries are created  are represented as a set of buttons or combobox
  • Tool Usage
    • Table launches with a default query, that produces a read/write datagrid that is built based on the table description (from creation, above)
    • Goal is very Excel-like behavior, with JavaScript formulas
    • Formulas are not visible in this mode.
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: