function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Josh M.Josh M. 

Query Filter on Dates...

Hi there,

Does anyone have sample of Java code of Query Filter on create date or update date?

Thx

Josh

DevAngelDevAngel

Hi Josh,

Try this:

 void testQuery(Object[] SelectList) throws TransformerException, IOException
 {
   Object[] filter = new Object[1]; //Final filter array

   //Create simple filter
   Date thresholdDate = new Date(2003, 6, 1);
   java.lang.String[] selectList = new java.lang.String[3];
   selectList[0] = "id";
   selectList[1] = "lastName";
   selectList[2] = "firstName";

   filter[0] = makeSimpleFilter("createdDate", thresholdDate, "greater than");
   org.w3c.dom.Element value = (org.w3c.dom.Element)binding.query("filter", "contact", 10, selectList, filter, null, null, false);
   org.w3c.dom.NodeList nodes = XPathAPI.selectNodeList(value, "/value/valueMap/*/text()");

   java.lang.String fieldName = "";
   java.lang.String fieldValue = "";

   for (int i = 0; i < nodes.getLength(); i++) {
     org.w3c.dom.Node vNode = nodes.item(i);
     if (nodes.item(i) != null) {
  fieldName = nodes.item(i).getParentNode().getNodeName();
  fieldValue = nodes.item(i).getNodeValue();
       System.out.println("field: " + fieldName + " has a value of " + fieldValue + ".");
     }
   }

   if (nodes.getLength()>0) {
     java.lang.int recordCount = XPathAPI.selectNodeList(value, "/value/valueMap").getLength();
     System.out.println("");
     System.out.println("Total of " + recordCount + " contacts found.");
   }
}

private MapEntry makeMapEntry(String key, Object objValue)
{
  MapEntry me = new MapEntry();
  me.setKey(key);
  me.setValue(objValue);
  return me;
}
 
private salesforce.MapEntry[] makeSimpleFilter(String field, Object value, String operator)
{
  salesforce.MapEntry[] filter = new salesforce.MapEntry[3];

  filter[0] = makeMapEntry("field", field);
  filter[1] = makeMapEntry("operator", operator);
  filter[2] = makeMapEntry("value", value);
  return filter;
}

Josh M.Josh M.

THX!