Welcome to OSQuay’s Knowledge Center.
A place to find articles, tutorials, how-tos, and more.
How To Handle Dynamic Excel Spreadsheets On The Outsystems Platform
A data structure must be defined beforehand when importing or exporting an excel file through the built-in OutSystems feature. Although this works for most situations, a different approach is needed when the number of columns is not specified or is data-dependent. So, how can we work around not using a known data structure?
Top 2 Approaches to Generate Project Documentation in the OutSystems Platform
This series is a compilation of challenges, approaches, and solutions that were part of our path as OutSystems Developers throughout different projects. This fourth part will review the top approaches to generating Project Documentation on the OutSystems Platform.
4 Strategies to apply custom CSS at runtime on OutSystems Reactive Applications
OutSystems allows you to customize your applications in several ways at design time. However, there's no built-in solution regarding runtime customization. Allowing apps to apply custom CSS at runtime is beneficial, and this article will explore four strategies to tackle this successfully.
Let’s talk indexes
Databases handle thousands or even millions of records, and they need to be able to return results in milliseconds. Thus, it is imperative to optimize data fetching: indexes. This article explains indexes and how to implement them in OutSystems.
How to handle hierarchical data using advanced queries
Have you ever been faced with a hierarchical data tree where you need to get a specific path or make a validation before adding/editing a node? In this post, we’ll show you how to do that by using CTEs / CONNECT BY on advanced queries on SQL and Oracle.
Concepts for BIG OutSystems Projects (Part III)
This series is a compilation of challenges, approaches, and solutions that were part of our path as OutSystems Developers throughout different projects. This third part will go over Feedback Messages.
OutSystems App Development Best Practices Using the 3 Layer Architecture Canvas
Architecture Best Practices are the foundation stones of our applications. They provide us with a solid infrastructure to develop on and ensure we deliver a reliable solution that's easy to maintain and has the flexibility to scale and evolve.
Top 14 things we wish we knew before starting a data migration in OutSystems
A data migration might be a long and painful process, and if you are here, it’s probably because you’re one of the lucky few that will have a taste. So, you have come to the right place; we are here to help!
How to deal with URL parameters: to hide, or to validate, that is the question
Have you ever asked yourself, “how can I hide URLs input values in OutSystems Apps?” or “how can I keep URL parameters and still have a secure app?” There are several reasons for OutSystems developers to ask these questions: maybe we are concerned with the application’s security or want to change the URL for aesthetic purposes. So, if you are struggling with this, make sure to read on.
Concepts for BIG OutSystems Projects (Part II)
This series is a compilation of challenges, approaches, and solutions that were part of our path as OutSystems Developers throughout different projects. This first part will go over Time zones, Bionic Finger, and Naming Conventions.
OutSystems Javascript API: Security and Logger
OutSystems Reactive has a Javascript API providing great features to improve applications by avoiding server-side processing. In this article, we will demonstrate Security and Logger and how they work.
Concepts for BIG OutSystems Projects (Part i)
This series is a compilation of challenges, approaches, and solutions that were part of our path as OutSystems Developers throughout different projects. This first part will go over Time zones, Bionic Finger, and Naming Conventions.
How to Add New Icons to your OutSystems Apps using existing Icon Fonts
Icon Fonts are incredibly versatile and allow the addition of graphical elements to web apps seamlessly. This article demonstrates how to create and maintain icons in OutSystems by using Icon Fonts.
Top 3 Pros & Cons of Working Remotely with Teams in Different Time Zones
Working remotely has become part of many people's lives during this past year due to COVID-19. Yet, the reality is that for technology companies, it's a well-known arrangement. Read on to learn some of the pros and cons and a few tips and tricks.
A Closer Look at REST APIs on the OutSystems platform
In this article, we’ll explore what REST API Web Services are and why they are important. We will also explore why they are widely used on the OutSystems Platform, what precautions to take while using them, and some suggestions.
A Chat with Graça Peixoto: From Fortran to OutSystems (and a few others in the middle)
As a part of our themed month celebrating women in science and raising awareness for the gender gap, we interviewed Graça Peixoto, OSQuay’s Consultant. Graça has been part of OSQuay’s team since day one and has incredible stories to share.
How to optimize your queries in Outsystems: the ‘max records’ property
To show you how you can optimize your queries to fetch only the records you want or how to apply some logic to manage heavy tables, let’s go on a trip where we’ll visit our beloved aggregates and, the ones feared by many, SQL queries.
[Video] How to use OutSystems Multi-Language capabilities the right way
With proper multi-language support, you will be able to use several languages and translations in your applications. Thus, serving users from different countries and speaking various languages.
How To Easily Add Animations in OutSystems
Have you ever wondered what could be that extra step to provide an easy on the eyes experience for your users and keep them coming back to your application? A well-placed animation may be just what you need!
How to use CSS variables in OutSystems
Have you ever had to develop an application with a default layout, where there is a set of colors that will be reused to keep the look-and-feel consistent? Well, if you work with OutSystems, sooner or later you’ll have to, so let me introduce you to a cool feature that can save (a lot!) of time and keep your application organized, and easy to maintain.