As promised, we keep providing demos. Here is the latest PIQS (short for Play In Qodly Studio)
Since its release, ORDA has grown in popularity and is now widely used on your production servers.
With 4D v20, we provide two improvements on how ORDA requests are logged server-side:
- The first is an improvement of the request log that will now give more information about ORDA calls.
- The second is the addition of a server-side ORDA log similar to the client-side ORDA log. Let me introduce you to these new features.
Data Explorer allows you to view the data in your database. You can choose which fields to display, organize, filter, and sort the data.
With 4D v20, the Data Explorer can be opened in 4D instead of an external browser. Users can access the Data Explorer directly from the toolbar with just one click, saving time and improving productivity.
Retrieving the list of unique data elements is always helpful when manipulating data. In some cases, retrieving the number of occurrences of each value is essential. The distinct function of the Collection and Entity selection classes allows retrieving a list of unique values. With 4D v20, you can also retrieve the number of occurrences of each distinct value.
And that’s not all!
An object in the database can be used to save custom data entered by the user. So on the code side, you need to know all the possible paths to the object. The distinctPaths function has been added to the Entity selection class.
Here is everything you need to know.
ORDA, which stands for Object Relational Data Access, is a method of accessing data that combines the advantages of object-oriented programming with those of relational databases, allowing developers to focus on solving business problems rather than managing data access.
Whether you are new to ORDA or already familiar with it and want to expand your knowledge, consider this blog post a road map to guide you through the learning process.
This blog post includes the following:
- ORDA benefits
- ORDA overview
- Main concept
- ORDA APIs
- ORDA abstraction layer
- Working remotely
- Requests optimization
- Permissions system
- Sharing data between process
Without further ado, let’s get down to business!
Filter access to data is a must-have feature to prevent malicious access to your application.
So far, you could expose or not expose as a REST resource a dataclass and some of its attributes. It was already a convenient means to restrict access to your data. Still, we’re thrilled to deliver in the v19R8 a powerful and fully customizable system to protect your data from unauthorized users. A system to protect your data depends on who is accessing it and which data is accessed.
by Add Komoncharoensiri, Director of Technical Services at 4D Inc
Here we go with another set of tips and tricks.
The 4D Knowledge Base is a library of information about 4D technology where weekly tech tips and monthly tech notes are actively published. If you missed the last tips on the KB, that’s fine; here is a compilation from the past few weeks.
This blog post covers 17 tips:
Whatever your business, you must create listings, inventories, tracking sheets, product sheets, invoices, and many other documents. These documents are usually printed or saved in PDF for archiving.
4D Write Pro is the ideal tool to create all your documents. Here is a list of several features available in 4D Write Pro that can help you make beautiful documents for printing:
- page layout and margin management for printing,
- pdf export,
- document protection,
- table creation,
- table formatting with repeated headers,
- definition of a data context,
- inserting ORDA formulas in a table (new in 4D v19 R6).
Using these different features, here are some examples of documents produced.
The days of defining business-related formulas in your 4D user interface are over; these concepts offer you a new way to separate your business logic from the UI, enabling you to improve performance by optimizing the parts separately.
And now, with 4D v19 R6, aliases are fully available and ready to use for scalars in your iOS and Android mobile projects as soon your aliases are defined on the 4D side.
As developers, we often create complex and advanced 4D Write Pro documents. We may generate tables that need to be filled from a data source, and we may not be sure of the exact rows and columns. Manually filling the tables with data every time is a laborious task. We heard you, and here is where data context comes as an invaluable option, opening the world of ORDA and object-oriented development to 4D Write Pro documents.
It is now possible to define a “datasource” for the tables of 4D Write Pro. Whether it is an entity selection or a collection, this “datasource” will automatically feed the rows of these tables.
Let’s delve into the details!