Data Aquarium Framework

Labels
AJAX(112) App Studio(9) Apple(1) Application Builder(245) Application Factory(207) ASP.NET(95) ASP.NET 3.5(45) ASP.NET Code Generator(72) ASP.NET Membership(28) Azure(18) Barcode(2) Barcodes(3) BLOB(18) Business Rules(1) Business Rules/Logic(140) BYOD(13) Caching(2) Calendar(5) Charts(29) Cloud(14) Cloud On Time(2) Cloud On Time for Windows 7(2) Code Generator(54) Collaboration(11) command line(1) Conflict Detection(1) Content Management System(12) COT Tools for Excel(26) CRUD(1) Custom Actions(1) Data Aquarium Framework(122) Data Sheet(9) Data Sources(22) Database Lookups(50) Deployment(22) Designer(178) Device(1) DotNetNuke(12) EASE(20) Email(6) Features(101) Firebird(1) Form Builder(14) Globalization and Localization(6) How To(1) Hypermedia(2) Inline Editing(1) Installation(5) JavaScript(20) Kiosk(1) Low Code(3) Mac(1) Many-To-Many(4) Maps(6) Master/Detail(36) Microservices(4) Mobile(63) Mode Builder(3) Model Builder(3) MySQL(10) Native Apps(5) News(18) OAuth(9) OAuth Scopes(1) OAuth2(13) Offline(20) Offline Apps(4) Offline Sync(5) Oracle(11) PKCE(2) Postgre SQL(1) PostgreSQL(2) PWA(2) QR codes(2) Rapid Application Development(5) Reading Pane(2) Release Notes(184) Reports(48) REST(29) RESTful(29) RESTful Workshop(15) RFID tags(1) SaaS(7) Security(81) SharePoint(12) SPA(6) SQL Anywhere(3) SQL Server(26) SSO(1) Stored Procedure(4) Teamwork(15) Tips and Tricks(87) Tools for Excel(3) Touch UI(93) Transactions(5) Tutorials(183) Universal Windows Platform(3) User Interface(338) Video Tutorial(37) Web 2.0(100) Web App Generator(101) Web Application Generator(607) Web Form Builder(40) Web.Config(9) Workflow(28)
Archive
Blog
Data Aquarium Framework
Thursday, March 22, 2012PrintSubscribe
Searching by First Letter

You would be lost while browsing the old fashion phone book or scrolling through the entries of your modern-day contact list on a smart phone without the alphabetical index of entries. A menu of first letters rendered on data pages provides similar productivity enhancement.

This screen shot shows the Search by First Letter enabled in a data view in a Code On Time web application.

Data view with enabled 'Search by First Letter' feature in a Code On Time web application

If you want to enable Search by First Letter, then select the project name on the start page of the web application generator and click Design. Expand a page node in Project Explorer and select the data view that will have the alphabetize search enabled. Toggle the “Search by First Letter” option and re-generate your application.

Property 'Search by First Letter' enabled in a data view

The “first letter” is a bit of a misnomer. The application will find distinct first characters in the first visible data field of type String. If more than one distinct character is detected then the sorted menu of characters is rendered above the “grid” views of the data controller linked to the data view.

'Search by First Letter' is represented by a menu of first characters in the first searchable string data field of a data view.

If a user clicks on a symbol then the data is automatically filtered according to the selection. The following screen shot show what happens if a user clicks on the latter “A” above the list of products in the Northwind sample. This selection activated “begins with…” filtering option on the first column of the gird view.

'Product Name begins with A' is the result of clicking on the first letter.

Users can accomplish the same end result by a selecting the filtering option from the context menu of the first column.

The alternative method of activating the 'Begins With...' filter

Search by First Letter is sensitive to the current set of user-defined filters. The following screen shot shows exactly the same list of products that belong to “Beverages” and “Seafood” categories. The number of symbols in the Search by First Letter menu is less than the number of symbols available when all categories allowed in the view. All filtering options in Code On Time web applications are adaptive.

Adpative nature of 'Search By First Letter'

Search by First Letter is also displayed on a data view that is configured to have “Search on Start”. This option can be enabled in the data view properties. You will find the check box below the “Search by First Letter” option.

