Sign Up ›
  • Vijaykumar
  • NEWBIE
  • 40 Points
  • Member since 2019
  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 10
    Questions
  • 9
    Replies
SOLVED
2 replies

SELECT UserRoleId FROM User where UserRole.Name = 'Ramona Biehn's Team'

Hi All,
Am trying to extract the user id from the user role name but am getting the below error, kindly advise.
MALFORMED_QUERY:
UserRole.Name = 'Ramona Biehn's Team'
^
ERROR at Row:1:Column:71
line 1:71 mismatched character '<EOF>' expecting '''

Query: 
SELECT UserRoleId FROM User where UserRole.Name = 'Ramona Biehn's Team'
3 replies

SOQL query to fetch user records ( user license) based on department

Hi Team,
i need report of user records (user license) based on the department.
i.e need to know how many licenses are consumed by each department.

I have used below query but its working for only limit 100 becoz of Org limit..we have 1000+ departments. could you please help here?

SELECT COUNT(Id),Department from user where User_License_Name__c='Salesforce' group by Department limit 100

Thank You!
2 replies

Salesforce license information

Hi Team, is there any way to trigger the salesforce licenses report to manager?
Report  should contacin below;  
Total Licenses
Used Licenses
Available Licenses  

Thank you!
4 replies

Salesforce license usage

Hi Team,
is there any way to trigger the salesforce licenses report to manager?
Report  should contacin below;

Total Licenses
Used Licenses
Available Licenses

Thank you!
5 replies

Validation rule: Interested Partner Program = Reseller then able to select Product Group picklists "Innovyze" or "Not Applicable"

Hi Guys, need your help on creating validation rule for below

Interested Partner Program = Reseller then able to select Product Group picklists "Innovyze" or "Not Applicable"

i have tried below but its not working!!!

ISPICKVAL(Interested_Partner_Program__c, 'Reseller') &&
ISPICKVAL(Product_Group__c,'Innovyze') || ISPICKVAL(Product_Group__c,'Not Applicable')

SOLVED
4 replies

'Audit Engagement Date' Field to be Required when creating cases with case reason = 'Audit'.

Hi Guys

'Audit Engagement Date' Field to be Required when creating cases with case reason = 'Audit'.  

i have created the field and validation rule as

ISPICKVAL( Reason ,'Audit')  &&  ISNULL(Audit_Engagement_Date__c)
could you please help here its not working while creating new case

1 replies

How to restrict dashboard access

Hi All,

How to restrict the 3* CP profile users from accessing the 5*CP profile users opportunity Dashboard? 

In the dashboard of 5* CP Scaleup anchors, other 3* CP resources are displayed ,since these 3* CP resources do not belong to the partner, it needs to be removed from the 5* portal

3 replies

How to send email notification when new training created, canceled, Reschedule, modified by partner

Hi All,
How to send email notification when new training created, canceled, Reschedule, modified venue details by partner.

Thank you!

SOLVED
2 replies

SELECT UserRoleId FROM User where UserRole.Name = 'Ramona Biehn's Team'

Hi All,
Am trying to extract the user id from the user role name but am getting the below error, kindly advise.
MALFORMED_QUERY:
UserRole.Name = 'Ramona Biehn's Team'
^
ERROR at Row:1:Column:71
line 1:71 mismatched character '<EOF>' expecting '''

Query: 
SELECT UserRoleId FROM User where UserRole.Name = 'Ramona Biehn's Team'
2 replies

Salesforce license information

Hi Team, is there any way to trigger the salesforce licenses report to manager?
Report  should contacin below;  
Total Licenses
Used Licenses
Available Licenses  

Thank you!
4 replies

Salesforce license usage

Hi Team,
is there any way to trigger the salesforce licenses report to manager?
Report  should contacin below;

Total Licenses
Used Licenses
Available Licenses

Thank you!
5 replies

Validation rule: Interested Partner Program = Reseller then able to select Product Group picklists "Innovyze" or "Not Applicable"

Hi Guys, need your help on creating validation rule for below

Interested Partner Program = Reseller then able to select Product Group picklists "Innovyze" or "Not Applicable"

i have tried below but its not working!!!

ISPICKVAL(Interested_Partner_Program__c, 'Reseller') &&
ISPICKVAL(Product_Group__c,'Innovyze') || ISPICKVAL(Product_Group__c,'Not Applicable')

SOLVED
4 replies

'Audit Engagement Date' Field to be Required when creating cases with case reason = 'Audit'.

Hi Guys

'Audit Engagement Date' Field to be Required when creating cases with case reason = 'Audit'.  

i have created the field and validation rule as

ISPICKVAL( Reason ,'Audit')  &&  ISNULL(Audit_Engagement_Date__c)
could you please help here its not working while creating new case

3 replies

How to send email notification when new training created, canceled, Reschedule, modified by partner

Hi All,
How to send email notification when new training created, canceled, Reschedule, modified venue details by partner.

Thank you!