Web Application Generator

Blog
Web Application Generator
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.

Thursday, June 8, 2017PrintSubscribe
Announcing Advanced Search 3.0

We are pleased to announce the new feature of Touch UI called Advanced Search 3.0. This feature is re-introduced with many new capabilities and complete customization support.

If option “Search On Start” is enabled in the view, then an automatically constructed Advanced Search window is displayed.

image

Users can collapse the search form into the standard Quick Find search.  Button “more” will activate Advanced Search from Quick Find mode.

image

Dedicated filtering options of the data columns will display a “single field” advanced search form with a variety of filtering options.

image

Users can search across many fields and create multiple matching groups for complex searches.

image

Sophisticated type-specific data filtering options are automatically displayed.

image

Automatically constructed Advanced Search survey forms are controlled by field properties described at http://codeontime.com/learn/data-controllers/data-fields/search-mode and http://codeontime.com/learn/data-controllers/data-fields/search-options/overview.

Don’t forget that completely custom search forms can be designed. Next week we will publish new videos dedicated to search customization on our YouTube channel at https://youtube.com/codeontime. Stay tuned!

The release 8.6.3.0 will be out any day now. We are working tirelessly on getting it out.

Tuesday, February 28, 2017PrintSubscribe
Data Field Tag: Overview

The data field Tags property is a space-separated list of values used by the client library to automatically add enhanced functionality at run-time. The table below shows available values and their related function.

Value Function
action-call
action-call-disabled
Will render a Call action to activate the device’s dialer application to make a call to the field value. The “disabled” tag will disable the automatic Call action.
action-email
action-email-disabled
Will render an Email action to open the device’s emailing application to send an email to the field value. The “disabled” tag will disable the automatic Email action.
action-url
action-url-disabled
Will render a Link action to treat the field value as a URL. The “disabled” tag will disable the automatic URL action.
calendar-date The primary date field to be used for Calendar presentation style.
calendar-end The “end” date field to determine date range in Calendar presentation style. In forms, will also configure the calendar input to automatically jump to this field from the “calendar-date” field and only allow date values in the future relative to the “calendar-date” field to be selected.
calendar-color The value field that will assign colors to each record.
calendar-text The field will be used as the primary displayed text in an event in Calendar presentation style.
calendar-disabled Will disable calendar presentation style processing for this field.
calendar-input-disabled Will disable calendar input control for this field in Touch UI.
calendar-input-data-none Will disable automatic query of record counts displayed in the calendar input control.
calendar-input-future Only allows selecting date values in the future.
created-coords When a new record is created, the geolocation will be requested from the browser and saved into the field in the form “[latitude],[longitude]” (without brackets or quotation marks).
created-latitude When a new record is created, the latitude will be requested from the browser and saved into the field.
created-longitude When a new record is created, the longitude will be requested from the browser and saved into the field.
data-sheet-freeze The data field will be “frozen” when in second generation data sheet view. The user can still unfreeze the column by activating “Unfreeze” option in the column header dropdown.
header-image-original If the field is a BLOB, will render image as header in full quality.
header-text The value of this field (in grid1) will be displayed as the header in Touch UI forms.

hierarchy-parent

The foreign key data field will be used as the parent when creating and rendering a hierarchy in second generation data sheet view. Examples include: ManagerID, ReportsTo.
lookup-details-hidden Hides the lookup reference arrow in the user interface.
modified-coords When a record is modified, the geolocation will be requested from the browser and saved into the field in the form “[latitude],[longitude]” (without brackets or quotation marks).
modified-latitude When a record is modified, the latitude will be requested from the browser and saved into the field.
modified-longitude When a record is modified, the longitude will be requested from the browser and saved into the field.
lookup-details-hidden Will hide the lookup details arrow from the user to prevent direct access to the lookup record.
map-latitude
map-longitude
map-address
map-state
map-city
map-region
map-postalcode
map-zipcode
map-zip
map-country
Use both “map-latitude” and “map-longitude”, or at minimum “map-address” and “map-city” in order to enable Map presentation style in Touch UI.
map-none Will disable map processing for this data field.

