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.
How to add feature to pick up time in a report like Date Picker in Autoprompt if date field is formatted HYYMD?This message has been edited. Last edited by: FP Mod Chuck,
As far as I know there is no auto prompt for time. A calendar widget exist for date but not for time. You will have to define it yourself. The date format HYYMD will not give you the ability to have a time picker.
Assuming that you need hours only, you can create a fex that will populate all the hours (01:00 thru 24:00) into an xml file and then reference that file in your hour auto prompt drop down list. If you need to also "play" with minutes and seconds, then it's going to be much more complex.
You first need to clearly define the needs to understand why you need a time picker and at which level : HH, HHMM, HHMMSS Maybe we can have alternatives for you instead of using a time picker...
WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF In Focus since 2007
Posts: 2409 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013
Hi Martin, The calendar widget can give you both Date and Time option if you select the date format in source to date time. But yes there is not widget for just time.
WF 8.2.04 Windows/Unix All Formats In Focus since 2006
Posts: 74 | Location: UK | Registered: September 17, 2018
Hi Addy: I have an HYYMDS column in my data and have a report with a simple prompt for that field. When I run the report Autoprompt only gives me a Calendar. Are you talking about Autoprompt or an HTML page created by Composer?
WebFOCUS 8206, Unix, Windows
Posts: 1853 | Location: New York City | Registered: December 30, 2015
Hi BabakNYC, I was talking about the HTML composer. Auto prompt doesnt have any time as you and Martin said. Also there is no widget just for Time in the compose.
WF 8.2.04 Windows/Unix All Formats In Focus since 2006
Posts: 74 | Location: UK | Registered: September 17, 2018