If use Stored Procedure as a Data Source, is Parameter Mandatory?
20 December, 2013
Hi Guys,
How are you going?
I'm using Yellowfin 6.1 and my database is SQL Server 2008.
I would like to use a Stored Procedure as the data source.
And this stored procedure allows the input parameter as null.
However, in Yellowfin, the parameter is mandatory to input before running the Query.
So how can I achieve optional parameter for stored procedure in Yellowfin?
How are you going?
I'm using Yellowfin 6.1 and my database is SQL Server 2008.
I would like to use a Stored Procedure as the data source.
And this stored procedure allows the input parameter as null.
However, in Yellowfin, the parameter is mandatory to input before running the Query.
So how can I achieve optional parameter for stored procedure in Yellowfin?
Hi,
Unfortunately, this is just how it all works in Yellowfin.
Because the Stored proc is used to create the view, there is no way to change the stored procedure when running the report.
When you run the same stored proc in a DB tool, you are usually running the stored proc, and then choosing to ignore the filter. The results are then returned. So this is run differently from YF.
I have raised an enhancement request, as I could see how this would be a useful feature (TASK ID = 152093).
In the meantime, there does not seem to be a way around this in YF.
Apologies for the inconvenience.
Regards,
David
Unfortunately, this is just how it all works in Yellowfin.
Because the Stored proc is used to create the view, there is no way to change the stored procedure when running the report.
When you run the same stored proc in a DB tool, you are usually running the stored proc, and then choosing to ignore the filter. The results are then returned. So this is run differently from YF.
I have raised an enhancement request, as I could see how this would be a useful feature (TASK ID = 152093).
In the meantime, there does not seem to be a way around this in YF.
Apologies for the inconvenience.
Regards,
David
Hi David,
Thanks for the reply.
I see the limitation of the Stored Procedure.
However I just wish Yellowfin could pass NULL to Stored Procedure if I leave it empty when execute the report.
Hope this could be Achieved.
Thanks and Regards,
Andy
Thanks for the reply.
I see the limitation of the Stored Procedure.
However I just wish Yellowfin could pass NULL to Stored Procedure if I leave it empty when execute the report.
Hope this could be Achieved.
Thanks and Regards,
Andy