Download on GitHub

postQueryFMS(query, callBackOnReady[, callBackOnDownload, phpRelay, resultClass, max, nestPortals])

{ 
	"id" : {
		"idFieldName":"id", // filemaker field name is "id" 
		"getValue" : function(f){ // method name must be getValue.
			var field = this["idFieldName"]; //retrieve our field name
			return f(field); //retrieve the filemaker field value
		}, // end method
	}, // end property
}

{
	"allDay" : {
		"timeStartFieldName" : "TimeStart", //field for start time, 
		"getValue" : function(f){
			var field = this["timeStartFieldName"];
			if(f(field).length){  //we have a start time so this is false
				return false;
			}
			else{  //if empty, event is all day
				return true;
			};
		}, // end getValue method
	}, // end property
}

var requests =	[ //create requests for query
	{ "DateStart" : "<=2/28/2014" , "DateEnd" : ">=2/1/2014" },
	{ "DateStart" : "2/1/2014...2/28/2014" }
				];
var query = fmxj.findRecordsURL("Events", "Events", requests) ; // create query

function onReadyFuntion(js){ //define handler for onready
	document.getElementById("example1") = JSON.stringify(js, null, 4);
} ;
function onProgressFuntion(n){ //define handler for onprogress
	document.getElementById("example1") += n + " bytes downloaded\n";
} ;
fmxj.postQueryFMS(query, onReadyFunction, onProgressFunction); //make call

var sourceLoop = [];
var requests =	[ //create requests for query
	{ "DateStart" : "<=2/28/2014" , "DateEnd" : ">=2/1/2014" },
	{ "DateStart" : "2/1/2014...2/28/2014" }
				];
var sortObject = { 
	"field1" : "DateStart" ,
	"order1" : "ascend" ,
				 } ;
var query = fmxj.findRecordsURL("Events", "Events", requests) ; // create query
function onReadyFuntion(js){ //define handler for onready
	//callBack will return pages recursively, so concat to our array.
	sourceLoop = sourceLoop.concat(js);
	document.getElementById("example1") = JSON.stringify(sourceLoop, null, 4);
};
// for 375 results per page (max) we don't need an onProgress handler, so we'll set to null.
fmxj.postQueryFMS(query, onReadyFunction, null, relay, null, 375); //make call

var query = fmxj.findRecordsURL("Events", "ShmEvents", requests) ;
fmxj.postQueryFMS(query, onReadyFunction) ;

var query = fmxj.findRecordsURL("Contacts", "Contacts");
fmxj.postQueryFMS(q, writeResults, writeDownload, relay, null, 1000, true);

var fcObject = 	{
	"id" : {
			"idField":"id",
			"getValue" : function(f){
				var field = this["idField"];
				return f(field);
			},
		},
	"title" : {
			"titleField":"Summary",
			"getValue" : function(f){
				var field = this["titleField"];
				return f(field);
			},
		},
	"allDay" : {
			"timeStartField" : "TimeStart",
			"getValue" : function(f){
				var field = this["timeStartField"];
				if(f(field).length){//we have a start time so this is false
					return false;
				}
				else{
					return true;
				}
			},
		},
	"start" : {
		"timeStartField" : "TimeStart",
		"dateStartField" : "DateStart",
		"yearFormat" : "MM-DD-YYYY",
		"timeFormat" : "HH:mm",
		"timezone" : "America/Los_Angeles",
		"getValue" : function(f){
			var time = this["timeStartField"];
			var date = this["dateStartField"];
			var zone = this["timezone"];
			var yearFormat = this["yearFormat"];
			var timeFormat = this["timeFormat"];
			var date = moment( f(date) + " " + f(time) , yearFormat + " " + timeFormat );
			return date.tz(zone).format();
		},
	},
	"end" : {
		"timeEndField" : "TimeEnd",
		"dateEndField" : "DateEnd",
		"dateStartField" : "DateStart", //if no end date is specified we'll need to use the start date.
		"yearFormat" : "MM-DD-YYYY",
		"timeFormat" : "HH:mm",
		"timezone" : "America/Los_Angeles",
		"getValue" : function(f){
			var time = this["timeEndField"];
			var date = this["dateEndField"];
			var sdate = this["dateStartField"];
			var zone = this["timezone"];
			var yearFormat = this["yearFormat"];
			var timeFormat = this["timeFormat"];
			//use start date if no end date
			if(!f(date)){ var d = f(sdate) } else { var d = f(date)};
			if(f(time).length){
				d = moment( d + " " + f(time) , yearFormat + " " + timeFormat );
			}
			else
			{
				d = moment( d , yearFormat + " " + timeFormat ).add( 1, "days");
			};
			return d.tz(zone).format();
		},
	},
	"description" : {
			"descriptionField":"Description",
			"getValue" : function(f){
				var field = this["descriptionField"];
				return f(field);
			},
		},
	"resource" : {
			"resourceField":"Resource",
			"getValue" : function(f){
				var field = this["resourceField"];
				return f(field);
			},
		},
	"status" : {
			"statusField":"Status",
			"getValue" : function(f){
				var field = this["statusField"];
				return f(field);
			},
		},
	"contactId" : {
			"contactIdFieldName":"id_contact",
			"getValue" : function(f){
				var field = this["contactIdFieldName"];
				return f(field);
			},
		},
	"projectId" : {
			"projectIdField":"id_project",
			"getValue" : function(f){
				var field = this["projectIdField"];
				return f(field);
			},
		},
	"fmRecordId" : {
			"fmRecordIdField":"-recid",
			"getValue" : function(f){
				var field = this["fmRecordIdField"];
				return f(field);
			},
		},
	"fmModId" : {
			"fmModIdField":"-modid",
			"getValue" : function(f){
				var field = this["fmModIdField"];
				return f(field);
			},
		},
	};
//build query and make call passing are fcObject as the resultClass argument
var query = fmxj.findRecordsURL("Events", "Events", requests);
fmxj.postQueryFMS(query, writeResults, writeDownload, relay, fcObject);