Skip to main content

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

 

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

​@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.

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: 

 

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

Reply


Terms & ConditionsCookie settings