Moodle: Performing search through wildcard queries with ‘Like’ operator

| By Webner

‘Like’ operator of SQL can be used in the following ways in Moodle: Using expression $DB->sql_like: $grade_item_test = $DB->get_records_sql ( ‘SELECT * FROM {grade_items} WHERE ‘.$DB->sql_like(‘idnumber’, ‘:idnum’).’ AND courseid=:cid order by itemmodule’, array (‘idnum’=>’test’,’cid’=> $courseid) ); Using like operator: $grade_item_test

Salesforce | Upload Document in Salesforce using javascript

| By Webner

We can create a document/attachment object record in Salesforce using Javascript by calling Salesforce soap webservice. Note – Variable __sfdcSessionId is used to store sessionid. Script files: <script type=”text/javascript”>// <![CDATA[ __sfdcSessionId = ‘{!$Api.Session_Id}’; // ]]></script> <script src=”/soap/ajax/30.0/connection.js” type=”text/javascript”></script> <script src=”/soap/ajax/30.0/apex.js”