Total Pageviews

Thursday, 12 August 2021

WEBADI : How to add Multiple column in LOV

 How to add Multiple column in LOV WEBADI


1) Go to Components


2) Click on Update and modify as shown below. Click on apply.

table-column-alias=ORGANIZATION_CODE,ORGANIZATION_NAME,ORGANIZATION_ID
table-columns=ORGANIZATION_CODE,ORGANIZATION_NAME,ORGANIZATION_ID
table-headers=ORGANIZATION_CODE,ORGANIZATION_NAME,ORGANIZATION_ID







3) Same column mapping need to be provided on  description LOV section of Integrator Interface as shown below

description =ORGANIZATION_CODE,ORGANIZATION_NAME,ORGANIZATION_ID





3) Table Value set view




 

Output



FUSION: Purchasing Query

  1) ---------CPA to PO Amount---------- select poh.segment1, (select sum(nvl(cpol.quantity,1)* cpol.unit_price) from po_headers_all cpoh,po...