Skip to main content
Solved

User prompts in SQL type quick reports

  • January 23, 2025
  • 4 replies
  • 134 views
R
Do Gooder (Partner)
Forum|alt.badge.img+2

Hi,

We have number of SQL quick reports in cloud with user prompts (parameters). For an example we have defined it in the sql query where condition as below,

‘&DATE_FROM’ So, in the cloud application Parameter page the label text is also shown as DATE_FROM. We simply want to appear this label text as Date From. Basically what we need to do is to remove the _ with a space. I know this works from the database side if we make it as ‘&Date From’. But when we execute from the cloud application it fails. Is there a way to achieve this?

 

Thanks

Roshanga

 

Best answer by JohannesKnust

hi ​@roshanga1 thanks for reaching out. Of course we are easily able to modify it according to your needs. An German example (not a column name): 

It’s From & To (date)


Never stop when someone says no; until someone else comes and just does it :)

Your Where clause should be like: 

select *
  from inventory_part
 where CREATE_DATE = to_date('&To Date', 'dd.mm.yy')

The result is: 

 

4 replies

R
Do Gooder (Partner)
Forum|alt.badge.img+2
  • roshanga1
  • Author
  • Do Gooder (Partner)
  • January 27, 2025

​@Jonas Feigl ​@JohannesKnust Do you have an idea?

Jonas Feigl
Superhero (Employee)
Forum|alt.badge.img+20
  • Jonas Feigl
  • Superhero (Employee)
  • January 27, 2025

​@roshanga1 I’m not aware of any way to achieve this at the moment. You used to be able to do things like ‘&FND_USER.VALID_FROM’ in IFSAPP10 which would give you the label of the view field but this doesn’t seem to be supported in IFS Cloud anymore which is a shame.

JohannesKnust
Hero (Partner)
Forum|alt.badge.img+12
  • JohannesKnust
  • Hero (Partner)
  • Answer
  • January 29, 2025

hi ​@roshanga1 thanks for reaching out. Of course we are easily able to modify it according to your needs. An German example (not a column name): 

It’s From & To (date)


Never stop when someone says no; until someone else comes and just does it :)

Your Where clause should be like: 

select *
  from inventory_part
 where CREATE_DATE = to_date('&To Date', 'dd.mm.yy')

The result is: 

 

R
R
Do Gooder (Partner)
Forum|alt.badge.img+2
  • roshanga1
  • Author
  • Do Gooder (Partner)
  • January 29, 2025

hi ​@roshanga1 thanks for reaching out. Of course we are easily able to modify it according to your needs. An German example (not a column name): 

It’s From & To (date)


Never stop when someone says no; until someone else comes and just does it :)

Your Where clause should be like: 

select *
  from inventory_part
 where CREATE_DATE = to_date('&To Date', 'dd.mm.yy')

The result is: 

 

Amazing!! Thanks Johannes

JohannesKnust
Terms & ConditionsCookie settingsAccessibility statement