Enabling data view properties 'Search by First Letter' and 'Search on Start' will result in the following presentation when users arrive to the Products page.

Users can remove the filter by clicking on the close button on the right-hand side of the filter description.

Alternatively, users can “mouse” over the filter element in the filter description area and have the filter removed with a single mouse click without affecting any other active filters.

Mouse click on the filter element in the filter details will remove the filter without affecting any other active filters

Friday, November 18, 2011PrintSubscribe
Project Explorer, Project Actions, Wizards, Action Column Scope

This release of Code On Time introduces new productivity tools. Project Explorer is designed to simplify the development process. The future releases will include further enhancements to the Project Explorer including full drag and drop support.

Some of the promised functionality is not included in the current release due to compatibility issues. We are working on a follow-up that will go out later this week.

Make sure to refresh the cache of your browser to load the latest version of the client library after you re-generate you web application.

Features and enhancements included in release 6.0.0.15:

  • Project Explorer and new Project Actions menu.
     
  • New action Status allows implementation of sophisticated Wizards.
     
  • Use Shift+F10 to open a context menu on the focused node in the Project Explorer.
     
  • Use F4 to toggle focus between the Project Designer and Project Explorer.
     
  • Significant improvements to the memory management. Integrated web browser has been leaking memory in previous released. The current version takes care of releasing the memory.
       
  • Mr. Zsolt Panka has contributed localization for hu-HU. Thank you!
     
    If you are creating Code On Time applications in languages other than English then please contribute your localizations. Read about localizing application here.
     
  • Code generator will eliminate empty containers in the pages of new applications.
     
  • Reports menu option is now created in single-schema projects only.
     
  • Actions with confirmations will automatically execute 'Select' command in grid view if Confirmation property is not blank.
     
  • Grid view now supports new action group scope “Action Column”. A column with conditional actions is rendered if action group with the scope is present.
     
  • Automatic printing of detail views include summary fields of the master record displayed under the report title in the filter details area.
     
  • Find "spyglass" and "refresh" buttons are rendered as "grey" and will show color if you hover over the link. Refresh button replaces "Refresh" link in the pager.
     
  • Client Library display a refresh icon instead of Refresh word in the page of the grid and data sheet view.
     
  • The project title is now displayed in the Title bar of code generator window.
     
  • Code generator will stop produce exceptions logged when a "copy" instruction is executed in some types of projects.
     
  • Azure Factory detects the most recent version of Azure SDK installed on computer. Previous version had a hard-coded reference to SDK.
     
  • DotNetNuke Factory correctly upgrades the project to Visual Studio 2010 if Visual Studio 2008 is not present.
     
  • Added CSS override for links in DNN 5.06.03.
     
  • Dynamic expressions default type is ClientScript to allow a single expression visibility on categories.
     
  • Status bar implementation is integrated in the application framework and designer.
     
  • Category visibility is now a property of the category. Visibility tab is not available anymore.
     
  • The height of SELECT elements is the search bar is now matching the height of the value input boxes.
     
  • Fixed the problem with Web.DataView._peformFieldChanged throwing an exception in Designer.
  • List of actions now shows When Client Script property.
     
  • New +/- buttons are now displayed on automatic search bars.
     
  • Compound labels of fields are now correctly handling Text Label Construction maps.
Tuesday, October 11, 2011PrintSubscribe
DotNetNuke Factory, Oracle Data Provider, Wizards

Code On Time has released a new update 5.0.0.72 with major features and enhancements.

