USP_DATALIST_PRINTMEMBERSHIPCARDSPROCESS

A datalist of saved print membership cards process parameter sets.

Parameters

Parameter	Parameter Type	Mode	Description
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.

Definition

Copy



                    CREATE procedure dbo.USP_DATALIST_PRINTMEMBERSHIPCARDSPROCESS
                    (
                        @CURRENTAPPUSERID uniqueidentifier = null
                    )
                    as
                        set nocount on;

                        select
                            P.ID,
                            P.NAME,
                            P.DESCRIPTION,
                            case
                                when P.LETTERTEMPLATEID is null then P.MEMBERSHIPCARDFORMAT
                                else dbo.UFN_LETTERTEMPLATE_GETNAME(P.LETTERTEMPLATEID)
                            end as MEMBERSHIPCARDFORMAT,
                            BPI.OWNERID
                        from
                            dbo.PRINTMEMBERSHIPCARDSPROCESS P
                        left outer join
                            dbo.BUSINESSPROCESSINSTANCE BPI
                                on P.ID = BPI.BUSINESSPROCESSPARAMETERSETID
                        where 
                            dbo.UFN_SECURITY_APPUSER_GRANTED_BUSINESSPROCESSINSTANCE_IN_SYSTEMROLE(@CURRENTAPPUSERID, P.ID) = 1
                            and ISHIDDEN = 0
                        order by
                            P.DATEADDED