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     DevStudio multiselect combobox to select column from a table

Read-Only Read-Only Topic
Go
Search
Notify
Tools
DevStudio multiselect combobox to select column from a table
 Login/Join
 
Sayed
Guru
posted
How can I select colums from a table so that those are the mutiselect items in a combobox?

Example:
I am trying to PRINT columns COUNTRY, CAR, D_COST and MODEL from CAR table. I want the combobox to be filled with all the column name from CAR table i.e. COUNTRY, CAR, D_COST, R_COST, MODEL, etc... The user should be able to select 1 or more colums from the combobox and depending on the selection, x amount of colums should appear on the report.


WF 8.x and 7.7.x Win/UNIX/AS400, MRE/Portal/Self-Service, IIS/Tomcat, WebSphere, IWA, Realmdriver, Active Directory, Oracle, SQLServer, DB2, MySQL, JD Edwards, E-BIZ, SAP BW, R/3, ECC, ESSBASE
 
Posts: 285 | Location: Texas | Registered: June 27, 2006Report This Post
Alan B
Virtuoso
posted Hide Post
If you are using HTML painter, create a focexec:
CHECK FILE filename HOLD
TABLE FILE HOLD
BY FIELDNAME
ON TABLE PCHOLD FORMAT XML
END

and attach that to a multi-select.

Then create a report using the parameters (field names) passed from the multi-select.

The same type of request can be run for self service also, but using the methods often quoted in FP for creating your list box.


Alan.
WF 7.705/8.007
 
Posts: 1451 | Location: Portugal | Registered: February 07, 2007Report This Post
FrankDutch
Virtuoso
posted Hide Post
Simple but smart solution Alan....

I will keep this in mind.




Frank
prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7

 
Posts: 2387 | Location: Amsterdam, the Netherlands | Registered: December 03, 2006Report This Post
Sayed
Guru
posted Hide Post
Thank you Alan. That did allow me to populate my list box with field names. Now how do I multi select those field names and generate colums on my report based on my selection?

This is the approach I am taking:
1) form- create html file that points to fex1 to dynamically populate the column title. then have a submit button that will submit the values to fex2.

2) fex1- is where hold the fieldname as you suggested

3) fex2- is where I am planning to display fields according to my selection from my form.

I am failing to see how I would create fex2 so that the values from the form can be submitted and appropriate columns show up on the report.


WF 8.x and 7.7.x Win/UNIX/AS400, MRE/Portal/Self-Service, IIS/Tomcat, WebSphere, IWA, Realmdriver, Active Directory, Oracle, SQLServer, DB2, MySQL, JD Edwards, E-BIZ, SAP BW, R/3, ECC, ESSBASE
 
Posts: 285 | Location: Texas | Registered: June 27, 2006Report This Post
Sayed
Guru
posted Hide Post
Okey, this seems to work unless you only select 1 value or ALL option. Code needs to be changed for those.

-TYPE &FIELDS

-* Remove OR from the &FIELDS
-SET &FIELDS_LENGTH = &FIELDS.LENGTH;
-SET &FIELDS1 = STRREP (&FIELDS_LENGTH, &FIELDS, 6, ''' OR ''', 2, ' @', &FIELDS_LENGTH, 'A&FIELDS_LENGTH.EVAL');
-SET &FIELDS2 = STRIP(&FIELDS_LENGTH, &FIELDS1, '@', 'A&FIELDS_LENGTH.EVAL');
-SET &FIELDS3 = STRIP(&FIELDS_LENGTH, &FIELDS2, '''', 'A&FIELDS_LENGTH.EVAL');

-TYPE &FIELDS1
-TYPE &FIELDS2
-TYPE &FIELDS3


TABLE FILE CAR
PRINT &FIELDS3.EVAL
END


WF 8.x and 7.7.x Win/UNIX/AS400, MRE/Portal/Self-Service, IIS/Tomcat, WebSphere, IWA, Realmdriver, Active Directory, Oracle, SQLServer, DB2, MySQL, JD Edwards, E-BIZ, SAP BW, R/3, ECC, ESSBASE
 
Posts: 285 | Location: Texas | Registered: June 27, 2006Report 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     DevStudio multiselect combobox to select column from a table

Copyright © 1996-2020 Information Builders