Data Check

Module Guide: Data Check

Module Location

Settings > Tools > Data Check

Module Purpose

The Data Check module is a powerful and high-risk database query console. This feature provides direct access to the application's underlying database, allowing technical users to execute SQL (Structured Query Language) commands directly. This module is not for business users but is a specialized tool for Database Administrators (DBAs), developers, or advanced technical support teams for the purpose of diagnosing complex data issues, data correction, and creating ad-hoc reports.​

1. Main View (Query Console)

The main page is an interface divided into several sections for writing, executing, and managing database queries.

View Explanation

• Query For Database:

  • This is the main area where the user writes SQL commands.

  • Database Dropdown: Allows the user to select the target database where the query will be executed (e.g., kokola).

• Query Action Buttons:

  • Run: Executes the written SQL command.

  • Clear: Clears the text from the query area.

  • Save As: Saves a frequently used query as a template for future use.

• Query Templates:

  • An area on the right that displays a list of saved queries. This allows users to quickly reload and re-run complex queries without retyping them.

• Results Area:

  • The bottom section of the screen (currently empty) is where the results of a query execution (especially a SELECT command) will be displayed in a table format.

2. Steps for Use

• Select Database: Choose the target database from the dropdown at the top.

• Write Query: Type the SQL command directly into the "Query For Database" text area.

  • To View Data: Use a SELECT command. Example: SELECT * FROM m_customer WHERE customer_city = 'Jakarta';

  • To Modify Data (Extremely Dangerous!): Use an UPDATE command. Example: UPDATE m_item SET is_active = 0 WHERE item_code = 'XYZ';

• Execute Query: Click the Run button.

• View Results: If using SELECT, the results will appear in the area below. If using UPDATE or DELETE, the system will provide a confirmation message with the number of rows affected.

• Save Template (Optional): If the query will be used frequently, click Save As to store it in the "Query Templates" list.

3. Integrated Workflow & Business Process

• Diagnostic Tool: When a data anomaly occurs that cannot be explained through the standard user interface (e.g., mismatched balances, transactions missing from reports), the technical team will use this module to "look directly" into the database tables and diagnose the root cause.

• Emergency Data Correction: In cases of data corruption or mass input errors, this module is the only way to perform direct and efficient data repair.

• Not for Business Users: This module is by design not integrated with daily business workflows. It is a "behind-the-scenes" tool used to maintain and repair the system, not to run the business.

4. Critical Warning & Security Tips

• CRITICAL WARNING: EXTREMELY HIGH RISK: This is the most dangerous module in the entire system. A single incorrect UPDATE or DELETE command without a proper WHERE clause can permanently and irretrievably delete or corrupt the entire company's data.

• SUPER-RESTRICTED ACCESS: Access to this module must be strictly limited and granted only to highly trained and trusted technical personnel, such as a Database Administrator (DBA) or Senior Developer. This module should never be accessible to regular users, managers, or even junior IT staff.

• Always Perform a Backup: Before running any data modification commands (UPDATE, DELETE, INSERT), it is strongly advised to perform a full database backup first.

• Test First in a Safe Environment: Every modification query should always be tested in a staging or testing (non-production) environment before being run on the production database.