public FullTextSqlQueryInstance(ScriptEngine engine, FullTextSqlQuery fullTextSqlQuery) : base(new QueryInstance(engine, fullTextSqlQuery), fullTextSqlQuery) { m_fullTextSqlQuery = fullTextSqlQuery; this.PopulateFunctions(); }
public static DataTable ExecuteQuery(string SiteCollection, string QueryString) { SPSite col = new SPSite(SiteCollection); ServerContext ctx = ServerContext.GetContext(col); FullTextSqlQuery ftq = new FullTextSqlQuery(ctx); ftq.ResultTypes = ResultType.RelevantResults; ftq.EnableStemming = true; ftq.TrimDuplicates = true; ftq.QueryText = QueryString; ResultTableCollection allresults = ftq.Execute(); ResultTable relevant = allresults[ResultType.RelevantResults]; DataTable dt = null; if (relevant.RowCount > 0) { dt = new DataTable("Search Result"); dt.Columns.Add("Title"); dt.Columns.Add("URL"); while (relevant.Read()) { DataRow row = dt.NewRow(); row[0] = relevant.GetString(0); row[1] = relevant.GetString(1); dt.Rows.Add(row); } } return(dt); }
private static ResultTable RealizarBusqueda(string guid) { FullTextSqlQuery query = new FullTextSqlQuery(new SPSite(urlBusqueda)); ResultType resultType = ResultType.RelevantResults; string strQuery = String.Format("SELECT Title, Path, Fecha FROM SCOPE() WHERE (\"" + property + "\"='#{0}')", guid); FullTextSqlQuery fullTextSqlQuery = new FullTextSqlQuery(new SPSite(urlBusqueda)); fullTextSqlQuery.QueryText = strQuery; fullTextSqlQuery.ResultTypes = resultType; fullTextSqlQuery.RowLimit = 0; fullTextSqlQuery.TrimDuplicates = false; ResultTableCollection resultTableCollection = fullTextSqlQuery.Execute(); ResultTable resultTable = resultTableCollection[resultType]; return(resultTable); }
public IEnumerable <IncidentTask> GetAllOpenIncidentTasks() { FullTextSqlQuery sqlQuery = new FullTextSqlQuery(ServerContext.Current); sqlQuery.QueryText = Resources.PartnerRollupFullTextQuery; sqlQuery.ResultTypes = ResultType.RelevantResults; // Write the query to the trace log, so developers can debug it more easily. ILogger logger = SharePointServiceLocator.Current.GetInstance <ILogger>(); logger.TraceToDeveloper( string.Format(CultureInfo.CurrentCulture, Resources.IncidentTasksFullTextSqlQuery, sqlQuery.QueryText)); ResultTableCollection queryResults = sqlQuery.Execute(); DataTable resultsTable = new DataTable(); resultsTable.Locale = CultureInfo.CurrentCulture; resultsTable.Load(queryResults[ResultType.RelevantResults]); List <IncidentTask> results = new List <IncidentTask>(); foreach (DataRow datarow in resultsTable.Rows) { IncidentTask result = new IncidentTask(); result.Path = datarow[PathField] == DBNull.Value ? string.Empty : (string)datarow[PathField]; result.Title = datarow[TitleField] == DBNull.Value ? string.Empty : (string)datarow[TitleField]; result.AssignedTo = datarow[AssignedToField] == DBNull.Value ? string.Empty : (string)datarow[AssignedToField]; // For some reason, the the Status field is returned as an array of strings. The status can be accessed // using the index 0. result.Status = datarow[StatusField] == DBNull.Value ? string.Empty : ((string[])datarow[StatusField])[0]; result.Priority = datarow[PriorityField] == DBNull.Value ? string.Empty : (string)datarow[PriorityField]; results.Add(result); } return(results); }
private void btnSearch_Click(object sender, EventArgs e) { SPSite col = new SPSite(txtSC.Text); ServerContext ctx = ServerContext.GetContext(col); DropDownHelper <Scope> dds = (DropDownHelper <Scope>)cbScope.SelectedItem; string ScopeName = dds.Item.Name; string query = "Select title, url FROM Scope() where \"Scope\" = '" + ScopeName + "' AND Freetext('" + txtPhrase.Text + " ')"; FullTextSqlQuery ftq = new FullTextSqlQuery(ctx); ftq.ResultTypes = ResultType.RelevantResults; ftq.EnableStemming = true; ftq.TrimDuplicates = true; ftq.QueryText = query; ResultTableCollection allresults = ftq.Execute(); ResultTable relevant = allresults[ResultType.RelevantResults]; DataTable dt = null; if (relevant.RowCount > 0) { dt = new DataTable("Search Result"); dt.Columns.Add("Title"); dt.Columns.Add("URL"); while (relevant.Read()) { DataRow row = dt.NewRow(); row[0] = relevant.GetString(0); row[1] = relevant.GetString(1); dt.Rows.Add(row); } gvResult.DataSource = dt; gvResult.AutoResizeColumns(); } }
public FullTextSqlQueryInstance(ObjectInstance prototype, FullTextSqlQuery fullTextSqlQuery) : base(prototype, fullTextSqlQuery) { m_fullTextSqlQuery = fullTextSqlQuery; }