Focal Point
how to code to open a group view in fex

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/2121081052

October 04, 2007, 04:21 PM
mike
how to code to open a group view in fex
I am thinking to write a fex that will do some stuff and then at the end, open the group view in the existing window. Is there a way to do that? what is the wfc command to open the group view in th existing window?


wf 7.6.11
unix aix
active reports, HTML, Excel, Text and PDF formats
October 04, 2007, 05:03 PM
Prarie
please take a minute to update your signature (via Profile page) with the following information:

1) What version of WebFOCUS are you using?
2) What platform are you on?


In Focus since 1993. WebFOCUS 7.7.03 Win 2003
The following link:
http://techsupport.informationbuilders.com/sps/20322042.html
specifies this technique:
To access a group view directly via a URL you can do the following:
 
  http://hostname/ibi_apps/bid?WORP_REQUEST_TYPE=WORP_GBV_VERIFY
  &groupName=grouphref&WORP_USER=username&WORP_MPV=viewurl&WORP_PASS=pass&
  WHERE:
  hostname   is the name of the system where Dashboard is installed
  grouphref  is the href for the Group (see properties for the Group in
             Managed Reporting)
  *** Make sure you don't include the (#) pound sign in your grouphref
  username   is the user attempting to log in
  pass       is the password for the user attempting to login
  viewurl    is the View Name created by Dashboard (for example, aa_gbv).


Since you're operating from within a fex, you could use this technique in a -HTMLFORM block and start the group view that way. You will have to use a document.location or some other javascript statement to do the redirect to the group view.

Let me know if this helps.


GamP

- Using AS 8.2.01 on Windows 10 - IE11.
in Focus since 1988
thanks GamP. I'll let you know how that comes out.

Here is a message for Praire who wanted me to update my profile. I looked and looked and I can't find the link to profile. Care to be more specific?


wf 7.6.11
unix aix
active reports, HTML, Excel, Text and PDF formats
How about reading the highlighted posting by Kelly:


Friendly reminder: Please update your signatures


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
anyone knows why the browser would not read beyond the first parameter (WORP_REQUEST_TYPE=WORP_GBV)? It just won't go pass the & sign.

window.location.href =
'ibi_apps/bid?WORP_REQUEST_TYPE=WORP_GBV&WORP_MPV=ac_gbv&WORP_USER=admin&WORP_PASS=&';


Also, I tried typing this directly on the browser window (with server name added in front), I got "Illegal request attempt: session has expired or been invalidated. Before attempting to execute any requests you must acquire a users session."

I thought that was supposed to do the login part?

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


wf 7.6.11
unix aix
active reports, HTML, Excel, Text and PDF formats
quote:
&username=admin&pass=&


username and pass are not valid WF Dashboard variables. Try WORP_USER and WORP_PASS instead.

Here's an example:

h t t p://localhost/ibi_apps/bid?WORP_REQUEST_TYPE=WORP_GBV_VERIFY&groupName=nlmdli&WORP_MPV=aj_gbv&WORP_USER=gemini&WORP_PASS=gemini&



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
Hi Francis: I did. You were looking at a post before I corrected it. As I said, it was not reading beyond the first & sign.


wf 7.6.11
unix aix
active reports, HTML, Excel, Text and PDF formats
Mike,

If you are doing this from a fex you need to place a '|' after the &.

window.location.href =
'ibi_apps/bid?WORP_REQUEST_TYPE=WORP_GBV&WORP_MPV=ac_gbv&WORP_USER=admin&WORP_PASS=&';

becomes

window.location.href =
'ibi_apps/bid?WORP_REQUEST_TYPE=WORP_GBV&|WORP_MPV=ac_gbv&|WORP_USER=admin&|WORP_PASS=&|';

Fernando


Prod WF 8.1.04, QA WF 8.2.03, Dev WF 8.2.03
window.location.href =
'ibi_apps/bid?WORP_REQUEST_TYPE=WORP_GBV&WORP_MPV=ac_gbv&WORP_USER=admin&WORP_PASS=&';


Is this code in the HTMLFORM part of a fex? If so, you may need to separate the & from the variable name or Dialogue Manager will try to substitute &WORPUSER. Try this:

window.location.href =
'ibi_apps/bid?WORP_REQUEST_TYPE=WORP_GBV&|WORP_MPV=ac_gbv&|WORP_USER=admin&|WORP_PASS=the_password';



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
yes, that '|' after the & sign works! thanks.
But! It is not picking up the group view I specified. I am thinking maybe I am missing the &groupName parm. What is this &groupName parm? Is it the href of the domain; ie, xxxxxxx/xxxxxxx.htm? I tried that. It did not work.


wf 7.6.11
unix aix
active reports, HTML, Excel, Text and PDF formats
The Group Name is the MRE Group that the User belongs to, usually a 12 character name beginning with # (don't put the # in the URL).

I have to say I haven't been able to make this work, but we are on 5.3.2 so it could be for newer releases.


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
I am using admin id. I tried the groupName=default%20group. Did not work. Since you mentioned # sign, I am speculating that maybe it is the domain folder href. Tried that. Did not work either. I am on v7.1; so, it is not version issue. I guessed it is not working.


wf 7.6.11
unix aix
active reports, HTML, Excel, Text and PDF formats
Login to MRE. Go to User Administration. Click once on the group Name, then click Properties. The name that must be in the URL is the HREF, but without the #. For "default group", it is "#default", so enter "default" in the URL for &groupName.


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
How about updating your signature with your platform and the version of WebFOCUS?


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
I tried #default (without #). Did not work.
I did also update the platform and version.
What is signature? I do not know what that is.


wf 7.6.11
unix aix
active reports, HTML, Excel, Text and PDF formats
Mike, read this posting from Kerry, the moderator:

Friendly reminder: Please update your signatures


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
As I said, I did update the platform and version info previously. I now also added the output types info. If they are not where they s/b or whatever, you really do have to tell me exactly to put what at where so that I don't have to do this multiple times and yet not where you want.


wf 7.6.11
unix aix
active reports, HTML, Excel, Text and PDF formats
In Kerry's message is a hyperlink to your Profile. Click on it.

On your Profile page is a hyperlink to View/Edit Complete Profile. Click on it.

On your Edit Profile page is a text box called Signature. In the text box enter the suggested information. It appears you have successfully entered the output types you usually work with. Just enter the rest of the info.

Perhaps the text field "WF Production Version" confused you? That is not what's displayed at the bottom of all your postings, the Signature is.

Cheers,


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
exactly! It is confusing to have the text field "WF Production Version" etc. right below the signature box expecting that we repeat the same info there! But, it is now done.


wf 7.6.11
unix aix
active reports, HTML, Excel, Text and PDF formats
Thanks mike!


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