Skip to main content
Solved

Lobby Element - Title to show parameter description

  • January 27, 2020
  • 3 replies
  • 396 views

Forum|alt.badge.img+5
  • Sidekick (Customer)
  • 22 replies

I have a lobby element which uses year period as a parameter, is there a way to have the description show in the title, rather than just the year period.

e.g. if I enter ($YEAR_PERIOD$) in the title, it correctly shows 2020-07, but I’d like it to show January 2020.

 

Is there a way to use a SQL query in the title?

Best answer by PRODQ

You could add the date “conversion” to the source view as a custom field and then develop the lobby data source using the “cfv” view so you can incorporate the custom field OR add it as follows:

 

Hope this helps…

 

Linda

View original
Did this topic help you find an answer to your question?

3 replies

PRODQ
Superhero (Customer)
Forum|alt.badge.img+17
  • Superhero (Customer)
  • 473 replies
  • January 28, 2020

Is this any help?  It converts ‘7’ to ‘July’

select TO_CHAR(TO_DATE(7, 'MM'), 'Month') from dual

 

 

Linda


Forum|alt.badge.img+5
  • Author
  • Sidekick (Customer)
  • 22 replies
  • January 29, 2020

Thanks PRODQ  for your reply. I can’t seem to get it to accept any SQL in the title, unless there is a particular way to format it. Period 7 is also January rather than July, as it is Financial Year Jul-Jun, so the month option wouldn’t work.


PRODQ
Superhero (Customer)
Forum|alt.badge.img+17
  • Superhero (Customer)
  • 473 replies
  • Answer
  • January 30, 2020

You could add the date “conversion” to the source view as a custom field and then develop the lobby data source using the “cfv” view so you can incorporate the custom field OR add it as follows:

 

Hope this helps…

 

Linda


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings