News


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...

1. Appframe Updates - Release Notes

Updated: 06.08.2020 09.07.08

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 SummaryJuly 2020Added support ...

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 - Scheduler

Updated: 01.07.2020 11.51.05

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...

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...

2. Web - Appframe Data API

Updated: 01.07.2020 09.37.27

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 . ...

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...

Code modules - Code Modules

Updated: 17.06.2020 06.50.18

Code modules usually are used as route handlers. Examples bellow are created using Pims R4 Minimal example of code module Response type will be text/html. Route will be available public. using Appframe.Web.Context; using Appframe.Web.Registries.Attributes; using Appframe.Web.RouteHa ...

Read more...

Graph API - Web App

Updated: 12.06.2020 05.32.40

Pims R4 Dev Web App The Web application in Pims R4 Dev with id: msgraphapi uses the Microsoft MSAL library to integrate with Microsoft Graph API. Setup is required On load the app will try to authenticate and show an Office365 Popup to the user, if the user is authenticating against with Pims R4 wit ...

Read more...

Graph API - Setup

Updated: 12.06.2020 05.26.14

When you have a code module that will interact with Microsoft Graph API you need to register an application in Microsoft Azure AD, set permissions and choose if the integration should be "on behalf of a user" or by then end user logged in to Pims (requires that the end user in Pims is authentication ...

Read more...

5. Developer Tools - DB Updater v4

Updated: 12.06.2020 05.25.02

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...

Web Scheduler - Queues

Updated: 11.06.2020 13.58.35

Queues As mentioned in web scheduling article, queues deliver asynchronous trigger promise. So you should be able to do something from inside of the trigger in a deferred execution manner. So instead of executing some code in trigger directly, you insert data into a queue table. Data is then fetched ...

Read more...

Power BI - Web API Connect

Updated: 10.06.2020 08.17.14

Introduction Will set up Power BI to retrieve data from Web API and end result look similar to example picture below Setting up data source Clicking on "Get data ↓ " will open "Common data sources" From there select "Web". If in your Power BI Common data sources not ...

Read more...