For anyone who may have faced the same task, here is a sample code for displaying filtered tasks and events to display in Account details. As you may see, I've filtered the results via SOQL, you may extend the code to improve or anything else :) I used a workaround for reading the events, because they are not readable via the 15 digits AccountId but with the 18 digit once. Crazy, but it works. All of you may correct me, if this may not be usable in future.
1) Add a apex class: public with sharing class RelatedActivitesTest { public List<Task> tasksLimited {get;set;} public List<Event> eventsLimited {get;set;} public List<Contact> conts {get;set;} public RelatedActivitesTest(ApexPages.StandardController con){ conts = [SELECT id FROM Contact WHERE AccountId =:ApexPages.currentPage().getParameters().get('id')]; tasksLimited= [select id,activitydate,createdbyid,description,subject,whoid,type,ownerid from task where ( accountid=: ApexPages.currentPage().getParameters().get('id') or WhoId in :conts ) and subject not in ('Rechnung per E-Mail','Rechnung erstellt','Box-Austausch erstellt','Support angelegt','Gutschrift erstellt','Lizenzdatei per E-Mail','Webroot-Lizenzzertifikat per E-Mail','Teilgutschrift erstellt','PreSales angelegt','Angebot per E-Mail') order by activitydate desc limit 1000]; // Used convertID to get the external url repesantation of Account Id, which helps me getting all events. Internal Ids won't work somehow. eventsLimited= [select id,activitydate,createdbyid,description,subject,whoid,type,ownerid,whatid FROM Event WHERE ( WhatId =:convertID(ApexPages.currentPage().getParameters().get('id')) or WhoId =:convertID(ApexPages.currentPage().getParameters().get('id')) or AccountId =:convertID(ApexPages.currentPage().getParameters().get('id')) or WhoId in :conts ) and subject not in ('Rechnung per E-Mail','Rechnung erstellt','Box-Austausch erstellt','Support angelegt','Gutschrift erstellt','Lizenzdatei per E-Mail','Webroot-Lizenzzertifikat per E-Mail','Teilgutschrift erstellt','PreSales angelegt','Angebot per E-Mail') order by activitydate desc limit 1000]; } public static String convertID(String id){ if(id.length() == 18) return id; String suffix = ''; for(Integer i=0;i<3;i++){ Integer flags = 0; for(Integer j=0;j<5;j++){ String c = id.substring(i*5+j,i*5+j+1); if(c.compareTo('A') >= 0 && c.compareTo('Z') <= 0){ flags += 1 << j; } } if (flags <= 25) { suffix += 'ABCDEFGHIJKLMNOPQRSTUVWXYZ'.substring(flags,flags+1); }else suffix += '012345'.substring(flags-26,flags-26+1); } return id+suffix; } }
The visualforce page is connected to Account so you can add it to the Account view in your pagelayout. If you want to change the filter, just change them to fit your needs.
Anyway, if you like my first post, give me a "like".
I want to send out emails from web to lead to the customer - which isn't that problem - but this email should include a unique trial license key. For the key management I would use a custom object, but I don't know how to connect the key to the email (and to this unique user), display it in the mail and send it out.
Hi, could you please tell me, how to disable a single contact completly without deleting and e.g. not showing the emailadress and telefon number? (Enabling of the contact should only be able for the admins) Thanks!
For anyone who may have faced the same task, here is a sample code for displaying filtered tasks and events to display in Account details. As you may see, I've filtered the results via SOQL, you may extend the code to improve or anything else :) I used a workaround for reading the events, because they are not readable via the 15 digits AccountId but with the 18 digit once. Crazy, but it works. All of you may correct me, if this may not be usable in future.
1) Add a apex class: public with sharing class RelatedActivitesTest { public List<Task> tasksLimited {get;set;} public List<Event> eventsLimited {get;set;} public List<Contact> conts {get;set;} public RelatedActivitesTest(ApexPages.StandardController con){ conts = [SELECT id FROM Contact WHERE AccountId =:ApexPages.currentPage().getParameters().get('id')]; tasksLimited= [select id,activitydate,createdbyid,description,subject,whoid,type,ownerid from task where ( accountid=: ApexPages.currentPage().getParameters().get('id') or WhoId in :conts ) and subject not in ('Rechnung per E-Mail','Rechnung erstellt','Box-Austausch erstellt','Support angelegt','Gutschrift erstellt','Lizenzdatei per E-Mail','Webroot-Lizenzzertifikat per E-Mail','Teilgutschrift erstellt','PreSales angelegt','Angebot per E-Mail') order by activitydate desc limit 1000]; // Used convertID to get the external url repesantation of Account Id, which helps me getting all events. Internal Ids won't work somehow. eventsLimited= [select id,activitydate,createdbyid,description,subject,whoid,type,ownerid,whatid FROM Event WHERE ( WhatId =:convertID(ApexPages.currentPage().getParameters().get('id')) or WhoId =:convertID(ApexPages.currentPage().getParameters().get('id')) or AccountId =:convertID(ApexPages.currentPage().getParameters().get('id')) or WhoId in :conts ) and subject not in ('Rechnung per E-Mail','Rechnung erstellt','Box-Austausch erstellt','Support angelegt','Gutschrift erstellt','Lizenzdatei per E-Mail','Webroot-Lizenzzertifikat per E-Mail','Teilgutschrift erstellt','PreSales angelegt','Angebot per E-Mail') order by activitydate desc limit 1000]; } public static String convertID(String id){ if(id.length() == 18) return id; String suffix = ''; for(Integer i=0;i<3;i++){ Integer flags = 0; for(Integer j=0;j<5;j++){ String c = id.substring(i*5+j,i*5+j+1); if(c.compareTo('A') >= 0 && c.compareTo('Z') <= 0){ flags += 1 << j; } } if (flags <= 25) { suffix += 'ABCDEFGHIJKLMNOPQRSTUVWXYZ'.substring(flags,flags+1); }else suffix += '012345'.substring(flags-26,flags-26+1); } return id+suffix; } }
The visualforce page is connected to Account so you can add it to the Account view in your pagelayout. If you want to change the filter, just change them to fit your needs.
Anyway, if you like my first post, give me a "like".
I want to send out emails from web to lead to the customer - which isn't that problem - but this email should include a unique trial license key. For the key management I would use a custom object, but I don't know how to connect the key to the email (and to this unique user), display it in the mail and send it out.
Hi, could you please tell me, how to disable a single contact completly without deleting and e.g. not showing the emailadress and telefon number? (Enabling of the contact should only be able for the admins) Thanks!
