When developing applications with Kuika, you can create Custom Actions to increase the functionality of your application and make data management more efficient. In addition to ManagedDB, a local database connected to your workspace, you can use and manage MSSQL, Swagger API, REST API and C# data sources in your applications. Through these data sources, you can create Custom Actions that bring custom functionality to your application.
Custom Actions are especially useful when you need to write SQL queries. These custom actions, which you can define through SQL queries to perform specific tasks or data manipulation in your application, offer flexibility to developers.
How to Add a Custom Action?
1. Access to Custom Actions Panel
After logging into the Kuika platform, open the project you will work on from the “Apps” screen.
Go to the UI Design module.
Open the Custom Actions panel.
Click the SQL Action button in the panel.
2. SQL Editor and Data Sources
You will be presented with the Datasource tables defined in your application and a SQL Editor screen.
On the left side, you can view the data sources tables in your application.
3. Writing and Defining SQL Queries
Through SQL Editor, write your SQL queries to define the action to be used in your application.
When you hover over the table names on the left side, a menu with three dots appears to the right of the table. Through this menu you can add one of the following ready-made queries:
Add Select Query: Used to select data.
Add Select By Id Query: Used to select data by a specific ID.
Add Save Query: Used to save the data.
Add Delete Query: Used to delete data.
Add Search by Keyword Query: Used to search by a specific keyword.
Add Search with Pagination Query: Used to search with pagination.
4. Saving and Using Your Action
After completing your query, save the action by clicking the CREATE button.
You can integrate and use the action you saved in any part of your application.
What Can You Do with Custom Actions?
Dynamic Database Operations: With custom actions, you can perform your database operations more dynamically and quickly.
API Integration: You can add flexibility to your application by using data sources such as REST API or REST Swagger.
Advanced Functions with C#: You can perform complex operations by integrating C# codes in your data operations.
