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.
Best answer by Banu Liyanapathirana
Hi
I believe you are referring to SQL quick reports.
If so, you can do this by using Query flags.
This allows an easy control of end user input and allows or disallows certain combinations. You need to provide the query flags inside open and close square braces in between the ampersand sign and the parameter name;
e.g. &[mcsbl]PARAMETER_NAMEAll flags have opposites specified by a '-' (minus). For example the opposite of 'Single' is of course multiple values (separated by ';') which in turn corresponds to the functionality in the Query Dialog. The default value for SQL Quick Reports is [-CS-L].
See the example below;
SELECT * FROM fnd_user WHERE identity LIKE '&[-CS-L]Fnd_User'
This is how you can set a default value;
You can get the Quick Report parameter dialog to show default values such as enumerations for SQL type Quick Reports. For this you need to specify the view name along with the column name for the parameter prompt e.g. &VIEW_NAME.COLUMN_NAME. With the use of this you will get the default values and the translated prompt name for the parameter. The following will show the enumerated values for the "Customer Category" and will have the translated parameter prompt.
SELECT * from customer_info where customer_category_db = '&CUSTOMER_INFO.CUSTOMER_CATEGORY_DB'You can combine this with Query Flags as well.
SELECT * from customer_info where customer_category_db LIKE '&[-CS--]CUSTOMER_INFO.CUSTOMER_CATEGORY_DB'This information can be found in the F1 development guide;
Foundation1 / Development Guide / Business report and Analysis Specific Development / Adhoc Reporting / Development of Quick reports
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:
+12
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)
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.