Five New Optimizely Certifications are Here! Validate your expertise and advance your career with our latest certification exams. Click here to find out more

Handling attributes in custom made query class

Vote:
 
Hi,
I have created a custom subclass of TopicQuery and need to know how to pass attributes to the sql below:
public class MyTopicQuery : TopicQuery
{		
public override string GetQuery()
{
return @"select topic FROM EPiServer.Community.Forum.Topic as topic where topic['TheAttributeName'] = '" + ?? +"'";
	}
}
 
-------------------------------------
This is how I pass the attribute parameter
.
.
var rq = new MyTopicQuery();
var MyCriteria = new StringCriterion();

MyCriteria.Value = "hello world";
rq["TheAttributeName"] = MyCriteria;
..
----------------------------------
How do I do this? Any ideas are welcomed.
 
/Sang
 
#56402
Jan 20, 2012 10:55
Vote:
 

Case closed, by implementing the query in the "ordinary" way you can get the query by calling the GetQuery() method and customize it the way you want.

#56446
Jan 20, 2012 15:44
This thread is locked and should be used for reference only. Please use the Legacy add-ons forum to open new discussions.
* You are NOT allowed to include any hyperlinks in the post because your account hasn't associated to your company. User profile should be updated.