function readOnly(count){ }
Don't have an account?
Search for an answer or ask a question of the zone or Customer Support.
You need to sign in to do that
Sign in to start searching questions
Signup for a Developer Edition
Sign in to start a discussion
Hi there,
Does anyone have sample of Java code of Query Filter on create date or update date?
Thx
Josh
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;}
THX!
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;
}
THX!