.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Fast Query Language questions

Posted By:      Posted Date: October 11, 2010    Points: 0   Category :SharePoint


I have some table in MS SQL Table (Id, title, body, creationDate). 

On Fast Search server side after crawling this table with JDBC connector I've mapped 'creationDate' column (as crawled property) to 'Created' managed property.

Now I want to query search web service with FQL query text syntax like this:


   <QueryText type='FQL'>near(cat, dog, N=3) AND... ?


Now, how I can add an expression for querying Created/creationDate values ?

I've been tried 'created:range(.., ..)' , 'Created &gt;= date1 AND Created &lt;= date2', but it always returns SoapException, with details that my query is malformed.


View Complete Post

More Related Resource Links

FAST search query is slow...

Hi, we are using fast search for sharepoint 2010. We are crawling an external data source and this is used for search queries. we have around 30 metadata properties and all are full-text indexed. however, the search operation is slow for a database of 5k records in intranet (webserver and database server are in different geographic regions). typically a 100 item search takes 9-10 sec. it get worse over internet and the search query varies from 10-45 sec for 100 items. Any pointers will be helpful. thanks.  

i can not make query for any information in arabic language

HI,   i work on Sql Developer Edition when i select for any Company name in arabic it does not get any data ,why? although my data are inserted by arabic language,please help me asap,thank youand my code like this use   todayselect CatID from dbo.tbl_Categories where CatName like '%???????%' 

How to Perform Query Side Expansion of Synonyms in FAST Search for SharePoint

Hi, I have added Two Way Synonyms in FAST Search Keywords option in Site Settings. If I type the synonym alone, it works but if I type it with some other keyword, the search results in no hits whereas with the Same Keyword if i give the Main Keyword instead of its synonym, the search is successful. I understand that for this we need to do Query Side Expansion of Synonyms. I also tried to Set a Resubmit Flag to AddSynonymsAutomatically but this also failed. Can u pls suggest a way for this?

FASTSearchQueryException encountered when creating FAST Search query scopes in PowerShell

Hi, I made an update to an existing FAST Search query scopes. The updates are on the ExtendedSearchFilter parameter. Since the Set-SPEnterpriseSearchQueryScope PowerShell cmdlet does not work to update the parameter, I removed the existing scopes using Remove-SPEnterpriseSearchQueryScope and created new scopes using the New-SPEnterpriseSearchQueryScope cmdlets. I have noticed that after creating the scopes, I sometimes encounter the "The search request was unable to execute on FAST Search Server" (FASTSearchQueryException) when executing query against the search scope. I am not sure if the exception is related to how the scope objects are disposed after running the Remove-SPEnterpriseSearchQueryScope cmdlet. I tried to look into the Event logs of the FAST search server but I was not able to see the error. I would like to ask the community if the exception can be attributed to the exsiting scopes that were removed then recreated.  Thanks. Jo-an  

Filter Vs Range - which would be fast in these query?


Hi All,


