Hi ,
I am calling one parameter in another parameter and it is not working. 1st parameter is showing values, while calling the 1st parameter in second it is not showing any values.
Regards,
Sree Hari M
Hi @MSR16
can you try as per below? and see you are able to pass the filter value?
Parameter 1 filter -
SELECT DISTINCT "Inventory - Transactions"."Inventory Org"."Org Name" FROM "Inventory - Transactions" WHERE "Inventory - Transactions"."Inventory Org"."Org Name" NOT LIKE '%STAGE%' ORDER BY 1
Parameter 2:
SELECT DISTINCT "Inventory - Transactions"."Sub Inventory"."Sub Inventory Name" FROM "Inventory - Transactions" WHERE "Inventory - Transactions"."Inventory Org"."Org Name" = @parameter ("ORG")('') AND "Inventory - Transactions"."Inventory Org"."Org Name" NOT LIKE '%STAGE%' ORDER BY 1
Arjun
Hi,
Have you tried Limit Values By to make it dependent as I remember not having access now else could have shared navigation. thanks
Hi Arjun,
I have tried the above solution, but it's not working. One more thing without default value it is not accepting the logical query.
Hi Malik,
If we are using parameters as filters there is no option to set limit values by.
