Hello

I tried to override the color of account tab but I couldnt success.

Any help would be appreciated.

<apex:page standardController="Account" showHeader="true" 
      tabStyle="account" >
 

            <style>

                .activeTab {background-color: #236FBD; color:white;

                 background-image:none}

                .inactiveTab { background-color: lightgrey; color:black;

                 background-image:none}

          </style>

 
</apex:page>

Hello

This is  my error when i try to install plugin salesforce in eclipse >

Cannot complete the install because one or more required items could not be found.
  Software being installed: Force.com IDE 28.0.0.201307091110 (com.salesforce.ide.feature.feature.group 28.0.0.201307091110)
  Missing requirement: Force.com IDE 28.0.0.201307091110 (com.salesforce.ide.feature.feature.group 28.0.0.201307091110) requires 'org.eclipse.update.ui 0.0.0' but it could not be found

Using Eclipse IDE for Java EE .

http://www.eclipse.org/downloads/packages/eclipse-ide-java-ee-developers/keplerr

http://wiki.developerforce.com/page/Force.com_IDE_Installation_for_Eclipse_3.6

(I follow this link >

http://boards.developerforce.com/t5/General-Development/Security-token-and-password-not-saved-against-force-com-project/m-p/640355/highlight/true#M96299

because Ive got the same error, password and token cleared)

Thanks

Thanks for your help

<apex:page standardController="Opportunity">

<apex:pageBlock title="LineOrder">
<apex:pageBlockTable value="{! Opportunity.Order__r.LineOrder__r}" var="item">
<apex:column value="{! item.name}"/>
</apex:pageBlockTable>
</apex:pageBlock>

</apex:page>

Is it possible to show LineOrders this way?

Thanks

Hello

I need advice to start to implement salesforce for a client.

What are the licences suggested and how many environments should the client purchased?

I saw on technical docs two fullsanboxes, what is the advantage to have two full sandboxes and how much will cost an additional one ?

Thanks

Hello,

How can I do to calculate a field everyday with a calcul based on the today date?

Thanks

Hello,

I try to export the list from a query using https://workbench.developerforce.com/query.php#qr

When I select "Bulk CSV" I've got a message error >  InvalidJob: Unable to find object: Products__r

My query contain a sub query like this >

select id, name, (select id, name from Products__r) from contact

When I run the the view as List it's working fine. Any idea why ?

Thanks

Hello,

I would like to know if its possible to create a report which will display datas like in workbench when i query >

Select id, name, (select id , name from Contacts) from account.

With list of contacts inside the cell of account.

Thanks for your help

Hi,

I try to follow this > http://wiki.developerforce.com/page/Using_Data_Loader_from_the_command_line

But I dont have APIversion directory installed on my windows. Any idea ?

Thanks

Hi,

How can I make a formul (in a report) a division between two fields in differents objects ?

Thanks for your help

Hi,

I need to have a dashboard allowing parameters as start and end date

once these parameters are populated I need this parameter to go down and update reports parameters which are in this dashboard. Is it possible ?

Or do I have to update all the reports present in the dashboard one by one?

Thanks

Hello,

When I create a report and I'm using if a field, how should I do to reuse this field for another column ..?

Thanks

Hello

How can I change a profile license from salesforce platform to salesforce.

Thanks for your help

hello

I try to run a batch throught the developer console but Ive got variable val does not exist>

String val = 'Sales';
String soqlQuery = 'Select id  from Contact  Where RecordType.Name =:val  limit 1';
system.debug(soqlQuery);

Id batchInstanceId = Database.executeBatch(new BATCH_UpdateObject('Select id  from Contact  Where RecordType.Name in:val  limit 1','Contact','',''), 10);

Thanks for your help

Hello,

I dont know the right way to write down this

String val = 'Saler';

I tried >
String soqlQuery = 'Select id  from Contact  Where RecordType.Name = ' + 'Saler' + ' limit 1';

>

String soqlQuery = 'Select id  from Contact  Where RecordType.Name = ' + val + ' limit 1';
system.debug(soqlQuery);

