Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at myibi@ibi.com and provide your corporate email address, company, and name.


Connect to myibi
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] How to check the ID's Added in the distribution list for report caster

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] How to check the ID's Added in the distribution list for report caster
 Login/Join
 
Member
posted
In Report caster schedule,I want to know what are all the ID's added in the distribution list for particular report,where i can find those distribution list details.

Thanks,
Pavi

This message has been edited. Last edited by: FP Mod Chuck,
 
Posts: 2 | Location: Webfocus 8.2.05 | Registered: August 19, 2020Report This Post
Virtuoso
posted Hide Post
If your RC repository is stored into a SQL DB, it will be under that DB in BOTSCHED, BOTDEST, BOTDIST, BOTADDR

Below is code that I have which gives all distribution per schedule and per person distributed to

/* WF-8-2 : EXTRACT "SEND TO" CREATING A ROW FOR EACH "SEND TO" VALUE */
SELECT DISTINCT LTRIM(RTRIM(T1.JOBDESC)) AS 'JOBDESC', LTRIM(RTRIM(T2.[MAILSUBJECT])) AS 'MAILSUBJECT'
      ,CASE WHEN T5.[INTERVALTYPE] = 'D' THEN 'Daily'
	        WHEN T5.[INTERVALTYPE] = 'W' THEN 'Weekly'
	        WHEN T5.[INTERVALTYPE] = 'M' THEN 'Monthly'
	        WHEN T5.[INTERVALTYPE] = 'O' THEN 'On Request'
			ELSE T5.[INTERVALTYPE] END AS 'FREQUENCY'
      ,CASE WHEN T5.[WEEKDAYS] = '1111111' THEN 'All 7 Days'
	        WHEN T5.[WEEKDAYS] = '1111100' THEN 'Mon To Fri'
	        WHEN T5.[WEEKDAYS] = '1000000' THEN 'Monday'
	        WHEN T5.[WEEKDAYS] = '0100000' THEN 'Tuesday'
	        WHEN T5.[WEEKDAYS] = '0010000' THEN 'Wednesday'
	        WHEN T5.[WEEKDAYS] = '0001000' THEN 'Thursday'
	        WHEN T5.[WEEKDAYS] = '0000100' THEN 'Friday'
	        WHEN T5.[WEEKDAYS] = '0000010' THEN 'Saturday'
	        WHEN T5.[WEEKDAYS] = '0000001' THEN 'Sunday'
	        WHEN T5.[WEEKDAYS] = '0000000' THEN 'On Request'
	        ELSE T5.[WEEKDAYS] END AS 'WEEKDAYS'
      ,T5.[STARTTIME]
	  ,CASE WHEN T2.[LISTTYPE] = 'S' THEN LOWER(REPLACE(T2.[DISTLIST], '; ', ';'))
	        WHEN T2.[LISTTYPE] = 'R' THEN LOWER(REPLACE(T2.[DISTLIST], '; ', ';'))
			ELSE LOWER(REPLACE(T4.[DESTFN], '; ', ';')) END AS 'SEND_TO'
	  ,CASE WHEN [LISTTYPE] = 'S' THEN 'Single Adr'
	        WHEN [LISTTYPE] = 'D' THEN 'Disttribution List'
			WHEN [LISTTYPE] = 'R' THEN 'Dynamic Dist List'
			WHEN [LISTTYPE] = 'Q' THEN 'Library'
			ELSE [LISTTYPE] END AS 'LISTTYPE'
	  ,T3.BOOKNAME
	  ,ISNULL(T3.[DESCRIPTION], '') AS 'BOOK_DESC'
INTO #TMP_EXT
  FROM [WF82ReposProd].[dbo].[BOTSCHED] T1
  LEFT OUTER JOIN [WF82ReposProd].[dbo].[BOTDIST] T2
    ON T1.SCHEDULEID = T2.SCHEDULEID
  LEFT OUTER JOIN [WF82ReposProd].[dbo].[BOTADDR] T3
    ON SUBSTRING(T2.DISTPATH, PATINDEX('%Schedules/%', DISTPATH) + 10, 100) LIKE T3.BOOKNAME
  LEFT OUTER JOIN [WF82ReposProd].[dbo].[BOTDEST] T4
    ON T3.[ADDRBOOKID] = T4.[ADDRBOOKID]
  INNER JOIN [WF82ReposProd].[dbo].[BOTSIT] T5
    ON T1.[SCHEDULEID] = T5.[SCHEDULEID]
WHERE T1.ACTIVE = 'Y' AND T2.ACTIVE = 1 AND T5.ACTIVE = 1
  AND T2.[LISTTYPE] != 'Q'  -- Q is the type assigned for HOLD schedules
ORDER BY JOBDESC

SELECT JOBDESC, MAILSUBJECT, FREQUENCY, WEEKDAYS, STARTTIME, LISTTYPE, BOOK_DESC, --BOOKNAME,
 CASE WHEN SUBSTRING(SEND_TO, LEN(SEND_TO), 1) = ';' THEN SUBSTRING(SEND_TO, 1, LEN(SEND_TO) -1) ELSE SEND_TO END AS 'SEND_TO'
INTO #TMP_CLEAN
FROM #TMP_EXT

;WITH SPLITRESULT
AS
(
    SELECT JOBDESC, MAILSUBJECT, FREQUENCY, WEEKDAYS, STARTTIME, LISTTYPE, BOOK_DESC, --BOOKNAME,
           [xml_val] = CAST('<t>' + REPLACE(SEND_TO, ';', '</t><t>') + '</t>' AS XML)
    FROM #TMP_CLEAN
)

SELECT DISTINCT JOBDESC, MAILSUBJECT, FREQUENCY, WEEKDAYS, STARTTIME, LISTTYPE, BOOK_DESC, --BOOKNAME,
                SEND_TO = col.value('.','VARCHAR(800)')
FROM SPLITRESULT
CROSS APPLY [xml_val].nodes('/t') CA(col)
WHERE col.value('.', 'VARCHAR(800)') NOT LIKE 'support%'
ORDER BY JOBDESC

DROP TABLE #TMP_EXT
DROP TABLE #TMP_CLEAN


WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
 
Posts: 2410 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013Report This Post
Member
posted Hide Post
Thanks for your response.

Is there any way to check the distribution list in webfocus legacy home page.I am able to get the details of last run and last accessed but i want to know to whom the report caster report is distributed.

And also how to add the new ID to the existing distribution list.
 
Posts: 2 | Location: Webfocus 8.2.05 | Registered: August 19, 2020Report This Post
Virtuoso
posted Hide Post
To know to who it has been distributed, the schedule log should tell you that.

You can manage the distribution list using the Report Caster menu from the Administrator options. But you need to be authorized (have privileges) to do that


WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
 
Posts: 2410 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] How to check the ID's Added in the distribution list for report caster

Copyright © 1996-2020 Information Builders