Welcome to OSQuay’s Knowledge Center.
A place to find articles, tutorials, how-tos, and more.
Streamline your data: How to Integrate Google Sheets with OutSystems Applications
This article provides a step-by-step guide on integrating Google Sheets with OutSystems applications for streamlined data management. Learn how to set up your environment, retrieve data from Google Sheets, and display it on your app screens. The guide covers setting up the Google Sheets Rest API, obtaining tokens via the Google API Token helper, and configuring the Google API Service Account.
Mastering BPT in OutSystems: A Guide to Efficient Design and Scalability
This article delves into Business Process Technology (BPT) within OutSystems, focusing on designing and scaling efficient BPT flows. We explore essential strategies and tips to enhance your business processes, addressing critical aspects of BPT architecture and implementation. This piece is crafted for developers, offering practical insights and methodologies to integrate seamlessly into any OutSystems application.
Unveiling the Importance of Security Testing in OutSystems Applications
Dive into our insightful article that emphasizes the crucial role of security testing in applications, especially those developed using OutSystems. We explore the essentiality of prioritizing these tests in an environment rife with ever-present and continually evolving digital threats, providing a clear understanding of their significance in today's cyber landscape.
Crafting Custom Logging & Change Tracking in OutSystems — Part 2: The UI Layer and Use Cases
Continuing our exploration into custom logging and change tracking in OutSystems, this article delves into the UI Layer and use case patterns. It thoroughly examines interface enhancement techniques and the practical implementation of use case patterns. Aimed at developers, the content is focused on the practical application of these patterns designed to integrate seamlessly into any OutSystems application.
Crafting Custom Logging & Change Tracking in OutSystems — Part 1: The Core
Discover the art of custom logging and change tracking in OutSystems with our latest article. This first part of a two-part series dives deep into the core concepts of developing bespoke logging and tracking solutions. Learn how to lay the groundwork for an effective, reusable, and adaptable system tailored to fit the unique demands of your OutSystems applications.
An In-Depth Look at the Anatomy of End-User Permissions in OutSystems
As an OutSystems developer, you're likely familiar with managing permissions through the Users' application and server actions in code. However, have you ever wondered about the underlying database structure and the entities holding user permission data? This article provides a concise overview of these system entities.
Streamlining OutSystems Code Review: Tools, Tips, and Best Practices
Has someone just assigned you your first code review? Or maybe you’re already familiar with this practice and are just looking for some tips on how to do it in the OutSystems Platform? Either way, we’ve got you covered.
Reviewing code is a best practice for a reason: it can dramatically improve the quality of the delivery, increase the team’s technical proficiency, and save some troubles further down the road.
Unlock Real-Time Data Updates in OutSystems: A Quick How-To Using WebSocket Connections
This concise guide walks you through connecting to a Streaming Service that uses WebSockets to push live data. So, let's dive in and learn how to harness the power of real-time data updates in OutSystems effortlessly!
Stay Ahead of the Game: Handling Unplanned Work in OutSystems Projects
Unplanned (or reactive) work refers to tasks or projects that are not part of your original plan but are a response to a new request or unexpected issue. This article explores reactive work, why it matters, and how to handle it. We'll also discuss how proactive or planned work can help prevent reactive work from becoming overwhelming. And we'll look at the OutSystems agile approach to tackle it.
Getting Started with Multi-Tenancy on OutSystems
Multi-tenancy is a vital feature on the OutSystems platform that enables the isolation of data, configurations, and users between tenants. This feature allows the delivery of the same software for multiple customers while ensuring they cannot access each other's data at any moment.
This article will delve into the details of multi-tenancy and how to set it up.
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.
Improving an OutSystems Software Factory
In this short video, Rui Félix – OSQuay’s COO and former Head of Delivery at Van Ameyde – talks about his experience overseeing one of the largest OutSystems Factories worldwide. With team growth and greater requirements scope, they put in place a Domain Development Workflow to improve ownership and overall autonomy of software releases.
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.