Pivot

			var example_query = "[{\n";
  		example_query = example_query + "  \"/business/employer/employees\":[{\n";
  		example_query = example_query + "    \"optional\":true,\n";
    	example_query = example_query + "    \"person\":[{\n";
      example_query = example_query + "      \"name\":null\n";
    	example_query = example_query + "      }],\n";
    	example_query = example_query + "    \"type\":\"/business/employment_tenure\"\n";
  	  example_query = example_query + "  }],\n";
  		example_query = example_query + "  \"/people/person/children\":[{\n";
    	example_query = example_query + "    \"name\":null,\n";
    	example_query = example_query + "    \"optional\":true\n";
  		example_query = example_query + "  }],\n";
  		example_query = example_query + "  \"/people/person/employment_history\":[{\n";
    	example_query = example_query + "    \"company\":[{\n";
      example_query = example_query + "      \"name\":null\n";
    	example_query = example_query + "    }],\n";
    	example_query = example_query + "    \"optional\":true,\n";
    	example_query = example_query + "    \"type\":\"/business/employment_tenure\"\n";
  		example_query = example_query + "  }],\n";
  		example_query = example_query + "  \"/people/person/parents\":[{\n";
    	example_query = example_query + "    \"name\":null,\n";
    	example_query = example_query + "    \"optional\":true\n";
  		example_query = example_query + "    }],\n";
  		example_query = example_query + "  \"/people/person/sibling_s\":[{\n";
    	example_query = example_query + "    \"optional\":true,\n";
    	example_query = example_query + "    \"sibling\":[{\n";
      example_query = example_query + "      \"name\":null,\n";
      example_query = example_query + "      \"optional\":true\n";
    	example_query = example_query + "    }],\n";
    	example_query = example_query + "    \"type\":\"/people/sibling_relationship\"\n";
  		example_query = example_query + "  }],\n";
  		example_query = example_query + "  \"name\":\"Metaweb Technologies, Inc.\",\n";
  		example_query = example_query + "  \"type\":\"/common/topic\"\n";
			example_query = example_query + "}]";
			
			var topicName = mjt.urlquery.name?mjt.urlquery.name :"Metaweb Technologies, Inc."; 
			var q = mjt.urlquery.q?mjt.urlquery.q : example_query;
			q=decodeURIComponent(q);
			var tq = 	[{}];
			tq=mjt.json_to_js(q);
  		var ncolumns = 0;
  		var colcount = 0;
  		var rowcount = 0;
  		var rowArray = new Array();

tq[0].name = topicName;

${propNamesInArray(v[0],row,ncolumns,pname+k+"/")} rowArray[0][ncolumns]=pname+k; ncolumns++;

${valuesInArray(obj,row,col,values)} col=colcount; rowArray[rowcount][col]=""; rowArray[rowcount][col]=""+rowArray[rowcount][col]+ ","+'\n';

${rowArray[0][col]} $v

rowArray[rowcount][col]=""+rowArray[rowcount][col]+v; col++; colcount=col;

Pivot

Click on link to run the query using the link name as the value for the outermost name property.

document.title='Pivot';

mjt.mqlread(tq)

error

$msg.type : $msg.text

timeout

no match

loading...

 rowArray[rowcount] =  new Array();

${propNamesInArray(qresult.result[0],0,0,'')}

colcount=0;

colcount++;

$topicName

colcount=0;

rowcount++;

 rowArray[rowcount] =  new Array();

${valuesInArray(topic,0,0,'')}

${inputBox(q)}