Test

With(
{pInput: ParseJSON(pJSON)},
Switch(
pRepo,
“ABB”,
ClearCollect(
col_ABBs,
//remove just Value column
DropColumns(
AddColumns(
Table(
ParseJSON(
JSON(
storedprocs_ABBsR4.dbospabbfinderr4(
//Parameters:
{
filterabbstatus: Text(
Coalesce(
Text(pInput.abbstatus),
“”
)
),
filterproduct: If(
IsBlank(_SelectedProductID),
Text(
Coalesce(
Text(pInput.product),
“”
)
),
_SelectedProductID
),
filtersector: Text(
Coalesce(
Text(pInput.sector),
“”
)
),
filterindustry: Text(
Coalesce(
Text(pInput.industry),
“”
)
),
filtersituation: Text(
Coalesce(
Text(pInput.situation),
“”
)
),
search: Text(
Coalesce(
Text(pInput.search),
“”
)
),
filterproductgroupl0: Text(
Coalesce(
Text(pInput.productgroupl0),
“”
)
)
}
).ResultSets
)
).Table1
),
//ColumnNames
abbid,
Text(Value.abbid),
abbname,
Text(Value.abbname),
abbdescription,
Text(Value.abbdescription),
abbstatus,
Text(Value.abbstatus),
downloadcount,
Value(Value.downloadcount),
viewcount,
Value(Value.viewcount),
abbnumber,
Text(Value.abbnumber),
ppturl,
Text(Value.ppturl),
abbshortdescription,
Text(Value.abbshortdescription)
),
Value
)
),
“DataCatalogue”,
ClearCollect(
_dataCatalogueLib,
//remove just Value column
DropColumns(
AddColumns(
Table(
ParseJSON(
JSON(
storedprocs_DCLibR4.dbospdatacataloguelibraryr4(
//Parameters
{
filteraccess: Text(
Coalesce(
Text(pInput.access),
“”
)
),
filterdatasourceprovider: Text(
Coalesce(
Text(pInput.datasourceprovider),
“”
)
),
filterindustry: Text(
Coalesce(
Text(pInput.industry),
“”
)
),
filterlicense: Text(
Coalesce(
Text(pInput.license),
“”
)
),
filtermemberfirm: Text(
Coalesce(
Text(pInput.memberfirm),
“”
)
),
search: Text(
Coalesce(
Text(pInput.search),
“”
)
)
}
).ResultSets
)
).Table1
),
//ColumnNames
recordid,
Text(Value.recordid),
datasourcetitle,
Text(Value.datasourcetitle),
datasourceshortdescription,
Text(Value.datasourceshortdescription),
vendorlogo,
Text(Value.vendorlogo),
licensedmemberfirm,
Text(Value.licensedmemberfirm),
country,
Text(Value.country)
),
Value
)
),
“Credential”,
ClearCollect(
col_CredentialsFeeRangeTable,
//remove just Value column
DropColumns(
AddColumns(
Table(
ParseJSON(
JSON(
storedprocs_CredsR4.dbospcredentials1r4(
//Parameters
{
feerangeorduration: 1,
filtermaxduration: Text(
Coalesce(
Text(pInput.maxduration),
“”
)
),
filterminduration: Text(
Coalesce(
Text(pInput.minduration),
“”
)
),
filterproduct: If(
IsBlank(_SelectedProductID),
Text(
Coalesce(
Text(pInput.product),
“”
)
),
_SelectedProductID
),
filtersector: Text(
Coalesce(
Text(pInput.sector),
“”
)
),
filterindustry: Text(
Coalesce(
Text(pInput.industry),
“”
)
),
filterregion: Text(
Coalesce(
Text(pInput.region),
“”
)
),
search: Text(
Coalesce(
Text(pInput.search),
“”
)
)
}
).ResultSets
)
).Table1
),
//ColumnNames
credentialid,
Text(Value.credentialid),
projectname,
Text(Value.projectname),
projectyear,
Text(Value.projectyear),
leadpartner,
Text(Value.leadpartner),
projectdescription,
Text(Value.projectdescription),
projectduration,
Text(Value.’projectduration(weeks)’),
feerange,
Text(Value.feerange),
memberfirm,
Text(Value.memberfirm),
credentialurl,
Text(Value.credentialurl),
product,
Text(Value.product),
sector,
Text(Value.sector),
subsector,
Text(Value.subsector),
industry,
Text(Value.industry),
region,
Text(Value.region),
leadmemberfirm,
Text(Value.leadmemberfirm)
),
Value
)
),
“DocumentLibrary”,
ClearCollect(
col_DocumentLibrary,
//remove just Value column
DropColumns(
AddColumns(
Table(
ParseJSON(
JSON(
storedprocs_DocsR4.dbospdocumentlibraryr4(
//Parameters
{
filterproduct: If(
IsBlank(_SelectedProductID),
Text(
Coalesce(
Text(pInput.product),
“”
)
),
_SelectedProductID
),
filterphase: Text(
Coalesce(
Text(pInput.phase),
“”
)
),
filteryourneed: Text(
Coalesce(
Text(pInput.yourneed),
“”
)
),
filterassettype: Text(
Coalesce(
Text(pInput.assettype),
“”
)
),
filterdocument1: Text(
Coalesce(
Text(pInput.document1),
“”
)
),
filterproductgroup2: Text(
Coalesce(
Text(pInput.productgroup2),
“”
)
),
filterdisplayclassification: Text(
Coalesce(
Text(pInput.displayclassification),
“”
)
),
filterdealspace: Text(
Coalesce(
Text(pInput.dealspace),
“”
)
),
search: Text(
Coalesce(
Text(pInput.search),
“”
)
)
}
).ResultSets
)
).Table1
),
//ColumnNames
assetid,
Text(Value.assetid),
assetname,
Text(Value.assetname),
assetdescription,
Text(Value.assetdescription),
assetclassification,
Text(Value.assetclassification),
assettype,
Text(Value.assettype),
documenturl,
Text(Value.documenturl),
downloadcount,
Value(Value.downloadcount),
viewcount,
Value(Value.viewcount),
documenttypel1,
Text(Value.’Document Type L1′),
documenttypel1sortorder,
Value(Value.’Document Type L1 sortorder’),
productgroupl2,
Text(Value.productgroupl2),
displayclassification,
Text(Value.displayclassification),
displayclassificationorder,
Value(Value.’displayclassification order’),
// Derived UI fields preserved from your original:
displayclassificationflat,
Blank(),
displayclassificationflatorder,
1,
displayclassificationexpand,
“Yes”
),
Value
)
),
“Agent”,
ClearCollect(
col_AIAgents_ToolsPage,
//remove just Value column
DropColumns(
AddColumns(
Table(
ParseJSON(
JSON(
storedprocs_ToolsAgentsR4.dbosptoolsandagentsr4(
//Parameters:
{
search: Text(
Coalesce(
Text(pInput.search),
“”
)
)
}
).ResultSets
)
).Table1
),
//ColumnNames
toolid,
Text(Value.toolid),
toolname,
Text(Value.toolname),
tooldescription,
Text(Value.tooldescription),
tooltype,
Text(Value.tooltype),
toolimage,
Text(Value.toolimage),
toolurl,
Text(Value.toolurl),
isglobal,
Text(Value.isGlobal),
countrycode,
Text(Value.countrycode),
region,
Text(Value.region),
memberfirm,
Text(Value.memberfirm),
status,
Text(Value.status),
keycontact,
Text(Value.keycontact),
languagessupported,
Text(Value.languagessupported),
usmemberfirmurl,
Text(Value.usmemberfirmurl)
),
Value
)
),
“Academy”,
ClearCollect(
col_AnalyticsAcademy,
//remove just Value column
DropColumns(
AddColumns(
Table(
ParseJSON(
JSON(
storedprocs_AcadSummR4.dbospacademysummaryr4(
//Parameters:
{
search: Text(
Coalesce(
Text(pInput.search),
“”
)
)
}
).ResultSets
)
).Table1
),
//ColumnNames
coursename,
Text(Value.’Course Name’),
coursedescription,
Text(Value.’Course Description’),
courseimage,
Text(Value.’Course Image’),
totalhours,
Text(Value.totalhours),
modules,
Text(Value.modules)
),
Value
)
)
)
);