[CLOSED]Replacing Text coming from Synonym.

I have a synonym connected to a stored proc. This proc is pulling data, which has URLs returned with it. Those URL have variables that need to be changed on the fly via WebFOCUS and so I'm trying to figure out the best way.

Example:

http://mydom/ibi_apps/rs/ibfs/WFC/Repository/ve/report_list.fex?IBIRS_action=run&ADDR=<<ADDRESS>>&ZIP5=<<ZIP5>>

I'm needing to replace both

<<ADDRESS>> and <<ZIP5>>

as it's returned to WebFOCUS. I started going down the road to use STRREP, but as we all know, that has so many parameters and I'm not sure I can use that inline with the TABLE FILE. What other options do I have?

This message has been edited. Last edited by: <Emily McAllister>,

- FOCUS Man, just FOCUS!
-----------------------------
Product: WebFOCUS
Version: 8.1.04
Server: Windows 2008 Server

Posts: 578 | Registered: October 01, 2014

Efrem

Platinum Member

posted

Hide Post

That seems like a WebFOCUS RESTful Web Services call to run a report.
Curious to why you're running this from a fex.
Is your Master say SUFFIX=REST?
Meaning, using the REST adapter.
If so, ADDR and ZIP5 are just FIELDs in the MASTER and the values can be passed through a WHERE/IF clause.

Posts: 229 | Location: New York | Registered: July 27, 2004

GavinL

Master

posted

Hide Post

This is a restful call, but ignore that as it could as easily be:

http://mydom/ibi_apps/run.bip?BIP_REQUEST_TYPE=BIP_RUN&BIP_folder=IBFS%253A%252FWFC%252FRepository%252Fve&BIP_item=report_list.fex&ADDR=<<ADDRESS>>&ZIP5=<<ZIP5>>

These are fexes that load data from SQL2012. In SQL is where we hold the URL's that the caller will need to go to each report with, but they have addresses on their end that they are passing to us and we update all the reporting URL's with the correct values, as the caller wouldn't know the specifics of each report and which ones take what parameters. Note we might be returning 50 reports and there are more than 2 params passed in. I just did it this way to demo why I need to replace text within data coming back.

Also note, we are an API and return all reports that user group has access too.

TABLE FILE vizconfig/sp_getreportinfo
BY 	SP_GETREPORTINFO.ANSWERSET1.REPORTNAME AS 'ReportName'
BY 	SP_GETREPORTINFO.ANSWERSET1.REPORTCODE AS 'ReportCode'
BY 	SP_GETREPORTINFO.ANSWERSET1.REPORTURL AS 'ReportURL'
BY 	SP_GETREPORTINFO.ANSWERSET1.ACTION AS 'Action'
BY 	SP_GETREPORTINFO.ANSWERSET1.ACTIONDETAIL AS 'ActionDetail'
WHERE SP_GETREPORTINFO.INPUT.@GROUPNAMES EQ '&ALLUSERGROUPS.EVAL';
ON TABLE PCHOLD FORMAT XML
ON TABLE NOTOTAL
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET EMPTYREPORT ON
ON TABLE SET HTMLENCODE ON
END

- FOCUS Man, just FOCUS!
-----------------------------
Product: WebFOCUS
Version: 8.1.04
Server: Windows 2008 Server

Posts: 578 | Registered: October 01, 2014

Ignored post by GavinL posted

Show Post

Please Wait. Your request is being processed...

Read-Only Topic

Focal Point

Focal Point Forums

WebFOCUS/FOCUS Forum on Focal Point

[CLOSED]Replacing Text coming from Synonym.

Focal Point | Privacy Statement | Terms of Service