querytext property comparisons to list people from a department RRS feed

  • Question


    Here is an example I can list people from department "Sales"

    KeyWordQuery q=new KeyWordQuery(context);

    q.QueryText="department : Sales";



    This works perfect. However, I wanted more control over what columns are returned. So, instead of using it as above, I wanted to use a direct sql

    q.QueryText="Select workId,Path,Tithel,Write,Author,HitHighLightedSummary from Scope() where FreeText(defaultProperties,'department : Sales')


    This does not work and returns 0 results. What query should I execute to get the same results as scenario 1?



    Monday, December 10, 2007 6:28 PM


  • Are you sure those aren't column aliases? If they are, you'll need to dig up the real column names for this to work.

    Monday, December 10, 2007 9:34 PM