Versions Compared

Version Old Version 23 New Version 24
Changes made by

Deepak Kumar (Deactivated)

Subrat Sandilya

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Target Layout - The JSON schema for the source target data (database) will be designed to be utilized in the RESTful API for the user interface. JSON is selected for its compatibility with RESTful APIs.

...

Info

You must utilize the EDIT Query option to efficiently retrieve attributes from multiple tables and display relevant information on the user interface. Additionally, you implement conditions to filter the data as needed.

...

Table Name: DB/file_queueFQ/

Expand
titleSQL Query

SELECT FQ.ID,FQ.PARTNER_NAME,FQ.TRANSACTION_TYPE,FQ.FILE_REF_ID,FQ.PHASE,FQ.OVERALL_STATUS,FQ.ERROR_CODE,FQ.INCOMING_FILE_DATE,FQ.TOTAL_RECORDS,FQ.DUPLICATE_RECORDS,FQ.UNIQUE_RECORDS,FQ.GROUP_ID,FQ.V3_GROUP_ID,FQ.V3_PHASE,FQ.V3_STATUS,FQ.V3_TOTAL_RECORDS,FQ.V3_GOOD_RECORDS,FQ.V3_ERROR_RECORDS,FQ.V3_PASS_PERCENTAGE,FQ.V3_ERROR_MESSAGE,FQ.CORE_PHASE,FQ.CORE_STATUS,FQ.CORE_TOTAL_RECORDS,FQ.CORE_GOOD_RECORDS,FQ.CORE_ERROR_RECORDS,FQ.CORE_PASS_PERCENTAGE,FQ.CORE_ERROR_MESSAGE,FQ.CREATED_BY,FQ.LAST_MODIFIED_BY,FQ.LAST_MODIFIED_DATE,FND.FILE_NAME,FND.CREATED_DATE,ER.ERROR_MESSAGE,FQ.TRANSACTION_NAME FROM file_queue FQ LEFT JOIN file_name_details FND on FND.FILE_QUEUE_ID=FQ.ID LEFT JOIN error_code ER on FQ.ERROR_CODE=ER.ERROR_CODE

Expand
titleWhere Clause

WHERE FND.CREATED_DATE BETWEEN '$$start_date$$' AND DATE_ADD('$$end_date$$', INTERVAL 1 DAY) AND FND.FILE_TYPE='INPUT_FILE' ORDER BY FQ.ID ASC

  1. Target Layout - The JSON schema for the target data (database) will be designed to be utilized in the RESTful API for the user interface. JSON is selected for its compatibility with RESTful APIs.

...

  1. Mapping - You must load the database schema and the target schema (JSON) to finalize the mapping process.

...

  1. Context Target -The target will be ContextTarget to store data in the flow for the REST provider.

...

c. Advanced Process Flow - Filtering Records by (Start Date & End Date)

...

  1. Select the Response Schema (For example, we are opting for the schema that has been utilized in the process flow as the target schema

...

  1. Save it.

Process flow activity:

  1. Source Activity - The source comprises a database. It is necessary to create DbInfo and DbLayout to be invoked in the source activity

...

Info

You must utilize the EDIT Query option to efficiently retrieve attributes from multiple tables and display relevant information on the user interface. Additionally, you implement conditions to filter the data as needed.

...

Table Name: DB/file_queueFQ/

Expand
titleSQL Query

SELECT FQ.ID,FQ.PARTNER_NAME,FQ.TRANSACTION_TYPE,FQ.FILE_REF_ID,FQ.PHASE,FQ.OVERALL_STATUS,FQ.ERROR_CODE,FQ.INCOMING_FILE_DATE,FQ.TOTAL_RECORDS,FQ.DUPLICATE_RECORDS,FQ.UNIQUE_RECORDS,FQ.GROUP_ID,FQ.V3_GROUP_ID,FQ.V3_PHASE,FQ.V3_STATUS,FQ.V3_TOTAL_RECORDS,FQ.V3_GOOD_RECORDS,FQ.V3_ERROR_RECORDS,FQ.V3_PASS_PERCENTAGE,FQ.V3_ERROR_MESSAGE,FQ.CORE_PHASE,FQ.CORE_STATUS,FQ.CORE_TOTAL_RECORDS,FQ.CORE_GOOD_RECORDS,FQ.CORE_ERROR_RECORDS,FQ.CORE_PASS_PERCENTAGE,FQ.CORE_ERROR_MESSAGE,FQ.CREATED_BY,FQ.LAST_MODIFIED_BY,FQ.LAST_MODIFIED_DATE,FND.FILE_NAME,FND.CREATED_DATE,ER.ERROR_MESSAGE,FQ.TRANSACTION_NAME FROM file_queue FQ LEFT JOIN file_name_details FND on FND.FILE_QUEUE_ID=FQ.ID LEFT JOIN error_code ER on FQ.ERROR_CODE=ER.ERROR_CODE

Expand
titleWhere Clause

WHERE ( DATE_SUB(NOW(), INTERVAL 30 DAY) < FND.CREATED_DATE ) AND ( FND.FILE_TYPE='INPUT_FILE' ) AND ( FQ.PARTNER_NAME like '%$$searchQuery$$%' OR FQ.TRANSACTION_TYPE like '%$$searchQuery$$%' OR FQ.PHASE like '%$$searchQuery$$%' OR FND.FILE_NAME like '%$$searchQuery$$%' OR FQ.OVERALL_STATUS like '%$$searchQuery$$%' OR FQ.V3_PHASE like '%$$searchQuery$$%' OR FQ.V3_STATUS like '%$$searchQuery$$%' OR FQ.V3_ERROR_MESSAGE like '%$$searchQuery$$%' OR FQ.CORE_PHASE like '%$$searchQuery$$%' OR FQ.CORE_STATUS like '%$$searchQuery$$%' OR FQ.CORE_ERROR_MESSAGE like '%$$searchQuery$$%' OR FQ.CREATED_BY like '%$$searchQuery$$%' OR FQ.TRANSACTION_NAME like '%$$searchQuery$$%' ) ORDER BY FQ.ID DESC

  1. Target Layout - The JSON schema for the source data (database) will be designed to be utilized in the RESTful API for the user interface. JSON is selected for its compatibility with RESTful APIs.

...

  1. Mapping - You must load the database schema and the target schema (JSON) to finalize the mapping process.

...

  1. Context Target -The target will be ContextTarget to store data in the flow for the REST provider.

...

4. Publish the Provider (REST URL) at UI

...