how to code to open a group view in fex

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

Posts: 1903 | Location: San Antonio | Registered: February 28, 2005

Ignored post by Prarie posted

GamP

Virtuoso

posted

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

Posts: 1961 | Location: Netherlands | Registered: September 25, 2007

Ignored post by GamP posted

Platinum Member

posted

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

Posts: 102 | Registered: April 20, 2004

Ignored post by mike posted

Expert

posted

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

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

Ignored post by Francis Mariani posted

Platinum Member

posted

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

Posts: 102 | Registered: April 20, 2004

Ignored post by mike posted

Expert

posted

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

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

Ignored post by Francis Mariani posted

Platinum Member

posted

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

Posts: 102 | Registered: April 20, 2004

Ignored post by mike posted

Fernando

Guru

posted

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

Posts: 278 | Registered: October 10, 2006

Ignored post by Fernando posted

Expert

posted

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

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

Ignored post by Francis Mariani posted

Platinum Member

posted

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

Posts: 102 | Registered: April 20, 2004

Ignored post by mike posted

Expert

posted

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

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

Ignored post by Francis Mariani posted

Platinum Member

posted

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

Posts: 102 | Registered: April 20, 2004

Ignored post by mike posted

Expert

posted

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

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

Ignored post by Francis Mariani posted

Expert

posted

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

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

Ignored post by Francis Mariani posted

Platinum Member

posted

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

Posts: 102 | Registered: April 20, 2004

Ignored post by mike posted

Expert

posted

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

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

Ignored post by Francis Mariani posted

Platinum Member

posted

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

Posts: 102 | Registered: April 20, 2004

Ignored post by mike posted

Expert

posted

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

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

Ignored post by Francis Mariani posted

Platinum Member

posted

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

Posts: 102 | Registered: April 20, 2004

Ignored post by mike posted

Expert

posted

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

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

Ignored post by Francis Mariani posted