Difference between revisions of "Category:Grids"

Revision as of 09:03, 15 April 2024

Under Construction

Overview

Split Grid

Data Summaries

Searching Data

After enabling Search bar visible in the grid section attributes you can filter the data displayed in the rows selected by typing into the search bar then pressing Return/Enter.

Querying Data

Complex queries can be applied as filters to the data displayed using the built-in Query Builder.

Sorting Data

After enabling Sortable in the grid section attributes, clicking on a column header toggles between ascending and descending data order.

Dynamic Badges

Dynamic Spark Line Charts

Dynamic Spark Bar Charts

Dynamic Ratings

StringList Editor

Data Mapping

In the context of relational databases, a foreign key is a field in one table that uniquely identifies a row of another table. In simpler words, the foreign key is defined in a second table, but it refers to the primary key or a unique key in the first table. For example, a table called Employee has a primary key called employee_id. Another table called EmployeeDetails has a foreign key which references employee_id in order to uniquely identify the relationship between both tables.

The table containing the foreign key is called the child table, and the table containing the candidate key is called the referenced or parent table.

Data Mapping is the process of performing a two way mapping between the fields in the parent and child tables. This is accomplished by setting the Choices, Get Data Mapping and Set Data Mapping attributes for fields or grid columns.

Data Mapping is defined in the business rules for a column of a table. It works across Desktop, Web and Mobile Apps.

This functionality reduces coding in Apps dramatically.

As mentioned above you define data mapping in the Active Data Dictionary.

When the table is open data mapping is automatically handled in the UI in Desktop and Web Apps.

Business Rules

A business rule is a statement that imposes some form of constraint on a specific aspect of the database, such as the elements within a field specification for a particular field or the characteristics of a given relationship.

Business rules are defined using the Table Designer or in code using the alter table command.

There are a wide range of business rules which can be associated with tables and their columns. These business rules are active whenever a table is opened or bound to a UI element in Desktop, Web, Mobile or ODBC connections that use Lianja SQL Server.

These business rules are contained within the Active Data Dictionary for a table. Changes to these business rules do not require any changes to applications. When the applications are opened and the UI loaded with bound data, by default the business rules are inherited from the Active Data Dictionary.

You can restrict what data is entered by a user using validation, input masks, choicelists and much more.

MetaData

When you associate metadata with tables or columns, you typically define UI attribute names and values. Wherever the table or column is used in any App when the table is opened, the metadata is read and the attributes are then applied to the UI element.

Changes to the metadata are automatically applied across all Apps. No code changes are required.

This provides a powerful means of data binding with associated business logic all without coding. You define metadata for databases, tables, and columns using the MetaData Editor which is integrated into the Table Designer.

Desktop Browse

The browse command is a favorite with Visual FoxPro developers for building desktop applications.

LianjaScript has an enhanced version of browse with split grid editing and many of the features described in above. With business rules defined in the data dictionary for a table and its columns, browse can be used in desktop applications without compromising data integrity.

Example usage:

browse table southwind!employees splitbar title "Employees" ;
properties "showsplitedit=true;splitmemolist=notes;splitimagelist=photo"

Embedding Desktop Browse in a Custom Section

In desktop Apps you can embed a browse command in a custom section.

Add a custom section to a page then in the custom BROWSE command attribute type:

browse table southwind!employees title "Employees"