Search data between startDate and endDate in SilverLight Application.

Question

I am looking for sample code to search the query task data between dates. Any helps is appreciated.

DominiqueBroux · Answer

//This query cannot return the records even though they existed in database
string querySearch = "TIME_FINISH >= TO_DATE(dtStartDate, 'MM/DD/YYYY HH:MI:SS AM')";

The server doesn't know your 'dtStartDate' variable so you have to replace it by its value:
 
string querySearch = "TIME_FINISH >= TO_DATE('" +
dtStartDate.ToString("MM/dd/yyyy hh:mm:ss tt") +
"', 'MM/DD/YYYY HH:MI:SS AM')";

AnhTruong · Answer

Hi,

I am still searching for ArcGIS query expertise, but I can narrow down what I need to help for my search engine as following:

string paramStartDate;
paramStartDate = txtStartName.Text;
            
DateTime dtStartDate = Convert.ToDateTime(paramStartDate);

// if I selected the date from DatePicker is 7/30/2010, I can trace the selected value using VS 2010 //debugging with System.DateTime datatype {7/30/2011 12:00:00 AM}

QueryTask queryTask = new QueryTask(URLService);
queryTask.ExecuteCompleted += QueryTask_ExecuteCompleted;
queryTask.Failed += QueryTask_Failed;

ESRI.ArcGIS.Client.Tasks.Query query = new ESRI.ArcGIS.Client.Tasks.Query();
query.OutFields.Add("*");
//This query cannot return the records even though they existed in database
   string querySearch = "TIME_FINISH >= TO_DATE(dtStartDate, 'MM/DD/YYYY HH:MI:SS AM')";
// but this query is working if I do hard code
//string querySearch = "TIME_FINISH >= TO_DATE('7/30/2011 12:00:00 PM', 'MM/DD/YYYY HH:MI:SS AM')";

query.Where = querySearch;              
queryTask.ExecuteAsync(query);

How do I pass actual value to dtStartDate when doing query???

AnhTruong · Answer

Hi,

I am still searching for ArcGIS query expertise, but I can narrow down what I need to help for my search engine as following:

string paramStartDate;
paramStartDate = txtStartName.Text;
            
//string querySearch = "TIME_OPEN >= TO_DATE('7/30/2011 12:00:00 PM', 'MM/DD/YYYY HH:MI:SS AM')";
            
            DateTime dtStartDate = Convert.ToDateTime(paramStartDate);
            DateTime dtEndDate = Convert.ToDateTime(paramEndDate);

QueryTask queryTask = new QueryTask(URLService);
            queryTask.ExecuteCompleted += QueryTask_ExecuteCompleted;
            queryTask.Failed += QueryTask_Failed;

ESRI.ArcGIS.Client.Tasks.Query query = new ESRI.ArcGIS.Client.Tasks.Query();
            query.OutFields.Add("*");
            //This query cannot return the records even though they existed in database
            string querySearch = "TIME_FINISH >= TO_DATE(dtStartDate, 'MM/DD/YYYY HH:MI:SS AM')";

//string querySearch = "TIME_FINISH >= TO_DATE('7/30/2011 12:00:00 PM', 'MM/DD/YYYY HH:MI:SS AM')";
            query.Where = querySearch;
              
            queryTask.ExecuteAsync(query);