Enable Custom List Settings In Org

From  Spring '18 release, By Default Custom List Settings Are Greyed Out,
If You Are Trying to create List Type No way to select List Type By Default Is Shows Only Hierarchy Type.

To Enable List Type Custom Settings, In Your Org
Path:

 Setup > Schema Settings > Manage List Custom Settings Type

Enable Manage List Custom Settings Type.

Once You Enabled The Toggle you are able to create list type Custom Settings in Your Org.

Let us know if you have any queries!

Happy Learning!!!

How To Check Active Validation Rules Based On Selected Object Using SOQL

If You want to Check Active Validation Rules on selected Object.
Use Below Simple SOQL Query, This Query Fetch the Active Validation Rule on a Your Select-Object.
SOQL Query:

Select id,Active,Description,EntityDefinition.DeveloperName,ErrorDisplayField,ErrorMessage From ValidationRule where EntityDefinition.DeveloperName='<Object Name>' and active = true

Note: Use Tooling API while Querying.
If You are Using Developer Console

Check the Screen Shot For More Information

Let Us Know If  You Have Any Queries.

Happy Learning!!

Optimize The Sales process Using Path in Lightning Experience

In this Post Exploring The Sales Process Using Path in Lightning Experience.

• Creating the Path based On Selected Object and Record Type.
• adding the Path on Your Record Page.
• How to add Chatter Links to Relevant Posts.

How to Check Custom Labels Values Using SOQL

Custom labels are custom text values that can be accessed from Apex classes, Visualforce pages, or Lightning components. The values can be translated into any language Salesforce supports.
If you want to create Custom Labels in your Org,

• First, check Custom Label already exists or not based on your value to avoid duplicate Custom Labels in Org.
• If you want to refer Label in apex class 
• System.Label.Label_Name
• In VisualForce pages and Lightning Components use the global variable
• $Label

In order to check the Custom Labels in org write the following SOQL Query.
Note: Use Tooling API to Query
if you are using Developer Console, check the screenshot to select Tooling API.

Demo:

Select Id, Name FROM CustomLabel WHERE Value = '<your Value>'

Check the screenshot for more information about the result.

Happy Learning!!!

How To Check Page Layout Assignment Using SOQL Query

This post explains how to check page layout assignment using SOQL.

1. We can see the Page Layout is assigned to any profile or not.

2. We can see the RecordTypeId also, means we can See the Record Type assignment also.

Note:  Use Tooling API to Query, Please Select Tooling API while Querying.

If you are using Developer Console to query

Demo:

SELECT Layout.Name, Layout.TableEnumOrId, ProfileId, Profile.Name, RecordTypeId FROM ProfileLayout WHERE Layout.Name='<Layout Name>' AND Layout.TableEnumOrId = '<object Name OR object ID>'

Check below screenshot for more information about result.

Happy Learning!! 

How To Check Active Users in Role, Public Group and Queue Using SOQL query.

if you want to Find Number Of Active Users In a Role use the Below simple SOQL query.

Active Users in Role:

SELECT Id, Name, Email, isActive, Profile.Name, UserRole.Name, UserType FROM User WHERE UserRole.Name = '<Role Name>' AND isActive = true 
OR 
SELECT Count(Id) FROM User WHERE UserRole.Name = '<Role Name>' AND isActive = true 

find below screenshot for more information.

Active Users In Public Group:

SELECT Id, Name, Email, isActive, Profile.Name, UserRole.Name, UserType FROM User WHERE Id IN (SELECT UserorGroupId FROM GroupMember WHERE Group.Name = '<group Name>') AND isActive = true 
OR
SELECT Count(Id) FROM User WHERE Id IN (SELECT UserorGroupId FROM GroupMember WHERE Group.Name = '<Group Name>') AND isActive = true

find below screenshot for more information

Active Users In Queue:

SELECT Id, Name, Email, isActive, Profile.Name, UserRole.Name, UserType FROM User WHERE Id IN (SELECT UserOrGroupId FROM GroupMember WHERE Group.Type= 'Queue' AND Group.Name = ' <queue Name>') AND isActive = true
OR
SELECT Count(Id) FROM User Where Id IN (SELECT UserOrGroupId FROM GroupMember Where Group.Type= 'Queue' AND Group.Name = '<queue Name>') AND isActive = true

find below screenshot for more information

How To Check Active Users In a Profile Using SOQL Query

if you want to find Active users in a profile using the Below simple query, it fetches the active users in a profile.

Query:

SELECT count() FROM User WHERE IsActive = true AND Profile.Name = '<profile_Name>' 

It shows the result in the form of Count.
Please Check the Screen Shot For More Information.

please let us know if you have any queries.
Happy Learning!!

How To Check Active Users in a Permission Set Using SOQL Query

If you want find How many Active Users in a Permission Set using SOQL query

use the Below simple query it fetches active users in Permission Set.

Query:

SELECT Count(AssigneeId) FROM PermissionSetAssignment WHERE Assignee.isActive = true AND PermissionSet.Name='<Permission set API Name>'

it gives the result in the form of Count.

Ex: if the count is Four, means 4 active users are in Permission Set.

Please Check Screen Shot for more details.

Please let us Know If you have any Queries.
Happy Learning!!