Tags are also used to configure the Chart presentation style. All chart tags start with the keyword “pivotX”, with X being the ID of the pivot. Learn more about how to format chart tags.

These keywords must be combined with dashes “-” to form a tag. Note that keywords with “X” require an integer value replacing the X. If not specified, the default value is 0.

Note that keywords can be split into multiple tags. For example, specifying “pivot1-row1-area” will be equivalent to “pivot1-row1 pivot1-area”. Do not specify duplicate keywords for the same pivot.

Some keywords support specifying a string value. This keyword must be the last keyword of the tag. Format these keywords like the following:

pivot1-title:"This is the title"

The table below enumerates the available keywords.

Keyword Function
pivotX The integer value X determines the pivot ID that the properties will be applied to.
rowX The data field will be used as a row. The index of the row is X.
colX The data field will be used as a column. The index of the column is X.
valX The data field will be used as a value. The index of the value is X.
area
areastacked
bar
barstacked
candlestick
column
columnstacked
candlestick
donut
geo
map
line
pie
pie3d
scatter
table
This keyword determines the chart type. If this keyword is not specified on at least one tag referencing pivot X, then the pivot will not be rendered as a chart.
small
medium
large
Determines the default size for the chart in the user interface.
topX Only the top X number of rows or columns will be kept. The rest will be hidden.
other When used in combination with “topX”, the hidden rows or columns will be collapsed into an “Other” row or column.
date This keyword, used on a DateTime data field, will compose multiple pivots with different configurations. The pivots tested are: year, year/quarter, year/month, year/month/weekofyear, year/month/day. The pivot with the number of rows closest to 25 will be selected for use.
sum
min
max
avg
count
These keywords will determine the value that will be used when calculating cells.
timeofday
second
minute
halfhour
hour
day
dayofweek
weekofmonth
week
weekofyear
twoweek
month
quarter
year
These keywords determine the date bucket mode. The DateTime value will be parsed and use the relevant part of the date.
all Lookup data fields will select all distinct values from the database and ensure that all possible lookup values will be present in the row or column. DateTime data fields will make sure that each bucket between the first and last row or column will be present.
hideblank The “blank” row or column will be hidden.
sortasc
sortdesc
sortascbyval
sortdescbyval
Use the “sort” keyword to determine the sorting order for values of this row or column. Specify “sortasc” or “sortdesc” to sort the row or column alphabetically or numerically. Specify “sortascbyval” or “sortdescbyval” to sort the rows or columns numerically by the value itself.
maximize The chart will take the full allocated space in the view. Axis labels and titles will be displayed inside the chart area.
crosshair Crosshairs will be enabled for the supported graphs.
title
haxistitle
vaxistitle
Specify a string value to set the relevant title text.
format Specifies an ICU Decimal format string.  Supported .NET-compatible formats are “c”, “C”, “d”, “D”, “e”, “E”, “f”, “F”, “n”, “N”, “p”, “P”, “x”, “X”. 
region Specify a string value to set the region mode for “geo” chart.
displaymode Specify a string value to set the display mode for “geo” chart.
resolution Specify a string value to set the resolution for “geo” chart.
curve Enables curvature in the “line” chart.
explorer Enables zooming and panning in the “line” chart.
maptype Specify a string value to set the Map Type in “map” chart type.
enablescrollwheel Enables the scroll wheel for zooming in “map” chart type.
usemaptypecontrol Enables the Map Type control in “map” chart type.
pointshape Specify a string value to set the point shape.
pointsize Specify a value to set the point size.
orientation Specify a string value for the orientation of the chart.
animation Enables the loading animation.
grandtotal Will show a “Grand Total” row and column for the pivot. Not suggested to be used in conjunction with a chart.