But quotes disapears, how can I do ?

Thanks

Hi

first of all thanks for your help .. im new on soql and lost after sql server.

If there is any table showing difference between sql and soql Im interested

So I ve got a list of users and I need a list of event with the id of the contact assigned to and the owner of this contact.

I've got not clue how to do that in soql and I need to export this through data loader.

     SELECT Subject, OwnerId, Owner.Name, whoID, who.ownerID

     FROM Event

     WHERE ownerID in ('00Ua002500LIKza','00Ua002500jDKza','00Ua002500AaKzc')

Thanks a lot for your help

Hello

I would like to understand the difference for an event object between whoID field and OwnerID field?

OwnerID is the assigned to field, what is the whoID field

Thanks for your help

Hello,

I tried

SELECT e.Subject, e.OwnerId, (select Name from User where id=e.OwnerId) FROM Event e where subject = 'TEST'

but it doesn't work

If I run this query below >

SELECT Subject, OwnerId, Owner.Name FROM Event where subject = 'TEST'

The Name column will show Name value as vlookup and by clicking on it I can see the name.

What if I want to see directly in my query the value, the name of the user.

Thanks

Hello

I need to create a Ticket matrice report  with line "assigned to"

and for column difference of days between "requested delivery date" and "Closed date"

I've no idea how to make this column. I tried to have a look to "add formula"

but I can't see thus fields, do I need to first add them as column in the report?

Thanks

Hello,

I need to create a report based on tickets .... initial due date and delivery date.

Thanks.

Hello,

I need to send a mail if an event is not completed and end date < Today-14days.

Thanks

I dont know how to do that.

I guess I need to create an Email alert than maybe a workflow rule but how can I reach this enddate.

Is it the same as activitydate?

Thanks

Hello

This is  my error when i try to install plugin salesforce in eclipse >

Cannot complete the install because one or more required items could not be found.
  Software being installed: Force.com IDE 28.0.0.201307091110 (com.salesforce.ide.feature.feature.group 28.0.0.201307091110)
  Missing requirement: Force.com IDE 28.0.0.201307091110 (com.salesforce.ide.feature.feature.group 28.0.0.201307091110) requires 'org.eclipse.update.ui 0.0.0' but it could not be found

Using Eclipse IDE for Java EE .

http://www.eclipse.org/downloads/packages/eclipse-ide-java-ee-developers/keplerr

http://wiki.developerforce.com/page/Force.com_IDE_Installation_for_Eclipse_3.6

(I follow this link >

http://boards.developerforce.com/t5/General-Development/Security-token-and-password-not-saved-against-force-com-project/m-p/640355/highlight/true#M96299

because Ive got the same error, password and token cleared)

Thanks

Thanks for your help

<apex:page standardController="Opportunity">

<apex:pageBlock title="LineOrder">
<apex:pageBlockTable value="{! Opportunity.Order__r.LineOrder__r}" var="item">
<apex:column value="{! item.name}"/>
</apex:pageBlockTable>
</apex:pageBlock>

</apex:page>

Is it possible to show LineOrders this way?

Thanks

Hello,

How can I do to calculate a field everyday with a calcul based on the today date?

Thanks

Hello

How can I change a profile license from salesforce platform to salesforce.

Thanks for your help

Hi

first of all thanks for your help .. im new on soql and lost after sql server.

If there is any table showing difference between sql and soql Im interested

So I ve got a list of users and I need a list of event with the id of the contact assigned to and the owner of this contact.

I've got not clue how to do that in soql and I need to export this through data loader.

     SELECT Subject, OwnerId, Owner.Name, whoID, who.ownerID

     FROM Event

     WHERE ownerID in ('00Ua002500LIKza','00Ua002500jDKza','00Ua002500AaKzc')

Thanks a lot for your help

Hello,

I tried

SELECT e.Subject, e.OwnerId, (select Name from User where id=e.OwnerId) FROM Event e where subject = 'TEST'

but it doesn't work

If I run this query below >

SELECT Subject, OwnerId, Owner.Name FROM Event where subject = 'TEST'

The Name column will show Name value as vlookup and by clicking on it I can see the name.

What if I want to see directly in my query the value, the name of the user.

Thanks

Hello

I need to create a Ticket matrice report  with line "assigned to"

and for column difference of days between "requested delivery date" and "Closed date"

I've no idea how to make this column. I tried to have a look to "add formula"

but I can't see thus fields, do I need to first add them as column in the report?

Thanks

Hello,

I need to send a mail if an event is not completed and end date < Today-14days.

Thanks

I dont know how to do that.

I guess I need to create an Email alert than maybe a workflow rule but how can I reach this enddate.

Is it the same as activitydate?

Thanks

Hello,

What happen to records like event, contacts owned by an user which is deactivated?

Thanks,

Hello

I try to add values in a list already populated... is it possible ?

 List<Object__c> p = [Select id,RecordTypeId
            from Object__c
            where PrincipalClient__c IN :ClientIds];

        p.add = [Select id,RecordTypeId
                 From Object__c p
                 where id in (select Object__c from RelatedClient__c where Related_ClientField__c IN :ClientIds)  
                 ];

BUTI've got an error > Initial term of field expression must be a concrete SObject

Thing is my PrincipalClient__c field is a lookup in ma Object table.

And Related_clientField__c field is a Master-Detail(Object) in the RelatedClient__c table.

I tried to do just one query like below but I've got an error because >>

        List<PatientProfile__c> p = [Select id,RecordTypeId
            from Object__c 
            where (PrincipalClient__c IN :ClientIds)
            OR (id in (select Object__c from RelatedClient__c where Related_ClientField__c IN :ClientIds) )]; 

 Semi join sub-selects are not allowed with the 'OR' operator

 Thanks for your help.

Hello

I'm creating a trigger.

I need to male a list with a where condition pointing on a field of the object not the id.

Let s image

Object patient and objectB

objectB (id, name, patientid)

So >>

Trigger myTrigger on objectB (,,,,,)

List <Patient>  p = [select id, name from patient

                                   Where in IN :Trigger.newMap.KetSet()];   // but here i need ObjectB.patientid set

Thanks for your help

Sunny

Hi all,

I am newbie to apex Batch classes. I need to understand how Apex batches execute(the process).

I know how to write apex classes and trigeers. but totally confused in following Apex batch code. Kindly give me some tips/knowledge/information on how easily I can write apex batches.

==========================================================

1. global class Beautification's implements Database.Batchable<sObject>{
2. global final String Query;
3. global final String Entity;
4. global final String Field;
5. global final String Value;
6. global UpdateAccountFields(String q, String e, String f, String v){
7. Query=q; Entity=e; Field=f;Value=v;
8. }
9. global Database.QueryLocator start(Database.BatchableContext BC){
10. return Database.getQueryLocator(query);
11. }
12. global void execute(Database.BatchableContext BC,
13. List<sObject> scope){
14. for(Sobject s : scope){s.put(Field,Value);
15. } update scope;
16. }
17. global void finish(Database.BatchableContext BC){
18. }
19. }

The following code can be used to call the above class:

1. Id batchInstanceId = Database.executeBatch(new UpdateInvoiceFields(q,e,f,v), 5);

=============================================================

I am little confused of the following lines:

1. ""query","entity","field","value"" declared as variable and at 7th line why it is assigned to q,e,f,v.

2.  return Database.getQueryLocator(query)...?

3.  [List<sObject> scope)  {  for(Sobject s : scope){s.put(Field,Value);]..in line 13,14.

Can't we use directly Account,lead,contact or any custom object. Like this:[ List<account>scope { for(account a:scope...].

4. Id batchInstanceId = Database.executeBatch(new UpdateInvoiceFields(q,e,f,v), 5);

can please explain line by line.

thank you in advance.

any kind of explanation/suggestions/information is highly appriciated.