Solved

Quick Report Parameter Questions

  • 25 November 2019
  • 27 replies
  • 10568 views
Show first post

27 replies

Link
Rank
Userlevel 7
Badge +22

Does anyone know how to make a parameter mandatory? By default they are all optional.

Also, is there a way to set a default value for a parameter?

Lastly, is there IFS documentation or a manual on details like this? I’ve seen IFS pages that have general  info, but nothing on technical details like the above or what else is doable/possible. As we start to develop our company’s custom reports I’m getting ideas and would like to know the capabilities and what’s possible with QuickReports.


It is interesting.

Is it possible to use this in lobbies?

For example:

 

Kind regards
JohannesKnust
Rank
Userlevel 4
Badge +11

@durette nice approach! 

I used your regex and placed it in a query like this. 
Thanks again

SELECT order_no
  FROM IFSAPP.SHOP_ORD

 where order_no IN
       (SELECT REGEXP_SUBSTR(d__.str, '[^;]+', 1, LEVEL) AS val_
          FROM (SELECT '&[-C--L]Param1' AS str FROM DUAL) d__
        CONNECT BY LEVEL <= REGEXP_COUNT(d__.str, ';') + 1)

 

Reply


Terms & ConditionsCookie settings