Can anyone tell me how I can pass a variable into a LIKE statement in a SOQL query?
If I hardcode the search sting I get records returned:
results = (List<Solution>)[SELECT Id, SolutionNumber, SolutionName, TimesUsed FROM Solution WHERE (SolutionName LIKE '%keywordhere%')];
What I need to do is pass a variable in for the keyword. I tried the following code but I get an error - Error: SolutionSearch Compile Error: unexpected token: '+'
results = (List<Solution>)[SELECT Id, SolutionNumber, SolutionName, TimesUsed FROM Solution WHERE (SolutionName LIKE '%' + searchText + '%')];
I have this code that works but I don't like how it imprecise the returned record are that are returned:
results = (List<Solution>)[FIND :searchText IN ALL FIELDS RETURNING Solution(Id, SolutionNumber, SolutionName, TimesUsed)] [0];
I have created a trigger for a new task is created. It checks the status to verify it is completed and it's status is either Call or Email:
Everything was working fine until I realized that the Subject field of 'Log a Call' can be typed in even though it has a selection offered as a combo box. And anything they type becomes the subject of the task created.
When 'Send an Email' is chosen, the subject line is a blank field as one might expect, however when it is saved it places 'Email:' at the beginning of the string.
What I would like to do is have the 'Log a call' action place 'Call:' in front of whatever is typed in the subject combo. But I'm not sure where to start.
The idea is to Automatically follow all other chatter users when a new user is added.
The problem I am having is the trigger works when adding a new user as long as a Role is not specified upon creation.
When a Role is selected during creation the following error occurs.
caused by: System.DmlException: Insert failed. First exception on row 0; first error: MIXED_DML_OPERATION, DML operation on setup object is not permitted after you have updated a non-setup object (or vice versa): EntitySubscription, original object: User: []
Below is the trigger I have written:
trigger FollowAllChatterUsers on User (after insert) {
//Create List to hold all chatterIds. they will need to be added.
List<User> chatterIdsToAdd = new List<User>([SELECT Id from User WHERE IsActive = true]);
Id currentUserId;
//Take a count of how many users were added to fire this trigger.
//If more than 10 then do not automatically follow.
//The assumption is that if we batch-add more than 10 records we are probably
// loading saved data or backup data in which case the entitysubscriptions table
// will need to be loaded as well.
Integer triggerLength = 0;
for( User usr: Trigger.new ) {
triggerLength++;
}
if (triggerLength <= 10) {
// for each inserted user add all chatter ids except their own.
for( User usr: Trigger.new ) {
//Array of subscription records to create
EntitySubscription[] subsToCreate = new EntitySubscription[]{};
//Get the id of the current user.
currentUserId = usr.Id;
//Loop through list of users to add.
for( User toAdd: chatterIdsToAdd ) {
//If the id to add is our own then skip. otherwise cont..
if ( toAdd.Id != currentUserId ) {
//Create the EntitySubscription record.
EntitySubscription follow = new EntitySubscription(
parentId = toAdd.Id,
subscriberId = currentUserId);
//Add new EntitySubscription to Array for insertion.
subsToCreate.add(follow);
}
}
//Insert the array.
insert subsToCreate;
}
}
}
I read somewhere that within the same transaction a User record and a Role record cannot be update using DML.
I'm not sure if that the same issue I'm running into or not.
If anyone has any insight I would welcome your suggestions.
i have a visualfoce page in dev environment with a button pointing to other visualforce page. now when i deployed the page to other environment using change set..... the link was not working in that env.
Can anyone tell me how I can pass a variable into a LIKE statement in a SOQL query?
If I hardcode the search sting I get records returned:
results = (List<Solution>)[SELECT Id, SolutionNumber, SolutionName, TimesUsed FROM Solution WHERE (SolutionName LIKE '%keywordhere%')];
What I need to do is pass a variable in for the keyword. I tried the following code but I get an error - Error: SolutionSearch Compile Error: unexpected token: '+'
results = (List<Solution>)[SELECT Id, SolutionNumber, SolutionName, TimesUsed FROM Solution WHERE (SolutionName LIKE '%' + searchText + '%')];
I have this code that works but I don't like how it imprecise the returned record are that are returned:
results = (List<Solution>)[FIND :searchText IN ALL FIELDS RETURNING Solution(Id, SolutionNumber, SolutionName, TimesUsed)] [0];
The idea is to Automatically follow all other chatter users when a new user is added.
The problem I am having is the trigger works when adding a new user as long as a Role is not specified upon creation.
When a Role is selected during creation the following error occurs.
caused by: System.DmlException: Insert failed. First exception on row 0; first error: MIXED_DML_OPERATION, DML operation on setup object is not permitted after you have updated a non-setup object (or vice versa): EntitySubscription, original object: User: []
Below is the trigger I have written:
trigger FollowAllChatterUsers on User (after insert) {
//Create List to hold all chatterIds. they will need to be added.
List<User> chatterIdsToAdd = new List<User>([SELECT Id from User WHERE IsActive = true]);
Id currentUserId;
//Take a count of how many users were added to fire this trigger.
//If more than 10 then do not automatically follow.
//The assumption is that if we batch-add more than 10 records we are probably
// loading saved data or backup data in which case the entitysubscriptions table
// will need to be loaded as well.
Integer triggerLength = 0;
for( User usr: Trigger.new ) {
triggerLength++;
}
if (triggerLength <= 10) {
// for each inserted user add all chatter ids except their own.
for( User usr: Trigger.new ) {
//Array of subscription records to create
EntitySubscription[] subsToCreate = new EntitySubscription[]{};
//Get the id of the current user.
currentUserId = usr.Id;
//Loop through list of users to add.
for( User toAdd: chatterIdsToAdd ) {
//If the id to add is our own then skip. otherwise cont..
if ( toAdd.Id != currentUserId ) {
//Create the EntitySubscription record.
EntitySubscription follow = new EntitySubscription(
parentId = toAdd.Id,
subscriberId = currentUserId);
//Add new EntitySubscription to Array for insertion.
subsToCreate.add(follow);
}
}
//Insert the array.
insert subsToCreate;
}
}
}
I read somewhere that within the same transaction a User record and a Role record cannot be update using DML.
I'm not sure if that the same issue I'm running into or not.
If anyone has any insight I would welcome your suggestions.
