Solved

Make input mandatory in quick report

  • 8 March 2023
  • 7 replies
  • 139 views
Link
Rank
Userlevel 7
Badge +22
  • Link
  • Superhero (Customer)
  • 949 replies

Hi everybody,

I am trying to create a quick report in IFS Apps10. It is important to make the inpurt mandatory.

Generally, I use the marked parameters. But in oracle 14 it doesn’t work anymore.

SELECT * FROM ifsapp.customer_order
WHERE order_no LIKE '&[MCSBL]ORDER_NO'

Can anyone confirm this?

Did the change something?

icon

Best answer by Link 9 March 2023, 15:07

View original
Kind regards

7 replies

Link
Rank
Userlevel 7
Badge +22

I’ve just found the solution.

It works in IFS only  and isn’t a part of PL/SQL.

Kind regards
T
Rank
Badge +1

Hi,

What is the solution?

 

Regards,

 

Link
Rank
Userlevel 7
Badge +22

Hi @TecAkshaK 

the solution ist to avoid this in PL/SQL developer: '&[MCSBL]ORDER_NO'

But if you create a quick report in IFS you can use it there.

Kind regards
T
Rank
Badge +1

Hi @Link ,

Thanks for quick response.

But , this does not seem to be working in IFS 8. But works in IFS 9.

Is it available in IFS 8?

 

Kind Regards

Link
Rank
Userlevel 7
Badge +22

Hi @TecAkshaK 

I am sure it works in APPS9 and 10. In APPS8 I am not sure. 

Don’t put it in the SQL code - only in the quick report in IFS.

Kind regards
T
Rank
Badge +1

Hi @Link,

Yes, I put it only in quick report in IFS 8, it didn't work.

I guess, it works from IFS 9 onwards.

Thanks again for your help 🙂

 

Kind Regards

Link
Rank
Userlevel 7
Badge +22

Hi @Link,

Yes, I put it only in quick report in IFS 8, it didn't work.

I guess, it works from IFS 9 onwards.

Thanks again for your help 🙂

 

Kind Regards

 

Then you are right.

You are welcome. 😊

Kind regards

Reply


Terms & ConditionsCookie settings