Don't show current document link in WHERE condition

Jon White asked on October 20, 2014 11:38

Hi there,

I'm linking a repeater to a tag cloud web part and have the following WHERE condition:

DocumentID IN (SELECT DocumentID FROM CMS_DocumentTag WHERE TagID = {?tagid|(toint)?})) OR (DocumentID IN (SELECT DocumentID FROM CMS_DocumentTag WHERE TagID IN (SELECT TagID FROM CMS_Tag WHERE TagName = '{?tagname?}' AND TagGroupID = {?groupid|(toint)?})) AND DocumentID != {% CurrentDocument.ID #%}

This means a user can click a keyword and it show the titles of any documents with the same keyword.

However, each time it shows the title of the current document it's already on (which looks a bit weird).

Is there a way to do the above condition and not show the current document?

Thank you Jon

Recent Answers


Jon White answered on October 20, 2014 11:57

Actually i think i have resolved this apologies

0 votesVote for this answer Mark as a Correct answer

Pavel Janečka answered on October 20, 2014 16:34

Hey Jon, would you mind sharing your solution with others? I am sure others would gladly learn from you! :)

0 votesVote for this answer Mark as a Correct answer

   Please, sign in to be able to submit a new answer.