In Kuika, you can create Custom Actions to increase the functionality of your application and make data management more efficient. In addition to ManagedDB, you can add custom functions to your application by using MSSQL, Swagger API, REST API and C# data sources. Especially in cases where you need to write SQL queries, these custom actions provide great convenience.
1. How to Add a Custom Action?
1.1. Access to Custom Actions Panel
Log in to the Kuika platform and select your project from the Apps screen.
Go to the UI Design module.
Open the Custom Actions panel.
Click the SQL Action button.
1.2. SQL Editor and Data Sources
The SQL Editor screen displays the Datasource tables defined in your application.
You can examine the data sources by clicking on the table names on the left side.
1.3. Writing and Defining SQL Queries
Through the SQL Editor you can write your SQL queries for the action to be used in your application.
You can add the following ready-made queries using the ellipsis menu next to the table names:
Add Select Query: Selects data.
Add Select By Id Query: Selects data according to a specific ID.
Add Save Query: Saves the data.
Add Delete Query: Deletes the data.
Add Search by Keyword Query: Searches by a specific keyword.
Add Search with Pagination Query: Searches with pagination.
1.4. Saving and Using Your Action
After completing your query, save the action by clicking the CREATE button.
You can integrate the action you saved into any part of your application.
2. What You Can Do with Custom Actions
Dynamic Database Operations: You can perform database transactions quickly and flexibly.
API Integration: You can add new functions to your application using REST API or Swagger API.
Advanced Functions with C#: You can integrate complex data operations with C# codes.
By following these steps, you can manage your business processes faster and more efficiently by creating special actions in the applications you develop with Kuika.
