News


5. Developer Tools - DB Updater v4

Updated: 28.09.2020 08.56.47

Overview Updater v4, formerly known as Namespace deployer, is available in R4 systems since 22 April 2020. This means that it is possible to subscribe to updates from other databases by subscribing to individual namespaces. Namespace can be applied to these objects in Appframe: ...

Read more...

1. Appframe Updates - Release Notes

Updated: 11.09.2020 08.37.52

Overview An overview of changes to a specific release can be found here: Workflow Items Register Use the Milestone column to filter out items related to a specific release. Appframe milestones are named by year and week number "AF YY.WW" ie. "AF 20.17" Release SummaryAugust 2020.NET Framew ...

Read more...

Controls - Data grids

Updated: 10.09.2020 06.15.31

There are 2 grid types. data-grid and data-grid2. Main difference is that data-grid supports column width in percent's and data-grid2 only allows column width defined in pixels. Also data-grid2 has more functionality available. Common options Both grids can be editable, there needs to be proper ...

Read more...

2. Web - Appframe Data API

Updated: 03.09.2020 12.01.06

The Appframe Data API can be used to perform CRUD operations on all views and to execute procedures available to the af_user role in the database . ...

Controls - Report launcher

Updated: 03.09.2020 06.03.44

Usedata-report="someReport" to launch report filter control, where you can create custom filter and download report in pdf/xls format. Markups data-report-title="Report Title" - sets modal title. data-report-filter="Age > 18" - sets default report filter. data-report-launcher="false" ...

Read more...

Controls - Filtering and sorting

Updated: 03.09.2020 06.03.37

Search Add data-search to an input element to get automatich search. As long as the input element is located inside a binding-scope you will (when typing in the searchbox) get a filter-string saying that 'SearchColumn like '%searchfor%', and a dsDataSource.refreshDataSource(); will be executed. ...

Read more...

5. Developer Tools - DB Updater V3

Updated: 01.09.2020 07.09.43

R4 systems from 2019-07-18 is switched to use new sql updater and it will provide system updates until 2020-04-22.After 2020 April 23, you should use new v4 updater, former namespace deployer. Before you begin Make sure that database is fully updated with old updater. Last updates deployed were on ...

Read more...

Web Scheduler - Scheduler

Updated: 28.08.2020 11.05.28

Web Scheduling is hosted on web backend. It allows for executing predefined jobs. The easiest way to define your job is using code modules. But you do not need to do that if stored procedure execution is enough for you. You can use Appframe built-in jobs types like SQLProcedure or QueueProcessor. Bel ...

Read more...

6. Setup and configuration - Update win projects to new .NET Framework version

Updated: 25.08.2020 07.18.47

OverviewAs support has ended for .NET Framework 4.5, Appframe has been upgraded to new .NET Framework versions.Winforms and assemblies used in winforms development has been upgraded to .NET 4.6.1 and assemblies used on web has been upgraded to .net 4.8. Refer todocs.microsoft.comfor more details on c ...

Read more...

5. Developer Tools - Translations Omega365

Updated: 10.08.2020 13.00.28

Note 1 This article does not apply to Pims365. Translations and T-Tables There are two concepts for translations in Omega365. Translations and T-Tables. T-Tables are used for translating content inside tables. This Article does not describe T-Tables, see separate art ...

Read more...

Controls - Lookups

Updated: 06.08.2020 06.51.59

Usage Lookup can be used as advanced select list for your field. It can be used when need to change current row fields or used within list. It can be searchable, have custom buttons, have different sized columns and callback after row selection. To begin using you must create app ...

Read more...

Data Object - Extended methods/events

Updated: 14.07.2020 10.22.50

Methods dsObject.useOriginalFieldNamesInExport(true) - exporting data to excel column captions will be the same as original column names. dsObject.setExportedFileName(pFileName) - needs to be set before exporting data. File name should be pased without extension. To reset value pass null. E ...

Read more...

5. Developer Tools - SQL Templates Internals

Updated: 08.07.2020 13.12.05

SQL Template engine can be looked at as being with a small brain an a big heart. Where brain is sfnc_Database_SqlTemplate_FragmentParse and heart is sstp_Database_SqlTemplate_ExpandFragment. Brain is simple yet powerful. It is a text parser. Heart on the other hand is where all the pumping is done. ...

Read more...

5. Developer Tools - Database Manager

Updated: 08.07.2020 08.22.59

Database manager is Appframe alternative tool to Microsoft SSMS. It can be accessed by using url: /af-dbmanagerWhen using SSMS make sure you have setting enabled "Prevent saving changes that require the table to be re-created" . Otherwise changes might not be compatible with Updater. Microsoft ...

Read more...

Database Manager - SQL - parsing comments and issue ID

Updated: 07.07.2020 09.58.59

When creating or altering SQL object use comment above ALTER or CREATE statement. This line will be parsed as comment and added to object version. Also if comment consists of #12345 - # and five digits number it will be parsed as an issue ID. ...

Read more...

Components - Web Api R4

Updated: 02.07.2020 12.18.56

Introduction Appframe R4 provides a RESTful interface to its database and framework functionality. Built while strictly following the REST architecture and its constraints, even the commonly ignored HATEOAS constraint. Access via HTTPS, optionally using our .NET client library. Da ...

Read more...

Web Scheduler - Queues - System queue

Updated: 01.07.2020 11.42.37

System Queue is a specialized fail safe queue. You insert records into stbl_System_Queue and in turn SystemCallProcessor job will handle the message by calling static .net methods. Since This table is a regular queue table it does not have any views or triggers, so final users will never have access ...

Read more...

Code modules - Code Modules 365

Updated: 29.06.2020 07.44.35

Code modules in Pims365 Code modules usually are used as RouteHandlers, Data Import/Export and Jobs Examples bellow are created using Pims365 Minimal example of a RouteHandler A standard RouteHandler as of 2019 uses RouteHandlerBase instead of the previous ReusableRouteHandlerBase Like all good tut ...

Read more...

4. Flutter - 3. Appframe API Resources

Updated: 17.06.2020 18.32.20

Installation 1. Add dependency Add this to your pubspec.yaml under dependencies: appframe_api: git: url: 'https://981b027dc46f4c36e26ae91eeeb88e61af1e3321@github.com/Omega365/flutter-appframe-api.git' ref: 'v2.0.0' 2. Install it You can now install the package from the command ...

Read more...

4. Flutter - 1. Getting started

Updated: 17.06.2020 18.24.38

System RequirementsTo install and run Flutter, your development environment must meet these minimum requirements: Operating Systems: Windows 7 SP1 or later (64-bit) Disk Space: 400 MB (does not include disk space for IDE/tools). Tools: Flutter depends on these tools being available in your environmen ...

Read more...

6. Setup and configuration - Cookies explained

Updated: 17.06.2020 07.23.46

Appframe auth Cookies explained The below flow-chart outlines how the client (browser) and Appframe server interact relating to cookies. This is mainly to describe how Appframe works related to the new SameSite requirements and CSRF attacks. See bottom of diagram for 3 examples of how ...

Read more...