Blog

Labels
AJAX(112) App Studio(7) 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(177) 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(8) OAuth Scopes(1) OAuth2(11) Offline(20) Offline Apps(4) Offline Sync(5) Oracle(10) PKCE(2) PostgreSQL(2) PWA(2) QR codes(2) Rapid Application Development(5) Reading Pane(2) Release Notes(179) Reports(48) REST(29) RESTful(29) RESTful Workshop(15) RFID tags(1) SaaS(7) Security(80) SharePoint(12) SPA(6) SQL Anywhere(3) SQL Server(26) SSO(1) Stored Procedure(4) Teamwork(15) Tips and Tricks(87) Tools for Excel(2) 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
Thursday, August 10, 2017PrintSubscribe
Simple Search With Super Powers

This is the simple search window in an app created with Code On Time. Enter a sample value in the search box and hit Enter key to locate the matching records. Tap outside to dismiss the search mode.

This effective and easy to use feature is gaining some super powers starting with the next release.

image

Search suggestions are presented to the user as the sample value is entered. Application framework builds a list of suggestions from the data currently loaded in the view to avoid costly server-side roundtrips.

image

Suggestions of previously searched criteria will be promoted in the matches as the user executes searches.

image

End users can limit search to specific fields by prefixing the search criteria with the first letters of the data field name separated from the search value with a “colon” symbol.

image

Users can enter complex phrases separated with “comma” to find their data.

image

“More” button on the right side of the input opens “Advanced Search” form to allow entering precise criteria with more finesse.

image

“Advanced Search” is also automatically activated when the data view is set to “Search On Start”. Tag the data view as “search-on-start-simple” if you want to keep “Simple Search” as the default search option.

image

End users switch from “Advanced Search” back to “Simple Search” by selecting “Show Less” in the context menu.

image

Friday, July 21, 2017PrintSubscribe
Addendum for 8.6.5.0 Release Notes

Some additional information is available below on the fixes and new features present in release 8.6.5.0.

  • New Feature: Support for Report Viewer 2016. Microsoft Visual Studio 2017 RDLC editor automatically upconverts RDLC files to the latest format, incompatible with earlier versions of Report Viewer. Starting in 8.6.5.0, .NET 4.5 or 4.6 apps created on a computer with VS2017 installed will be prompted to automatically download Report Viewer 2016 Runtime and SQL CLR Types 2016. The required files will be copied into the ~/bin folder of the app.

  • New Feature: Support for Microsoft Graph OAuth Handler. Microsoft Graph offers a single API to offer Single Sign-On for users with a Microsoft, Windows Live, Office, Azure, or Azure Active Directory accounts. Simplified instructions are as follows:

    a. Add SiteContent to your app, if not already enabled. 
    b. Register your app at https://apps.dev.microsoft.com
    c. Copy the Application Id. This is your Client ID.
    d. Generate a new password. This is your Client Secret.
    e. Press “Add Platform”. Select “Web”. Enter the Redirect URL of “https://[yourwebsite]/appservices/saas/msgraph”
    f. Insert the following record to the SiteContent table:
        File Name: msgraph
        Path: sys/saas
        Text:
           Tenant ID: [TenantID or “common”]
           Client ID: [ApplicationID]
           Client Secret: [Press “Generate New Password”]
        Redirect Uri: [URL of site]/appservices/saas/msgraph        
           
    d. Append “Sync Roles: true”, save the record, reselect, and push “ADD SYSTEM IDENTITY” if you desire to synchronize groups from your Azure AD or Office system.       
    e. Open the login form. The button “LOGIN WITH MICROSOFT” will now be visible.

  • Corrected detection of Visual Studio 2017 and MSBuild tools in order to resolve compilation and publishing issues.

  • Apps with Active Directory Membership will no longer throw “asp_CheckSchema” exception.

  • “Membership uses standalone database” option will now stay selected.

  • BusinessRules.UserId will no longer throw an exception if the user is not logged in.

  • RowFilterOperation.IsEmpty and IsNotEmpty have been added.

  • Developers can now copy controller views onto pages in the Project Designer.

  • DotNetNuke projects compile correctly.

  • “Select All” option displayed in basket lookups.

  • Action “Select” with When Last Command Name of “Update” now works correctly in reopening the form after a record is updated.

Monday, July 17, 2017PrintSubscribe
July 2017 Hotfixes 2

Code On Time release 8.6.5.0 introduces the second collection of July hotfixes described below:

  • Added support for ReportViewer 2016.
  • Trust Origin URI specified for Report Viewer 2016 to ensure reporting DLLs loading correctly after being copied to another machine.
  • Windows Live OAuth Handler wrong redirect URI fixed.
  • App generator “User Interface” option now has "Touch UI + Classic" option. When "Touch UI" is set, no Desktop themes will be generated.
  • URL Hashing in HTML implementation is now fixed.
  • New projects will not permit “space” characters in the name.
  • Reports Viewer version is now a variable stored in the project file.
  • Fixed issues with Report Viewer version not detecting when generating from Project Designer.
  • Home page of the app generator displays the descending order of projects
  • Older ReportViewer references are removed from the VS project file.
  • ReportViewer DLL files are copied to the “bin” folder only when v14 is used.
  • Added MSGraphOAuthHandler implementation.
  • "Login with Microsoft" button appears on login page when MSGraph config entry is present in the site content.
  • Fixed exception in BusinessRules.UserId implementation raised when user is not logged in.
  • Added "IsEmpty" and "IsNotEmpty" to row filter operations. New options can be used in “soft” filters set on the server.
  • Fixed DotNetNuke Factory project compilation issues.
  • Touch UI: Fixed. Multi-select checkboxes are not cleared after Batch Edit.
  • Touch UI: New “Select All” option is displayed when more than one option is available for selection in a basket.
  • Touch UI: Keyboard navigation in the list scrolls the page when item is not visible.
  • Touch UI: Key “Right” goes to the lookup page after selecting “See All”.
  • Touch UI: Last focused field is recorded in the touch.lookup() method to correctly restore input focus when the lookup view is canceled.
  • Touch UI: Blank lookup field shows a popup when scrolled into view.
  • Touch UI: Removed excessive blank space in front of Add Item in empty basket.
  • Touch UI: Calendar is opened in correct position if the date input field has been scrolled into view in IE.
  • Updated app generator to use correct version of MSBuild for VS 2017, 2015, 2013, with MSBuild4.0 as fallback.
  • Touch UI: Command separator is displayed in popup with items for AutoComplete/Lookup.
  • Action with command name Select works correctly after command Update.
  • Fixed issue with Active Directory loading ASP.NET membership provider with no connection string.
  • Dropping/pasting controller view onto page will set the view as well.
  • Ensure "standalone database" checkbox is checked when membership dialog is loaded.
  • Fix for "asp_CheckSchema" exception with custom membership.
Continue to July 2017 Hotfixes