Skip to content

November 2020

VBCS – Add OPA interview as iframe

<div data-vb-layout-type=”flex”> <iframe :src = “{{‘https://xxxxxxxxxx.com/web-determinations/startsession/InterviewName?SurveyCaseId=’+$page.variables.PartyID+’&jwt=’ + $page.variables.var_JWT}}” height = 1100> </iframe> </div>

BI Publisher – Get all resources from a The same Business Unit as a specific Resource User

SELECT DISTINCT JTF_RS_RESOURCE_PROFILES.PARTY_ID FROM ( Select PersonNameDPEO.PERSON_NAME_ID, PersonNameDPEO.PERSON_ID, PersonNameDPEO.DISPLAY_NAME as PERSON_DISPLAY_NAME, PersonDPEO.PERSON_NUMBER, PersonDPEO.PERSON_ID as PERSON_ID2, PersonDPEO.EFFECTIVE_START_DATE as PERSON_ESDATE, PersonDPEO.EFFECTIVE_END_DATE as PERSON_EEDATE, JobDPEO.JOB_ID, JobDPEO.NAME as JOB_NAME,… Read More »BI Publisher – Get all resources from a The same Business Unit as a specific Resource User

BI Publicher – SQL query to retrieve all install base assets filtered by Account Party and Service request BU Master Service Catalog

SELECT * FROM cse_assets_vl WHERE ITEM_ID IN (SELECT DISTINCT INVENTORY_ITEM_ID FROM QSC_PROD_GROUP_ITEMS WHERE PROD_GROUP_ID IN ( (SELECT DISTINCT PGR.PROD_GROUP_ID FROM QSC_PROD_GRP_REL_B GrREL INNER JOIN QSC_PROD_GROUPS_TL… Read More »BI Publicher – SQL query to retrieve all install base assets filtered by Account Party and Service request BU Master Service Catalog