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.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Report trigger question.....

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Report trigger question.....
 Login/Join
 
<Rob M>
posted
Wondered if it is possible to have some kind of 'trigger' to run a report and deliver via reportcaster?

Basically we have an integration database that puts data between two sql databases. This database has a 'failure' table which capture data that has not been integrated correctly in accordance with the rules defined. What I would like to do is when a new line of data is entered in the failure table then a webFOCUS report will automatically run and will be sent to a specific user./

Any ideas how best to approach this?
 
Report This Post
<Grzegorz>
posted
It seems that you are asking about the standard MRE/ReportCaster functionality - alert scheduling.
Look at the manuals: Managed Reporting Administrator (creating alerts), and Report Caster Administrator (scheduling alerts).
You can also create alerts in FEX, something like this:
-*
TABLE FILE failure_table
PRINT *
WHERE READLIMIT EQ 1
WHERE new_data_in_the_table_check_expression
ON TABLE HOLD
END
-IF &RECORDS EQ 0 THEN GOTO :FINISH;
-INCLUDE the_report
-:FINISH
-*
Then schedule the report as standard report within Report Caster.
(The similar technique is used by the MRE alert wizard.)

Hope this helps
Grzegorz
 
Report This Post
Susan Trommer
Member
posted Hide Post
The ReportCaster Alert feature is definitely an option but if the table already contains records, the table would have to contain some field (column) for which the WHERE could be built to test for a criteria that would fulfill your assessment needs.
Another option to look into is to add a trigger to the exception table that when a record is added it makes a call and runs an OS level program (Java Application) that utilizes the ReportCaster BEAN API (supported on all platforms that support Java).
You would have a schedule created to run the report against the execution table and make that schedule inactive. Then the Java application that uses the Bean API would pass either the schedule ID or the description of the schedule to run the schedule when a record is added to the exception table.
I don't have a sample or any information on how to setup a SQL database trigger to call the OS. You would have to investigate this in the vendor doc for the DBMS itself.
Good Luck!
 
Posts: 28 | Registered: May 22, 2003Report 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     Report trigger question.....

Copyright © 1996-2020 Information Builders