Hello,
We are showing articles having title with different language in the repeater. When click on the title the landing page is displaying more than 1 articles instead only that particular article. This is the query is getting formed.
DECLARE @NodeSiteID int = 2; DECLARE @NodeAliasPath nvarchar(max) = N'/Forms/សេចកតជនដណងអពការដាកការសកសាអបរដែលបានផដលអនសាសន-ការជនដ'; DECLARE @DocumentCulture nvarchar(max) = N'en-us'; SELECT [DocumentCulture], [NodeID], [NodeLinkedNodeID], [NodeSiteID], [ClassName], [NodeLevel], [NodeOrder], [NodeParentID], [DocumentCheckedOutVersionHistoryID] FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN custom_forms AS C WITH (NOLOCK) ON [V].[DocumentForeignKeyValue] = [C].[FormsID] AND V.ClassName = N'custom.forms' LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON [V].[NodeSKUID] = [S].[SKUID] WHERE [NodeSiteID] = @NodeSiteID AND ([NodeAliasPath] = @NodeAliasPath AND [DocumentCulture] = @DocumentCulture) @NodeSiteID (2) @NodeAliasPath ("/Forms/សេចកតជនដណងអពការដាកការសកសាអបរដែលបានផដលអនសាសន-ការជនដ") @DocumentCulture ("en-us")
URL look like below localhost:1000/Forms/សេចកតជនដណងអពការដាកការសកសាអបរដែលបានផដលអនសាសន-ការជនដ
localhost:1000/Forms/សេចកតជនដណងអពការដាកការសកសាអបរដែលបានផដលអនសាសន-ការជនដ
Could you please let me know why this behavior?
Thanks.
How many records are returned when you run the SQL query over the DB directly? What is the entire repeater web part setup and what transformation is used - the default one and also selected item transformation?
Please, sign in to be able to submit a new answer.