Database Archives

Custom Quick Actions on the LWC page when Modal is created using an Aura component

Author - Webner
|
0 Comments
|

Quick Actions can’t be used with Lightning Web components. Let’s say that the record page has a button that, when clicked, integrates an Aura component that displays a modal. On the Lightning Web Component page, the coding is complete, and there are custom Quick Actions in use. In Read more…

Comparable Interface in Apex

Author - Webner
|
0 Comments
|

When we have to sort a custom object list, based on a field, we try doing it by SOQL query ORDER BY but sometimes due to any constraint or some complex requirements we need to sort the list in Apex itself, then we have Sort method but that also does Read more…

Creating an Azure MySQL database and accessing it via MySql Workbench

Author - Webner
|
0 Comments
|

Look for “MySQL” in the search bar at the top of the Microsoft official website and then choose Azure Database for MySQL. Create a MySQL database using the resource group, and don’t forget to change the default pricing tier. As we will need them later, please make a note Read more…

Azure Upload Blobs To Storage account using SAS URL (source)

Author - Webner
|
0 Comments
|

//SASToken to pass to the Blobservice client for authentication to source storage account
String sasToken = “SAS Token of source storage account ”;

//connection string to connect to the destination storage account
string connectionString =”connection string of destination storage account”;

//endpoint to pass to the blobservice client
string EndPoint = “base url of Read more…

Celery Overview

Author - Webner
|
0 Comments
|

In today’s fast-paced world, people want everything fast and quickly. Similarly, on the internet, they want their process/request to be completed instantaneously and get the required results in seconds. Small tasks can be executed within a second or microseconds, but heavy tasks like sending emails and fetching Read more…

LINQ (Language Integrated Query)

Author - Webner
|
0 Comments
|

Introduction: LINQ is a uniform query syntax in C# to save and retrieve data from different sources. It is integrated into C# eliminating the impedance mismatch between programming languages and databases, as well as providing a single querying interface for different types of data sources.

For example, SQL Read more…

How to deploy the LWC component on a Local Development Server

Author - Webner
|
0 Comments
|

You can deploy your LWC component on a local development server. Once you deploy your component on a local server, then you do not need to deploy again and again to see the output. You just need to save your code in VS code and then the updated output will Read more…

Bulk State Transition

Author - Webner
|
0 Comments
|

The Bulk State Design pattern is the general pattern that executes the bulk of the actions in Apex based on the change of state of one or more records. Bulk transitions increase the code reusability by allowing only records that fulfill the requirements to be processed.

Design Patterns for Read more…

How to Retrieve Metadata of AWS EC2 Machine

Author - Webner
|
0 Comments
|

Metadata is data about your EC2 instance that is used to manage and configure the instance. Developers use the metadata in the script in order to configure the instances and their resources.

Please login to your EC2 machine and run the following command:

# curl http://169.254.169.254/latest Read more…

Call Apex Function inside an LWC Function

Author - Webner
|
0 Comments
|

While creating the LWC component whenever you want to call an apex function you use the @wire function in it and pass parameter in it which has @track or @api decorator attached with it like @track id; or @api id; and whenever there is any change in the parameter the Read more…

RabbitMQ

Author - Webner
|
0 Comments
|

You can think of RabbitMQ as a mediator between the two parties. One is known as the producer that produces goods and services and stores them into RabbitMQ. Another one is the consumer that consumes goods and services from the RabbitMQ.

So, RabbitMQ accepts, stores, and forwards binary blobs of Read more…

How to switch the Mysql authentication method from auth_socket to mysql_native_password

Author - Webner
|
0 Comments
|

In this article, we will come to know how we can switch the MySQL root user default (Auth_Socket) authentication method to mysql_native_password.

Auth_socket Authentication

Auth_socket authentication is a server-side default authentication plugin that is used to authenticate the client input in order to access databases. Auth_Socket authentication Read more…

Keyring Password Issue

Author - Webner
|
0 Comments
|

Use this if you have forgotten the password of the keyring in Ubuntu, but you want to safeguard a new keyring with a password.

For Ubuntu 18.04, I used the following.
Remove old keyring: For this, we need to change the directory to keyring location Read more…

How to exclude source when Syncing or Converting – DX

Author - Webner
|
0 Comments
|

While Syncing the metadata files between your local system and a target/Scratch org, you often want to exclude some of the source files. Similarly, you often have files to exclude when converting the source to the Salesforce DX project format. In both the above-said cases, you can exclude Read more…

How to export database schema with data in Microsoft SQL Server Management Studio

Author - Webner
|
0 Comments
|

Problem: When we use Microsoft SQL Server Management Studio to export the database, by default it will export the database schema only. When I was trying to export the database to import it into my other local machine, I faced this issue. I selected to export Read more…

Advantages of Azure SQL Database

Author - Webner
|
0 Comments
|

Azure SQL Database is a relational database provided as Database-as-a-Service, which is a part of Microsoft’s Cloud Infrastructure Platform, Microsoft Azure. It is also called SQL Azure. It provides database-backed managed service in the cloud with a petabyte-scale infrastructure. It is based Read more…

Salesforce CRM Features

Author - Webner
|
0 Comments
|

Growing your business isn’t simple. It needs boosting sales however it’s not simply selling the services or products to prospective and prevailing customers. A business is a scientific and economical method of collecting leads so they will be born-again to loyal customers and sales.

What does Read more…

Install Openssl with source code

Author - Webner
|
0 Comments
|

To install Openssl, we have to perform all steps with the root user. Please check the steps below:

sudo su (Do all operation with root user)
Change the directory to your desire location
cd /var/www/html/
Make two directories
mkdir Release
mkdir Sources
Go to the Sources folder and Read more…

Security token in Salesforce

Author - Webner
|
0 Comments
|

How to generate an access token?

Step 1: From Setup, enter Apps in the Quick Find box, then select App Manager.
Step 2: Locate the OAuth connected app in the apps list, click and select View.
Step 3: In the Initial Access Read more…

Azure Event Hubs

Author - Webner
|
0 Comments
|

Introduction:

Event Hubs is a real-time data ingestion service that is fully managed, simple, scalable, and trusted. It can stream, process, and receive millions of events per second from any of the sources, which builds data pipelines that are dynamic in nature. These pipelines are favourable to Read more…