Revision: 29261
Initial Code
Initial URL
Initial Description
Initial Title
Initial Tags
Initial Language
at July 24, 2010 05:23 by d3developer
Initial Code
// see: http://community.salesforce.com/t5/Apex-Code-Development/Building-a-reusable-JSON-component/m-p/172428
// and: http://joe-ferraro.com/2009/04/extjs-vf-json/
public String getJson()
{
if (jsonData == null)
{
jsonData = '';
try {
System.debug('getJsonifiedObjectRecords for:' + fieldname + ' ' + objectToLookup );
List<String> columns = new List<String>();
columns.add('id');
if(displayColumn != null)
columns.add(displayColumn);
else
columns.add('name');
String queryString = 'Select id, ' + displayColumn + ' from ' + objectToLookup + ' limit 1000';
System.debug('queryString:' + queryString);
List<sObject> sos = Database.query(queryString);
//Map<String, Schema.SObjectField> columns = sos.getSObjectType().getDescribe().fields.getMap();
jsonData += '[';
for (sObject so : sos) {
jsonData += ' { ';
for(String column : columns)
{
System.debug('jsonData:' + jsonData);
try
{
string cellVal = String.valueOf( so.get(column));
jsonData += ''+column+': "'+cellVal+'",';
}
catch(Exception ex)
{
System.debug(ex);
}
}
jsonData = jsonData.substring(0, jsonData.length() - 1);
jsonData = jsonData + '},';
}
jsonData = jsonData.subString(0,jsonData.length() - 1);
jsonData = jsonData + ']';
}
catch(Exception e)
{
System.debug('Bad query in Jsonify Call ' + e);
}
}
System.debug('jsonData:' + jsonData);
return jsonData;
}
Initial URL
Initial Description
Initial Title
@fractastical Jsonify SObject
Initial Tags
Initial Language
Other