Versions Compared

Version Old Version 6 New Version 7
Changes made by

Deepak Kumar (Deactivated)

Deepak Kumar (Deactivated)

Saved on

Key

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

...

  1. 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.

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 where clauses conditions to filter the data as needed.

...

Query Details:

Table Name: DB/file_queueFQ/

Expand
titleSQL Query

SELECT ID,FILE_QUEUE_ID,LOCATION_TYPE,FILE_TYPE,FILE_PATH,FILE_NAME,CREATED_BY,CREATED_DATE,LAST_MODIFIED_BY,LAST_MODIFIED_DATE FROM "file_name_details"

Expand
titleWhere Clause

WHERE FILE_QUEUE_ID =$$fileQueueId$$ and FILE_TYPE IN('ERROR_REPORT_FILE','V3_OUTPUT_FILE','FILTERED_PRODUCTS_LIST','DBQUERY_FILE','EBMR_OUTPUT_FILE')

3. Create REST Provider End-point

...