Salesforce SOQL query is not working same way as SQL server Data Base query. why? Salesforce using Multitenant Architecture – Many organization using single instance including data base but each org will have their own virtual hardwares. Salesforce using Force.com platform – It is metadata driven architecture. Query language directly integrated with Apex so no […]
Queries that involve complex relationship can be handled easily using List Methods.
via Salesforce Apex : Dynamic SOQL Querying with uncertain relationship — James’ Desk
Suppose we have a javaScript data and that we need to process this data on another page. Here, we need to move the data between pages in a specific format. Typically, plain text or “XML” was used for this. Because the “XML” format is difficult to interpret, a more easily interpreted data format was generated […]
What is JSON Data? A JSON(JavaScript Object Notation) Data is a data containing object and Array. JSON data is mainly used for exchange data from the server to web Application or Mobile Application. it is a stander Data exchange format. JSON is very lightweight, text-based, human-readable, easily editable with any text editor. Read more about JSON […]
function getPerformanceinfo (){ var myLabelarray = []; var myActualarray = []; $.post(‘inl_sev_078_J_vrs.php’, {“UNIQUENO” : myReportref }, function(response) { for(var i=0; i
via Javascript – Building arrays from JSON response data — My PHP / Javascript / JQuery notes
The guide below shows how you can easily create an Azure Functions to return JSON data from an Azure SQL backend. I have to admit, I have to do multiple google search and combine it for a working solution. Challenges: How to get SQL connectionString from Azure Function settings. https://docs.microsoft.com/en-us/azure/azure-functions/functions-scenario-database-table-cleanup How to convert the sql […]
Simple Oracle Document Access SODA (Simple Oracle Document Access) is a non-SQL style of storing/retrieving JSON data in an Oracle database. It’s so easy to work with SODA! Let’s get started. First, enable ORDS schema in your database. Second, deploy ORDS in K8s (you can also deploy ORDS standalone in your laptop or in a container […]
In short, I think excel will wins. Tableau Software has been in business since 2004. They hope to reach record revenues of $1.4 billion in 2019 but aren’t profitable. Microsoft is highly profitable and motivated to make certain nothing replaces its Excel hegemony. Rather than replacing Excel in the next few years, it is much […]
This post is a continuation of the previous one – Highlighting Top X values with Conditional Formatting in #Excel So I will go straight to the point. For background information, please read the previous post. 🙂 To insert Icon Set Select the data range –> Go to Home Tab –> Conditional Formatting –> Icon Sets Choose […]
via Highlighting Top X values with Icon Set in #Excel — wmfexcel