select {[Measures].[Cost]} on columns, NON EMPTY(filter([CALENDAR].[CALENDAR DATE].[All].children,
CDate([CALENDAR Date].[CALENDAR DATE].Item(0).MemberValue) >= CDate('2010-01-06') and
CDate([CALENDAR Date].[CALENDAR DATE].Item(0).MemberValue) <= CDate('2010-07-25'))) on rows
from (select (
{[Product].[Product TYPE].[STANDARD],[Product].[Product TYPE].[TRIGGERED],[Product].[Product TYPE].[Not Specified]},
{[Account].[ACCOUNT_NAME].[All].children}) on columns
from [Sales])
select {[Measures].[Cost]} on columns, NON EMPTY( 
[CALENDAR].[CALENDAR DATE].[06 Jan 2010]:[CALENDAR].[CALENDAR DATE].[25 Jul 2010]) on rows 
from (select (
{[Product].[Product TYPE]

Sending Query values in Fast queries are getting double escaped



I'm trying to send a query string using javascript to a Search centre Result.aspx page

I'm trying to send a value for s(scope) to search only for Intranet web pages. My when I submit this form I'm getting double escaped.

I'm actually trying to search for sdfsd in Intranet Web Pages scope my query string got converted to this-



%2b = + which I don't want.


jQuery("#QuickSearch").attr("method", "GET");<br/>
  jQuery("#QuickSearch").attr("action", gRes + "/searchcentre/pages/results.aspx");<br/>
  searchterm = trim(jQuery("#searchvalue").val())<br/>
  var validEntryPattern = (searchterm.length > 0);<br/>
  if (validEntryPattern == true) {<br/>

few common questions about Fast Search


Hello everyone!

First, I appologize if I was wrong with choosing subforum. Moderators can feel free to move it to right location.


I'd like to use FAST Search Service without SP Server Search engine.

And I have few basic common questions about my tasks.


My basic aim is to use Fast Search server as a search service without any SharePoint API.

I've found few WCF services already hosted at Fast Search server but those services just provides an API to manage (or administrate) Fast Server. Not to search.

Next thing I've found was QRProxyServer service, but I was unable to connect to any endpoint shared in config file (net.tcp, http, https). There was a different errors but Im sure that I can solve these problems with forum/internet searching.

So now first two questions:

1. Can I use FAST Search Server for seaerching throw its indexes and content without using (referencing) Sharepoint (API/Server/etc) ? If so, is I'm at the right way with QRProxyServer ? 

2. And I'd like to know is there any way to store index data distributedly? I mean if I wanna create index (or crawl rule in common) for august month, I want to store it in 'August' folder. 


With respect,

Query Web Service (FAST FQL) does not deliver the node RefinementResult (or QueryEx vs. Query)?


Hi *,

Looking for some clarification on this topic:

We are using the Query Web Service (search.asmx) from a web part and the web part send FQL formatted queries to the service. (e.g. <QueryText language="en-US" type="FQL">...). I f we execute the query with the method "QueryEx" (this returns a data set) we are able to find a node "<RefinementResults>" in the query result. This node is missing if we are executing the same FQL with the method "Query" (this returns xml) instead of "QueryEx". Is it possible to get this refinement result information also in the result by using the xml based answer? The xml returned by "Query" is much more appreciated as this contains more relevant details for our usage in the application.

Thanks in advance!

Microsoft's Collaborative Application Markup Language (CAML) Loop

discovered an interesting error recently while working with Microsoft's Collaborative Application Markup Language (CAML) that, surprisingly, had received no ink. Partly what surprises me about this is that the error may require you to rewrite large sections of your code if you haven't previously considered this SharePoint limitation. I'll start with some context, but first of all the error is:

MS SQL Server: Search All Tables, Columns & Rows For Data or Keyword Query

If you need to search your entire database for specific data, this query will come in handy.

So when a client needs a custom report or some sort of custom development using Great Plains, most of the time I will have to track down the data in the system by running this query and find the table(s) it is in.

New Language features in .NET4.0

The site explains the new features and enhancement to VB.NET and C# in .NET framework 4.0. The new enhancements are described in detail with examples and code snippets. One can easily understand the new features from this site. This is a must visit site for every .NET professional.

How to Encrypt Query String Parameters in ASP.NET

Encrypt Query String Parameters in ASP.NET.u can send secure data one page another page u can also use query string to encrypt

Content Query Web Part missing in SharePoint 2010

If you don't see content query web part listed in the web parts list, this is because you have not enabled "Search Server Web Parts" feature in site collection features. Enable this feature and content query web part will show in the list of web parts.

C# Interview Questions

C# Interview Questions
This is a list of questions I have gathered from other sources and created myself over a period of time from my experience, many of which I felt where incomplete or simply wrong. I have finally taken the time to go through each question and correct them to the best of my ability. However, please feel free to post feedback to challenge, improve, or suggest new questions. I want to thank those of you that have contributed quality questions and corrections thus far.

There are some question in this list that I do not consider to be good questions for an interview. However, they do exist on other lists available on the Internet so I felt compelled to keep them easy access

Frequently Asked Questions - SQL Server Data Types

This is good and precise introduction and Frequently Asked Questions - SQL Server Data Types

How to Localize Windows Forms and Change the Language at Runtime

Localization is the process of customizing your application to a particular language, culture or locale. Visual Studio provides support for localizing Windows Forms with much ease. In this article, we will see how to localize windows forms and give the user the ability to change to his preferred language at runtime.
When you run a localized application, the appearance is determined by two culture values. The UICulture property is used to specify which resource files will be loaded for the form. The Culture property, on the other hand, determines how strings such as dates, numerals, and currency amounts are formatted.
Let us see the steps required to create a localized form. You can then expand this example and adopt the same approach for the rest of the forms in your project

Voice eXtensible Markup Language


This document specifies VoiceXML, the Voice Extensible Markup Language. VoiceXML is designed for creating audio dialogs that feature synthesized speech, digitized audio, recognition of spoken and DTMF key input, recording of spoken input, telephony, and mixed-initiative conversations. Its major goal is to bring the advantages of web-based development and content delivery to interactive voice response applications.
Status of This Document

This document is a submission to the World Wide Web Consortium from the VoiceXML Forum (see Submission Request, W3C Staff Comment). For a full list of all acknowledged Submission, please see Acknowledged Submissions to W3C.

This document is a Note made available by W3C for discussion only. This work does not imply endorsement by, or the consensus of the W3C membership, nor that W3C has, is, or will be allocating any resources to the issues addressed by the Note. This document is a work in progress and may be updated, replaced, or rendered obsolete by other documents at any time.
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend