I created a before insert trigger on the case, it querying record types. The test is OK, the trigger in the test method can querying the record types. / @IsTest(SeeAllData=true) public static void test() {...} /
There are another triggers, what create cases, these triggers are not mine, i can't edit them. These tests not use sealldata=true. I can't deploy my changesets, because this test is failed.
I made a procedure that creates an SOQL query string. It occurs dynamically beacause it has user input dependency where clause. The where clause contains an IN operator with an apex local code variable (preceded by a colon). How can we use this variable in the query string?
The problem reduced: How to create this with query string?
List<T__c> L = [SELECT id, status__c FROM T__c WHERE status__c IN :tmpList];
This is not okay:
List<T__c> L = Database.query("SELECT id, status__c FROM T__c WHERE status__c IN " + tmpList );
I made a procedure that creates an SOQL query string. It occurs dynamically beacause it has user input dependency where clause. The where clause contains an IN operator with an apex local code variable (preceded by a colon). How can we use this variable in the query string?
The problem reduced: How to create this with query string?
List<T__c> L = [SELECT id, status__c FROM T__c WHERE status__c IN :tmpList];
This is not okay:
List<T__c> L = Database.query("SELECT id, status__c FROM T__c WHERE status__c IN " + tmpList );
