List design

satya - Wed Apr 04 2012 20:37:27 GMT-0400 (Eastern Daylight Time)

Example of a list implementation


Your name:
email:
your preferred location:
Do you prefer weekend or weekday:
Do you prefer (Beginner, Advanced, Medium):

satya - Wed Apr 04 2012 20:53:21 GMT-0400 (Eastern Daylight Time)

Another example


link short name
link long name
link description
link url
when was it published
who is the author

satya - Wed Apr 04 2012 21:00:09 GMT-0400 (Eastern Daylight Time)

a dictionary list example


word
category
meaning
list of
   sentence, author, when, where

satya - Sat Apr 07 2012 08:27:14 GMT-0400 (Eastern Daylight Time)

Content types are not folders

because I move documents much more loosely between folders. So folders are more like tags.

satya - Sat Apr 07 2012 08:27:30 GMT-0400 (Eastern Daylight Time)

a document can subscribe to multiple content types

a document can subscribe to multiple content types

satya - Sat Apr 07 2012 08:28:16 GMT-0400 (Eastern Daylight Time)

a folder can suggest a content type for its children

it is a mere suggestion. documents may carry with them their own content types as they move around folders and tags.

satya - Sat Apr 07 2012 08:32:05 GMT-0400 (Eastern Daylight Time)

a content type is or is a special case of a list

Majority of times a content type is just a list with a single row. You will know when I finally implement this.

satya - Sat Apr 07 2012 08:49:12 GMT-0400 (Eastern Daylight Time)

Integrate type-faces technology into main line aspire

Integrate type-faces technology into main line aspire. I have done this as an enhancement to data access before as a sub project. I need to bring that into the main line to provide adhoc java objects on the fly. Lot more meaningful than going from xml. Similar to Drupals render arrays the idea of "hds" in aspire can make this idea quite powerful, at least very utilitarian

satya - Sat Apr 07 2012 08:58:45 GMT-0400 (Eastern Daylight Time)

Here is a first rev of a table definition


CREATE TABLE [dbo].[t_list_definition](
   [id] [int] IDENTITY(1,1) NOT NULL,
   [f_list_key_name] [varchar](50) NULL,
   [f_list_display_name] [varchar](128) NOT NULL,
   [f_listdescription] [varchar](max) NULL,
   [f_listcomments] [varchar](max) NULL,
   [f_list_for_entity_type] [varchar](50) NULL,
   [f_list_for_entity_id] [int] NULL,
   [f_main_list_indicator] [char](1) NOT NULL,
   [f_filed_names] [varchar](256) NOT NULL,
   [f_def_sort_by_fieldnames] [varchar](128) NULL,
   [f_owner_user_id] [varchar](50) NOT NULL,
   [f_created_on] [datetime] NOT NULL,
   [f_last_updated_by] [varchar](50) NOT NULL,
   [f_last_updated_on] [datetime] NOT NULL
)

satya - Sat Apr 07 2012 09:58:38 GMT-0400 (Eastern Daylight Time)

Crystalized work 1


complete akclist object
  list of insert statements (2 hrs)
  select statement construction (2 hrs)
akcinserter part (4 hrs)
  take post
  get akclist
  getinserts
  insert them
Test the inserter (2 hrs)
  manually insert a list
  manually get the select statement
  see the row inserted

satya - Mon Apr 16 2012 14:20:05 GMT-0400 (Eastern Daylight Time)

List ownership types


1. Global - Independent list
2. Entity Owned - 
    belongs to an entity like document or a folder

satya - Sat Apr 28 2012 15:14:51 GMT-0400 (Eastern Daylight Time)

The basics are working now


able to insert a custom object
able to retrieve a collection of custom objects
AkcList definition is now nicely available as a java object
Some of the classes are
  AkcList
  ListInserter
  ListSelector
  AkcReader

satya - Sat Apr 28 2012 15:16:18 GMT-0400 (Eastern Daylight Time)

Next main task: UI for creating a list defintion


create a list definition
see all the list definitions
delete a list definition if needed
create a form to insert a custom object

satya - Wed May 16 2012 13:02:59 GMT-0400 (Eastern Daylight Time)

Provide a way to alter the list columns!

Provide a way to alter the list columns!

satya - Wed May 16 2012 13:20:17 GMT-0400 (Eastern Daylight Time)

Here is a fruitful use of this new facility: A registration form

Here is a fruitful use of this new facility: A registration form