[CLOSED] Save Parameters to a URL and append that hyperlink to a page?

Hi everyone, I have an application design question that I hope someone can help me with.

My client wants a variation on the save parameters/Share Reports concept.
They want their users, from a parameterized launch page, to be able to save their parameters for a given report as a FOCEXEC that can be displayed as a report link on a page. The goal is to allow all those saved iterations of a report to be presented to all the users in the same MR group in a simple list Hyperlinked reports in a Dashboard tab/page.

It seems possible, but I just need help understanding how to make it work.

Any ideas? (or follow up questions?)

Doug Slagowitz
WF 7.7.0.3 Client/Server on WIN 2008 R2.

This message has been edited. Last edited by: Kerry,

Posts: 10 | Registered: December 18, 2007

Dave

Master

posted

Hide Post

I'm would like a solution like that also. ( and the users being able to give it a name ).

What I've done now:

Example report.fex

TABLE FILE CAR
 SUM SALES
 BY COUNTRY
WHERE COUNTRY EQ '&USER_COUNTRY'
WHERE CAR EQ '&USER_CAR'

Example handler.fex

-IF &LISTTYPE EQ 'PARAMLIST' THEN CONTINUE ELSE GOTO ENDIF01;
-GOTO REPORT
-ENDIF01
-IF &LISTTYPE EQ 'MYLIST1' THEN CONTINUE ELSE GOTO ENDIF02;
-SET &USER_COUNTRY = 'JAPAN';
-SET &USER_CAR = '_FOC_NULL';
-GOTO REPORT
-ENDIF02
-IF &LISTTYPE EQ 'MYLIST2' THEN CONTINUE ELSE GOTO ENDIF03;
-SET &USER_COUNTRY = '_FOC_NULL';
-SET &USER_CAR = 'DATSUN';
-GOTO REPORT
-ENDIF03

-REPORT
-INCLUDE REPORT.FEX

So I give the user a choice with a dropdownbox:
- Select 'paramlist' and fill out the parameters on screen
or
- Choose one of the predefined sets of parameters ( and ignore the parameters on screen )

In a neat HTML, looks okay.

One big set back.
Each time they think of a new 'MYLIST' I have to add an piece of code and a dropdown option.

Greets,
Dave

_____________________
WF: 8.0.0.9 > going 8.2.0.5

Posts: 668 | Location: Veghel, The Netherlands | Registered: February 16, 2010

Ignored post by Dave posted

Show Post

Maintain Wizard

Master

posted

Hide Post

I would build a Maintain entry form to collect the parameters and save them to the database under a unique query name. Then populate the variables in the Table request from that file. You can use drop downs a list boxes to allow the user to select the fields, etc...

Mark

Posts: 663 | Location: New York | Registered: May 08, 2003

Ignored post by Maintain Wizard posted

Show Post

Dave

Master

posted

Hide Post

Hey Mark,

Sounds good. But what if you don't have maintain? :-)

_____________________
WF: 8.0.0.9 > going 8.2.0.5

Posts: 668 | Location: Veghel, The Netherlands | Registered: February 16, 2010

Ignored post by Dave posted

Show Post

Dan Satchell

Virtuoso

posted

Hide Post

I agree with Mark that the information for each query should be stored in a table, but you can achieve this with MODIFY instead of MAINTAIN. The table would contain both the parameter values and the unique query names. The list of report names for your drop-down would come from the table. When a report was selected from the list, the query name and related parameters could be displayed on the launch page in editable input boxes, with submit options to run the report with the displayed values, or to save changes made to the parameters. If you use a sequential number as the key to the table, all of the parameters and the query name could be update-able. You could also include a delete button on your launch page for deleting queries, but I would mark the queries as deleted with a delete flag or delete date-time in the table rather than actually deleting them (and capture user ID, if possible). This approach would permit recovery of queries that were accidentally (or maliciously) deleted.

WebFOCUS 7.7.05

Posts: 1213 | Location: Seattle, Washington - USA | Registered: October 22, 2007

Ignored post by Dan Satchell posted

Show Post

David Briars

Master

posted

Hide Post

quote:
..the information for each query should be stored in a table, but you can achieve this with MODIFY instead of MAINTAIN. The table would contain..

Thank you for your thoughts Dan.

I have used MODIFY to store user request data, within a FOCUS database. The application worked great, and was very useful.

By any chance, do you know if we can do a MODIFY against an Oracle table?

In the past, I've used MODIFY against VSAM files on z/OS, and RMS files on the VAX, so I was wondering if, by extension, MODIFY against Oracle is available. (I am asking because, at my current site, FOCUS database server/simultaneous usage facility may not be an option.)

Pilot: WebFOCUS 8.2.06 Test: WebFOCUS 8.1.05M Prod: WebFOCUS 8.1.05M Server: Windows Server 2016/Tomcat Standalone Workstation: Windows 10/IE11+Edge Database: Oracle 12c, Netezza, & MS SQL Server 2019 Output: AHTML/XLSX/HTML/PDF/JSCHART Tools: WFDS, Repository Content, BI Portal Designer & ReportCaster

Posts: 822 | Registered: April 23, 2003

Ignored post by David Briars posted

Show Post

njsden

Virtuoso

posted

Hide Post

quote:
do you know if we can do a MODIFY against an Oracle table?

I think you can.

If I'm not mistaken, products such as iWay Data Migrator create MODIFY statements behind the scenes in order to update data as a result of ETL processing targeting Oracle, SQL Server, etc.

That's the beauty of iWay adapters and WF synonyms in general.

Prod/Dev: WF Server 8008/Win 2008 - WF Client 8008/Win 2008 - Dev. Studio: 8008/Windows 7 - DBMS: Oracle 11g Rel 2
Test: Dev. Studio 8008 /Windows 7 (Local) Output:HTML, EXL2K.

Posts: 1533 | Registered: August 12, 2005

Ignored post by njsden posted

Show Post

Francis Mariani

Expert

posted

Hide Post

You can generate and execute UPDATE SQL commands in your fex...

Francis

Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server

Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005

Ignored post by Francis Mariani posted

Show Post

dhagen

Virtuoso

posted

Hide Post

Doug, I am not big on using a table to write the reports to. Once you write the stuff to a db, then you have to build a management layer to delete or rename or whatever, and that just sucks.

As you may or may not know, adding a report to the MRE is just running a URL. If you know the parameters, and the users have the privileges, you can very quickly build a JS routine to iterate through the page input objects, and convert the names and values to Focus code (e.g. -SET &SOMETHING=SOMETHINGELSE). Then you can construct the URL and submit it using Ajax, and bada-bing bada-boom, you have a MRE report. I've used this technique a few times in the past for building My Reports on the fly. Adding the correct parameters to build a Domain report should be simple.

"There is no limit to what you can achieve ... if you don’t care who gets the credit." Roger Abbott

Posts: 1102 | Location: Toronto, Ontario | Registered: May 26, 2004

Ignored post by dhagen posted

Show Post

Francis Mariani

Expert

posted

Hide Post

quote:
bada-bing bada-boom

I like the ring to that sound!

Francis

Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server

Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005

Ignored post by Francis Mariani posted

Show Post

Please Wait. Your request is being processed...