It seems that in SCIMSchemaAttributeModel, the SchemaId column is not set for subattri

I have tested it and now I can simply do <div class="snippet-clipboard-content not

SCIMSchemaAttributeModel does not always have SchemaId column set about simpleidserver HOT 2 CLOSED

simpleidserver commented on May 16, 2024

SCIMSchemaAttributeModel does not always have SchemaId column set

from simpleidserver.

Comments (2)

simpleidserver commented on May 16, 2024

The SchemaId and RepresentationId columns have been set, you can take the latest version from the branch origin/release/1.1.0.
The release number has been upgrated because we made breaking changes on the database.

Note : the table SCIMSchemaAttribute must be truncated before launching the solution, otherwise the SchemaId column will not be set with the correct value.

from simpleidserver.

bzuidgeest commented on May 16, 2024

I have tested it and now I can simply do

SELECT 
	[SCIMRepresentationLst].Id,
	[SCIMRepresentationLst].ExternalId,
	[SCIMRepresentationAttributeLst].*
	,SCIMRepresentationAttributeValueLst.*
	,SCIMSchemaAttributeModel.*
FROM [SCIM].[dbo].[SCIMRepresentationLst]
	inner join [SCIMRepresentationAttributeLst] on [SCIMRepresentationLst].Id = [SCIMRepresentationAttributeLst].RepresentationId
	inner join SCIMSchemaAttributeModel on [SCIMRepresentationAttributeLst].SchemaAttributeId = SCIMSchemaAttributeModel.Id
	left outer join SCIMRepresentationAttributeValueLst ON [SCIMRepresentationAttributeLst].Id = SCIMRepresentationAttributeValueLst.SCIMRepresentationAttributeId
order by ExternalId

to get all attributes for any model. Much simpler.

from simpleidserver.

Recommend Projects