...
This flow contains the following functionality:
First flow – It enables the advanced search option like
Default flow - It shows the last 30 days' records like errors, status, warnings, and good records
Last flow – It enables a search option with an emp name or SSN
...
User Interface (UI) Request:
A user interacts with the UI and triggers a request to view application data.
The UI sends a request to the backend service via the REST API.
API Endpoint Invocation:
The REST provider API receives the request and routes it to the appropriate endpoint.
The endpoint is configured to handle specific data queries and statuses (good records, error records, warnings, etc.).
Backend Service Initialization:
The API endpoint invokes the backend service responsible for processing the request.
The backend service starts by validating the incoming request parameters.
Data Retrieval:
The backend service queries the database or data storage to fetch the requested application data.
It retrieves data based on the requested criteria (e.g., all records, good records, error records, warnings).
Data Processing:
The backend service processes the retrieved data to format it according to the requirements.
It filters and categorizes the data into different statuses (good records, error records, warnings).
Response Preparation:
The processed data is then packaged into a structured response.
The response includes all the necessary details and statuses requested by the user.
Sending the Response:
The backend service sends the prepared response back to the REST provider API.
The API then forwards the response to the UI.
UI Displays Data:
The UI receives the response and parses the data.
It displays the data to the user, showing complete statuses like good records, error records, warnings, etc.
Process flow Activity:
Gateway Condition: This condition retrieves a value based on user-provided search criteria through the UI's advanced search option. The code facilitates the process flow according to the specified start_date
...
Source Activity - The source comprises a database. It is necessary to create DbInfo and DbLayout to be invoked in the source activity
...
Go to edit query and to write tables joining query.
...