You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
66 lines
1.3 KiB
66 lines
1.3 KiB
IF OBJECT_ID('[dbo].[Collection_ReadByUserId]') IS NOT NULL |
|
BEGIN |
|
DROP PROCEDURE [dbo].[Collection_ReadByUserId] |
|
END |
|
GO |
|
|
|
CREATE PROCEDURE [dbo].[Collection_ReadByUserId] |
|
@UserId UNIQUEIDENTIFIER |
|
AS |
|
BEGIN |
|
SET NOCOUNT ON |
|
|
|
SELECT |
|
Id, |
|
OrganizationId, |
|
[Name], |
|
CreationDate, |
|
RevisionDate, |
|
ExternalId, |
|
MIN([ReadOnly]) AS [ReadOnly], |
|
MIN([HidePasswords]) AS [HidePasswords] |
|
FROM |
|
[dbo].[UserCollectionDetails](@UserId) |
|
GROUP BY |
|
Id, |
|
OrganizationId, |
|
[Name], |
|
CreationDate, |
|
RevisionDate, |
|
ExternalId |
|
END |
|
GO |
|
|
|
IF OBJECT_ID('[dbo].[Collection_ReadByIdUserId]') IS NOT NULL |
|
BEGIN |
|
DROP PROCEDURE [dbo].[Collection_ReadByIdUserId] |
|
END |
|
GO |
|
|
|
CREATE PROCEDURE [dbo].[Collection_ReadByIdUserId] |
|
@Id UNIQUEIDENTIFIER, |
|
@UserId UNIQUEIDENTIFIER |
|
AS |
|
BEGIN |
|
SET NOCOUNT ON |
|
SELECT |
|
Id, |
|
OrganizationId, |
|
[Name], |
|
CreationDate, |
|
RevisionDate, |
|
ExternalId, |
|
MIN([ReadOnly]) AS [ReadOnly], |
|
MIN([HidePasswords]) AS [HidePasswords] |
|
FROM |
|
[dbo].[UserCollectionDetails](@UserId) |
|
WHERE |
|
[Id] = @Id |
|
GROUP BY |
|
Id, |
|
OrganizationId, |
|
[Name], |
|
CreationDate, |
|
RevisionDate, |
|
ExternalId |
|
END
|
|
|