Stored Procedure – Client Reference ID
31 July, 2014
Is there a way to filter stored procedure results by Client Reference ID? I am not seeing this as an option when I setup a view using a stored procedure.
Thanks,
Steve
Thanks,
Steve
Hi Steve,
In order to apply a source filter to a Stored Procedure view, you will need to apply it to an actual parameter, not to a column.
E.g.
So in your case, the parameter will link to the Client Ref ID.
From that point, it then functions like a standard access filter.
Please let me know if you have any other questions on this, or run into any issues.
Regards,
David
In order to apply a source filter to a Stored Procedure view, you will need to apply it to an actual parameter, not to a column.
E.g.
So in your case, the parameter will link to the Client Ref ID.
From that point, it then functions like a standard access filter.
Please let me know if you have any other questions on this, or run into any issues.
Regards,
David
Thanks David. I will try this out.
Regards,
Steve
Regards,
Steve