SELECT C."DetailedDescription" , S."DemoVideoTypeUId", S."DemoVideo", ( SELECT json_agg( row_to_json(B)) AS "Feature" FROM ( SELECT DISTINCT "FeatureTitle", "FeatureDescription" FROM catalogueservices."AssetFeature" WHERE "AssetVersionUId" = V."AssetVersionUId" AND "AssetUId" = V."AssetUId" )B ) AS "Feature", ( SELECT json_agg(row_to_json(B))FROM ( SELECT DISTINCT "AssetOutcomeOrBenefitUId", ( SELECT DISTINCT "MasterListItemValue" FROM catalogueservices."MasterListItem" WHERE "MasterListItemUId" = "OutcomeTypeUId") AS "OutcomeType", "OutcomeValue", "OutcomeDesc", "Tagwords" FROM catalogueservices."AssetOutcomeOrBenefit" WHERE "AssetVersionUId" = V."AssetVersionUId" )B ) AS "Benefit", ( SELECT json_agg( row_to_json(B)) AS "Feature" FROM ( SELECT DISTINCT A."DisplayName", A."EmailId", R."RoleName" FROM catalogueservices."AssetContact" A JOIN catalogueservices."Role" R ON A."RoleUId" = R."RoleUId" WHERE A."AssetUId" = C."AssetUId" -->AND A."AssetVersionUId" = V."AssetVersionUId" )B ) AS "Contact", CS."AssetImagePath", CS."AssetImageBinary" , CS."AssetImageTypeUId" , Q."Comments" from catalogueservices."AssetDetails" C JOIN catalogueservices."AssetVersion" V ON C."AssetUId"= V."AssetUId" left JOIN catalogueservices."AssetImage" CS ON C."AssetUId"= CS."AssetUId" left JOIN catalogueservices."AssetDemoVideo" S ON C."AssetUId" = S."AssetUId" left JOIN catalogueservices."DemoVideoSection" Q ON S."AssetDemoVideoUId"= Q."AssetDemoVideoUId" where C."AssetId"= '19' and V."AssetVersionId"='22'
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)