SOQL SELECT ALL FIELD
来源:互联网 发布:前端解析json数组 编辑:程序博客网 时间:2024/05/30 05:03
Have you ever wanted to do an SQL SELECT * statement in SOQL? Well here's the workaround. Generally, I would recommend that you only query for data that you need, however I have been using this on my current project where the data model constantly changes.
To use, copy and paste this code into your org and modify the 3 lines with // modify as needed at the end.
// Initialize setup variablesString objectName = 'Contact'; // modify as neededString query = 'SELECT';Map<String, Schema.SObjectField> objectFields = Schema.getGlobalDescribe().get(objectName).getDescribe().fields.getMap();// Grab the fields from the describe method and append them to the queryString one by one.for(String s : objectFields.keySet()) { query += ' ' + s + ', ';}// Manually add related object's fields that are needed.query += 'Account.Name,'; // modify as needed// Strip off the last comma if it exists.if (query.subString(query.Length()-1,query.Length()) == ','){ query = query.subString(0,query.Length()-1);}// Add FROM statementquery += ' FROM ' + objectName;// Add on a WHERE/ORDER/LIMIT statement as neededquery += ' WHERE firstName = \'test\''; // modify as needed try { List<Contact> contacts = database.query(query);} catch (QueryException e){ //perform exception handling}
- SOQL SELECT ALL FIELD
- SOQL select *
- Using a date for a datetime field in a SOQL Query [duplicate]
- FIELD - VALUES, SELECT
- SOQL 日付関数
- alv+checkbox+select all
- alv+checkbox+select all
- optgroup select all
- sql script: select database select all table .
- sql script: select database select all table
- jqgrid not allow select all
- select.union all .where.解决方案
- tag 'select', field 'list', name 'department.id':
- SOQL大数据处理
- SOQL and SOSL
- hibernate find By Example, it will use all field
- GUI STATUS里加SELECT ALL & DELETE ALL按钮
- select 中的union 和union all用法
- Unity3D 性能优化工具
- iphone ios行動應用程式開發:iOS平台特性整理
- DataGridView 拖拽到另外一个DataGridView
- 不管你信不信,反正我信了。是这样实现的……
- VC中利用多线程技术实现线程之间的通信 (转)
- SOQL SELECT ALL FIELD
- Java桌面应用安装部署、安装程序制作(exe4j + Inno Setup)——之四:使用Inno Setup制作安装包
- 先安装VS后安装IIS产生的问题
- calloc malloc 区别
- 程序员不良的习惯
- DWR高级主题之反向Ajax(轮询模式实例--DWR2.X)
- 人们的烦躁症,来自于社会结构的不稳定
- as3中的层
- weblogic下载不提示下载信息框 getOutputStream()报异常