<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>
Field Service – OPA- Integration using OPA interview url parameters 1 – Login to Field Service as Administrator 2 – Go to Configuration – Forms… Read More »Field Service – OPA- Integration using OPA interview url parameters
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,… Read More »BI Publisher – Get all resources from a The same Business Unit as a specific Resource User
BI Publisher – SQL to Return Knowledge Articles from Engagement Cloud SELECT t.DOCUMENT_ID, d.XML FROM CSO_CONTENT_TEXT t INNER JOIN CSO_CONTENT_DATA d ON (t.RECORD_ID = d.RECORD_ID)… Read More »BI Publisher – SQL to Return Knowledge Articles from Engagement Cloud
BI Publisher – SQL get user details from ASE_USER_B where USER_LOGIN like ‘%User Name%’
BI Publicher – SQL query to retrieve all install base assets filtered by Account Party and Service request BU Master Service Catalog SELECT * FROM… Read More »BI Publicher – SQL query to retrieve all install base assets filtered by Account Party and Service request BU Master Service Catalog
SQL Split Opportunity Revenue by Calendaristic Months SELECT OPPORTUNITY_REVENUE.OPTY_ID, OPPORTUNITY_REVENUE.OPTY_NUMBER, OPPORTUNITY_REVENUE.NAME, OPPORTUNITY_REVENUE.LOCATIONS, OPPORTUNITY_REVENUE.REVENUE_DRIVER, OPPORTUNITY_REVENUE.CETA, ( CASE WHEN OPPORTUNITY_REVENUE.ACCOUNT_PARTY_ID IS NULL THEN ‘NO ACCOUNT’ ELSE (… Read More »SQL Split Opportunity Revenue by Calendaristic Months