Please see update notes below:

  • New code generation project DotNetNuke Factory creates application pages as controls with data views incorporated in a DotNetNuke module. Registered module can be configured by end users. You can integrate a line-of-business database application with a popular open source web content management system in minutes.
     
  • Added support for native Oracle.DataAccess client with full support for sequences on primary key fields. Primary key fields of integer type are expected to have sequences named after the name of the tables. For example , “CUSTOMER_SEQ” sequence is expected to match “CUSTOMER” table.
     
  • Projects generated from Oracle databases now recognize database views.
      Introduced "client-only" virtual Status field to support wizards. Support for new Status and None actions to allow easy implementation of Wizards. The tutorial will be available shortly.
     
  • Ajax Control Toolkit 50731 is now shipping with the code generation library.
        
  • RichEditor has been changed to support new HtmlEditorBehavior from Ajax Control Toolkit. Read more about the new rich text editor at http://stephenwalther.com/blog/archive/2011/08/01/ajax-control-toolkit-july-2011-release-and-the-new-html.aspx.
      
  • Action buttons displayed in forms are now automatically refreshed when data is changed.
    WhenClientScript property of actions can now reference values of fields by enclosing the field name in square brackets. For example [Status]. The same capability already exists in visibility expressions for categories and fields.
     
  • Numerous improvements to the message bar (yellow message at the top of the screen). It now takes up to 15% of the window height and starts scrolling when needed.
     
  • Sidebar boxes are fixed at the top of the screen if there in no horizontal scrolling.
     
  • Automatic resizing in multi-column forms is not performed anymore.
     
  • Adding a data field to a category will remove any bindings of the field that may exist in other categories of a view.
      
  • Designer automatically transfers properties of existing data fields when a field is defined in a new category or view.
     
  • Field validators are now using IDs to identify expressions in Project Designer.
     
  • Data Field visibility rules are now using IDs to identify visibility expressions in Project Designer.
      
  • Category visibility rules are now using IDs instead of header text as primary key. Category description is not mandatory in  the new release. Any characters can be used in the category header text.
     
  • Bread crumbs of many project items in Designer now include extended information.
     
  • Filters and sort order are restored in the grid/data sheet view if you select a record and then return back.
     
  • Filtering is automatically disabled on timestamp fields to prevent errors when users do Quick Find or try to apply a filter.
     
  • Presence of "onDemand" attribute was causing incorrect production of automatic reports. The issue has been resolved.
      
  • Fields with explicitly defined value/text items will correctly render on the search bar. Text of items is displayed instead of actual values.
     
  • If a field has explicitly defined value/text item pairs then the multiple-value filter will correctly display the values. The field will also correctly align as text (to the left) and will print in filter details.
      
  • Reports will print correctly item text when item value/text pairs are explicitly defined on a field level (0-Open, 1-Closed, 2-Pending). This applies only to .NET 4.0 projects.
     
  • Regex validators are invoked when a field value has changed.
     
  • Data access objects based on tables that have a primary key field name matching the table name will not result in compilation error.
     
  • New implementation of DataController.UserIsInRole takes an array of roles. Each value can be specified as a comma-separated list of roles or simple role name.
      
  • Fixed designer error "Can't execute code from a freed script".
     
  • Trimming of long words used in summary boxes has been improved to correctly process HTML tags, which was previously causing incorrect display of history.
     
  • Designer displays Up/Down options on field Items page.
     
  • Values of fields with "Format On Client" set to "False" will print correctly in reports.
     
  • Long standing problem with UTF-8 encoding not being applied generated filed has been resolved.
      
  • "_Mirror" fields supporting server side formatting have been improved to allow editing of field values.
     
  • Hidden primary keys are rendered as "hidden" inputs in insert mode.
     
  • Multiple value selection is passed correctly when action is executed from a modal form.
    Hidden, static, and read-only fields are now passed as "read-only" to updates performed in response to Batch Edit commands. This ensures that there will no exception "Object not found" with "audit" fields processing (ModifiedOn, ModifiedBy).
     
  • Generated *.designer.vb files are now using WithEvents in declarations of control fields.
     
  • .NET 3.5 web apps will display rounded corners in modal views.
     
  • Implemented Web.DataView.goBack() method in the client library to suppress cancelled requests to retrieve the child data sets when data controller URL parameters are used on complex master/detail pages.
     
  • Aliased fields are correctly displayed on automatic search bar if the field's Search Mode property is set to Required or Suggested.
       
  • Exception "Key not present in dictionary" now displays the name of the field that is no longer available in the data controller but referenced in its definition.
        
  • Code generator project file now supports “zip” mode when executing “copy” instruction.
     
  • Universal ProviderFactories variable lists all DB and Membership providers registered in machine.config of standard and 64-bit Microsoft.NET. ProviderFactories variable is now used to configure references to required external assemblies in web.config.
     
  • Button “Next” on the data controller summary now reads “Generate”.