Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Lakshmi SLakshmi S 

How to get all objects last activity date using soql ?

Hi Team,

Requirement : I want to display all objects last activity date using visualforce page or soql ?
Please advise how can we achieve this using SOQL or Visualforce pages?
Please let me know anyone..

Thanks in Advance
Lakshmi S
vijaya53645vijaya53645

Hi Laskshmi,

for Display all object: 
Try it below code:

Public class SobejctList
{
public list<Selectopion>option{get; set;}
public list<selectopion>getopion()
{
Return option;
}
Public sobjeclist()
{
option=new list<selectopion>();
Map<string,schema.sobjecType>maps =schema.getGlobaldescribe();
Set<string>ob=maps.keyset();
{
f or(string s:ob)
{
Selection so=new selectopion(s,s);
Option.add(so);
}
}
}

<apeX:page controller=“SobjectList”>
<apex:form>
<apex:selectlist size=“1”>
<apex:selectopions value=“{!option}”/>
</apex:slectlist>
</apex:form>
</apex:page>


IF it helps you than please mark it as a solution
Team NubesEliteTeam NubesElite
Hi Lakshmi,
You can try as below filter in SOQL. I would require to consider the last activity date API under accounts object. 
TODAY() -   Account.LastActivityDate


Thank You
www.nubeselite.com
Developement | Training | Consulting

Please mark this as solution if your problem resolved.