Webner Blogs – eLearning, Salesforce, Web Development & More

1. Place Scripts at the Bottom of the Page: If we include script at the top, sometime page elements are not loaded completely and script starts working. So we need to include scripts after loading all the elements. Also if scripts

SQL Report in ‘Configurable Reports’ plugin provides us an easy UI to write SQL Query and draw results immediately without involving any code complications. Suppose I want to generate my custom grades report based on some specific activities from course

‘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

Execute dynamic query in salesforce. Also retrieve all fields from salesforce object without writing fields names in query. Solution: In Salesforce we can’t write as Select * from object. We have to mention the field specific field name to query

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”

If we want to check for the subscriptions having Expired Cards in chargify then there are two ways to do that: 1. By using the notification on dashboard (see image below): By clicking on the symbol of notification it will

JSONB (JSON Blob) datatype in Postgres is used to save JSON data. We can search on JSONB type of column after creating an index on it. For example: Usage in PostgreSQL: 1. Create table and index CREATE TABLE tests (

Handling content and image sharing with twitter and google plus share buttons in wordpress To achieve dynamic content(including image) sharing from a website with share buttons (or links) for share and likes on social sites like twitter and google plus,

To create a new customized plugin with email functionality and sending a pdf file as attachment requires some simple lines of code with TCPDF library file inside the library directory of moodle. And for performing file operations, filelib.php reference is