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(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(183) 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(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
Tuesday, September 20, 2016PrintSubscribe
Data Field Search Options Index

The Search Options data field property restricts and reorders the search options available to the end user on the Advanced Search Bar.

Employees grid view with advanced search bar. Birth Date search options are visible.

The search options available are dependent on the field type.

Below is a table of all search options and their description.

Numeric Filters
Search Option Text Description
= Equals The search will find exact matches of the parameter
<> Does Not Equal The search will exclude all exact matches of the parameter
<= Less Than The search will include all results that are less than the parameter
>= Greater Than The search will include all results that are greater than the parameter
$between Between The search will include all results that are between two parameters
$in Includes The search will include all selected parameters (will open a modal window to select items)
$notin Does Not Include The search will exclude all selected parameters (will open a modal window to select items)
Text Filters
Search Option Text Description
= Equals The search will find exact matches of the parameter
<> Does Not Equal The search will exclude all exact matches of the parameter
$beginswith Begins With The search will find all matches that begin with the parameter
$doesnotbeginwith Does Not Begin With The search will exclude all matches that begin with the parameter
$contains Contains The search will find all matches that contain the parameter
$doesnotcontain Does Not Contain The search will find all matches that do not contain the parameter
$endswith Ends With The search will find all matches that end with the parameter
$doesnotendwith Does Not End With The search will exclude all matches that end with the parameter
$in Includes The search will include all selected parameters (will open a modal window to select items)
$notin Does Not Include The search will exclude all selected parameters (will open a modal window to select items)
Logical Filters
Search Option Text Description
$true Yes The search will find all results that equal “True”.
$false No The search will find all results that equal “False”.
Date Filters
Search Option Text Description
= Equals The search will find exact matches of the parameter
<> Does Not Equal The search will exclude all exact matches of the parameter
< Less Than The search will include all results that are less than the parameter
> Greater Than The search will include all results that are greater than the parameter
$between Between The search will include all results that are between two parameters
$in Includes The search will include all selected parameters (will open a modal window to select items)
$notin Does Not Include The search will exclude all selected parameters (will open a modal window to select items)
$tomorrow Tomorrow The search will find all results that match the day preceding the current date.
$today Today The search will find all results from the current date.
$yesterday Yesterday The search will find all results that match the day after the current date.
$nextweek Next Week The search will find all results that match the week preceding the current week.
$thisweek This Week The search will find all results from the current week.
$lastweek Last Week The search will find all results that match the week after the end of the current week.
$nextmonth Next Month The search will find all results that match the month preceding the current month.
$thismonth This Month The search will find all results from the current month.
$lastmonth LastMonth The search will find all results that match the month after the end of the current month.
$nextquarter Next Quarter The search will find results that match the quarter after the current one.
$thisquarter This Quarter The search will find results that match the current quarter.
$lastquarter Last Quarter The search will find results that match the quarter before the current one.
$nextyear Next Year The search will find results that match the year after the end of the current one.
$thisyear This Year The search will find results in the current year.
$yeartodate Year To Date The search will find results from the beginning of the current year up to the current date.
$lastyear Last Year The search will find results that match the year before the beginning of the current one.
$Past Past The search will find all results before the current date.
$Future Future The search will find all results after the current date.
$quarter1 All Dates In Period: Quarter 1 The search will find all results in the first quarter.
$quarter2 All Dates In Period: Quarter 2 The search will find all results in the second quarter.
$quarter3 All Dates In Period: Quarter 3 The search will find all results in the third quarter.
$quarter4 All Dates In Period: Quarter 4 The search will find all results in the fourth quarter.
$month1 All Dates In Period: January The search will find all results in the month of January.
$month2 All Dates In Period: February The search will find all results in the month of February.
$month3 All Dates In Period: March The search will find all results in the month of March.
$month4 All Dates In Period: April The search will find all results in the month of April.
$month5 All Dates In Period: May The search will find all results in the month of May.
$month6 All Dates In Period: June The search will find all results in the month of June.
$month7 All Dates In Period: July The search will find all results in the month of July.
$month8 All Dates In Period: August The search will find all results in the month of August.
$month9 All Dates In Period: September The search will find all results in the month of September.
$month10 All Dates In Period: October The search will find all results in the month of October.
$month11 All Dates In Period: November The search will find all results in the month of November.
$month12 All Dates In Period: December The search will find all results in the month of December.

 

The “All Dates In Period” search options will include intervals from five years ago to one year ahead.

There are also several modifiers that can be used to change the behavior of the data field.

Search Option Description
$autocompleteanywhere Auto complete in fields can be configured to search anywhere in field values, instead of using “begins with” matching.
$disableautocomplete Text search options will no longer offer auto complete capabilities.
$disablemultiplevalues The “Filter…” option under the column header will be removed – users will not be able to filter by multiple values.
$disablesamples Quick filtering samples under the column header will be removed.
$quickfind Will exclusively filter fields tagged with “$quickfind” when using Quick Find.
$quickfinddisabled Will exclude fields tagged with “$quickfinddisabled” when using Quick Find.
Tuesday, September 20, 2016PrintSubscribe
Wizards in Touch UI

Commonly, multiple screens are connected and the user is required to page through these forms in order to complete their task. This pattern of presentation is called the “Wizard”. Starting with release 8.5.11.0, it is possible to create wizards in Touch UI. The picture below shows an example of a Create Employee Wizard in the Northwind sample database.

Sample New Employee wizard.

Each step of the wizard contains one or more categories. If all categories belonging to a particular step are rendered invisible via the Visible When property, then that step will be hidden.

Let’s implement the wizard shown above.  Start the Project Designer. In the Project Explorer window, switch to Controllers tab. Double-click on “Employees / Views / createForm1 / c1 – New Employees” category.

Selecting the category 'c1' in createForm1 of Employees controller.

Make the following changes and press OK to save:

Property Value
Header Text General Info
Description Enter employee general information below.
Wizard General

Next, let’s create several new categories. Right-click on “Employees / Views / createForm1” and press “New Category”.

Creating a new category in createForm1 view of Employees controller.

The second category will display in a new column alongside the previous category in the first step of the wizard.

Property Value
Header Text Contact Info
Description Enter employee contact information below.
New Column Yes
Wizard General

The next category will have the following configuration. Note the use of curly brackets wrapping field names. These will be replaced by the value of the field at runtime.

Property Value
Header Text Address
Description Enter the home address of {FirstName} {LastName} below.
Wizard Address

The last category representing the final wizard step is configured below. Notice that the Visible When property is configured to hide the category when the Title field is equal to the value “President”.

Property Value
Header Text Employee Info
Description Enter {TitleOfCourtesy} {LastName}'s employee information below.
Wizard Employee
Visible When
$row.Title != 'President'

Any categories that do not have a “Wizard” property assigned will be displayed on every step, either above or below the wizard content, depending on the position of the category relative to the first wizard category.

Rearrange the data fields as presented in the picture below using drag & drop.

The correct position of Employees data views for the Create Employee Wizard.

On the toolbar, press Browse to regenerate the app. Once generation is complete, navigate to the Employees page and create a new employee.

The correct position of Employees data views for the Create Employee Wizard.

Notice that a Status Bar has automatically been defined. The “Prev” and “Next” actions have been automatically injected into the form action group. Enter some values for the fields, including specifying “President” in the Title field.

Entering 'President' will hide the only category representing the 'Employee' wizard step, therefore hiding that step.

Notice that the “Employee” tab has been removed from the Status Bar. By pressing “Next”, the Address wizard step will be displayed. The field names surrounded by curly brackets have been replaced with the field values defined by the user.

The category description contains field values.

Note that when using custom form templates, wizards can be defined by encapsulating each step by a container of type “wizard”, containing the attribute “data-wizard-step”. The value of the attribute will be displayed in the status bar. See a simplified example below:

<div data-container="wizard" data-wizard-step="General">
    <div data-container="collapsible" data-header-text="General Info">
        ...
    </div>
    ...
</div>
<div data-container="wizard" data-wizard-step="Address">
    ...
</div>
Thursday, September 15, 2016PrintSubscribe
Calculating Values with C#/Visual Basic Business Rules

It is a common requirement for forms of the application to feature a custom calculation or operation that must be triggered by the user pressing a button visible on the screen.

For example, let’s use the Orders page of the Northwind sample project. It may be useful to have an action that will mark the order as shipped by populating the Shipped Date field, and setting a default value for Freight if it has not been specified.

The orders form has a "Mark as Shipped" button.

The first step is to add an action to the form scope that the user will be able to press to trigger a business rule.

Start the Project Designer. In the Project Explorer, switch to the Controllers tab. Right-click on “Orders / Actions / ag2 (Form)”, and press New Action.

Adding a new action to the form of Orders controller.

Set the following properties:

Property Value
Command Name Custom
CommandArgument MarkAsShipped
Header Text Mark as Shipped
When Last Command Name Edit

Press OK to save the new action.

Next, let’s create a business rule that will perform the calculations. Right-click on “Orders / Business Rules” node, and press “New Business Rule”.

Adding a new business rule to Orders controller.

Specify the following values so that the business rule will be triggered by the action created above.

Property Value
Type C# / Visual Basic
Command Name Custom
Command Argument MarkAsShipped
Phase Execute

Press OK to save the business rule. On the toolbar, press Browse to regenerate the application and ensure that the rule file is created.

When generation is complete, press “Edit Rule” on the action bar. This will open the business rule in Visual Studio.

Replace the contents of the file with the following code.

C#:

using System;
using System.Data;
using MyCompany.Data;
using MyCompany.Models;

namespace MyCompany.Rules
{
    public partial class OrdersBusinessRules : MyCompany.Data.BusinessRules
    {
        
        /// <summary>
        /// This method will execute in any view for an action
        /// with a command name that matches "Custom" and argument that matches "MarkAsShipped".
        /// </summary>
        [Rule("r100")]
        public void r100Implementation(OrdersModel instance)
        {
            instance.ShippedDate = DateTime.Now;
            if (!instance.Freight.HasValue || instance.Freight == 0)
                instance.Freight = 13.5m;

            PreventDefault();
        }
    }
}

Visual Basic:

Imports MyCompany.Data

Namespace MyCompany.Rules

    Partial Public Class OrdersBusinessRules
        Inherits MyCompany.Data.BusinessRules

        ''' <summary>
        ''' This method will execute in any view for an action
        ''' with a command name that matches "Custom" and argument that matches "MarkAsShipped".
        ''' </summary>
        <Rule("r113")>
        Public Sub r113Implementation(instance As OrdersModel)
            'This is the placeholder for method implementation.
            instance.ShippedDate = DateTime.Now
            If Not instance.Freight.HasValue OrElse instance.Freight = 0 Then
                instance.Freight = 13.5D
            End If
            PreventDefault()
        End Sub
    End Class
End Namespace

The code will set the ShippedDate field to the current date and time. It will then check if Freight has a value, and if the value is equal to 0. If so, then the Freight will be set to the decimal number 13.5. Finally, PreventDefault() is called in order to prevent the form from navigating back to the grid.

Save the file, and refresh the web browser. Navigate to Orders page and edit a record. Notice that the “Mark as Shipped” action is now available. Pressing this action will now populate the Shipped Date with the current date and time. If the Freight field was empty, then it will be set to $13.50.

Pressing the "Mark as Shipped" button has set the value of both ShippedDate and Freight fields.

Continue to Data View Fields