Scenario : Applet has to display only current Year record at the initial load. But when i do a query an go it has to show all the records [ previous year records also]
ie :only on the applet load it has to show the current year records
My Solution :
1) At
the time of applet load --- Set one profile attribute --This will
make sure our code only fire at the time of loading the applet
a.
Set the profile attribute
b.
Set the some value to profile attribute
2
2)In
function BusComp_PreQuery () before we entering to the
code you have to make sure below two things
a.
Whether we are that active view
b.
Whether profile attribute got set or not
i.
if (TheApplication().ActiveViewName() == "<<ViewName>>"
&& TheApplication().GetProfileAttr("<<ProfileAttrib>>")
== "<<value check>>")
ii.
{<<Our code goes
here
>> }
c.
Once we execute the code change back the profile attribute to
previous value àimportant
Pseudo Code :
function BusComp_PreQuery ()
{
var sSearchExpr;
sSearchExpr = this.GetSearchExpr();
if (TheApplication().ActiveViewName() == "<<ViewName>>" && TheApplication().GetProfileAttr("<<ProfileAttrib>>") == "<<value check>>")
if (sSearchExpr != null && sSearchExpr != "")
{
var dtToday = new Date();
dtToday.setDate("1");
dtToday.setMonth("0");
dtToday
=dtToday.getDate() + "/" + ToNumber(dtToday.getMonth()+1) +
"/" + dtToday.getFullYear();
this.SetSearchExpr("[Agreement
Start Date] >='"+dtToday+"'") ;
} // end of if sSearchExpr
}// end of if Active View name
return (ContinueOperation);
}
Agreement Start Date
à
mention ur field name
Note:Please let me know if there is any other better approach to the above solution.
regards
jo
joju2002@gmail.com
