<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
yeah, will be fixed in 6.5
<a class="moz-txt-link-freetext" href="http://code.vtiger.com/vtiger/vtigercrm/issues/2">http://code.vtiger.com/vtiger/vtigercrm/issues/2</a> glad it helped you!<br>
<br>
Alan.<br>
<br>
<div class="moz-cite-prefix">On 11/03/16 22:49, Vladimir Karažija
wrote:<br>
</div>
<blockquote
cite="mid:CAA=2JfrLXrmfu5OzXKJXiAefm_eenwN7YLq=Gw91cD+5Ly3aMQ@mail.gmail.com"
type="cite">
<div dir="ltr">Hi,
<div><br>
</div>
<div>I searched vtigercrm-developer list and found solution from
Alan Bell.</div>
<div><br>
</div>
<div>Thnx Alan ;)</div>
<div><br>
</div>
<div>
<div>in modules/Calendar/actions/Feed.php in the pullProjects
function at line 337 there is:</div>
<div><br>
</div>
<div> $params = array_merge($params,$userAndGroupIds);</div>
<div><br>
</div>
<div>which then gets used in this query . . .</div>
<div><br>
</div>
<div> $query = "SELECT projectname, startdate,
targetenddate, crmid FROM vtiger_project";</div>
<div> $query.= " INNER JOIN vtiger_crmentity ON
vtiger_project.projectid = vtiger_crmentity.crmid";</div>
<div> $query.= " WHERE
vtiger_crmentity.deleted=0 AND smownerid IN (".
generateQuestionMarks($userAndGroupIds) .") AND ";</div>
<div> $query.= " ((startdate >= ? AND
targetenddate < ?) OR ( targetenddate >= ?))";</div>
<div> $queryResult = $db->pquery($query,
$params);</div>
<div><br>
</div>
<div>however, the questionmarks for the users and groups come
before the date parameters, so it doesn't work and projects
don't display on the calendar, changing line 337 to put the
users and groups first fixes it:</div>
<div><br>
</div>
<div> $params = array_merge($userAndGroupIds,$params);</div>
</div>
<div><br>
</div>
<div>regards, Vladimir</div>
<div><br>
</div>
</div>
<div class="gmail_extra"><br clear="all">
<div>
<div class="gmail_signature">
<div dir="ltr">
<div>
<div dir="ltr">
<div>Vladimir Karažija</div>
<div>Kosa crta d.o.o.</div>
<div>Jagnedje 1</div>
<div>10090 Zagreb</div>
<div>OIB: 57724075047</div>
<div><br>
</div>
<div>t. +385 1 777 33 85</div>
<div>m. +385 91 122 0511<br>
</div>
<div><a moz-do-not-send="true"
href="http://www.kosacrta.hr" target="_blank">www.kosacrta.hr</a></div>
</div>
</div>
</div>
</div>
</div>
<br>
<div class="gmail_quote">On Fri, Mar 11, 2016 at 11:38 PM,
Vladimir Karažija <span dir="ltr"><<a
moz-do-not-send="true" href="mailto:vladimir@kosacrta.hr"
target="_blank"><a class="moz-txt-link-abbreviated" href="mailto:vladimir@kosacrta.hr">vladimir@kosacrta.hr</a></a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr">Hi,
<div><br>
</div>
<div>I am testing Projects module and cannot make vtiger
6.4 to show Projects Activity Types in Calendar.</div>
<div><br>
</div>
<div>I am able to see Project Tasks in All-Day view that
are related to Project but cannot see Projects in
Calendar.</div>
<div><br>
</div>
<div>I have added Start Date & End Date as instructed
on <a moz-do-not-send="true"
href="http://www.boruapps.com/vtiger-tip-modules-on-the-vtiger-calendar/"
target="_blank">http://www.boruapps.com/vtiger-tip-modules-on-the-vtiger-calendar/</a>
but still there is no Projects Activity Type shown in
Calendar.</div>
<div><br>
</div>
<div>Anyone with same experience?</div>
<div><br>
</div>
<div>regards, Vladimir</div>
<div><br>
</div>
<div><br>
<div>
<div>
<div dir="ltr">
<div>
<div dir="ltr">
<div>Vladimir Karažija</div>
<div>Kosa crta d.o.o.</div>
<div>Jagnedje 1</div>
<div>10090 Zagreb</div>
<div>OIB: 57724075047</div>
<div><br>
</div>
<div>t. <a moz-do-not-send="true"
href="tel:%2B385%201%20777%2033%2085"
value="+38517773385" target="_blank">+385
1 777 33 85</a></div>
<div>m. <a moz-do-not-send="true"
href="tel:%2B385%2091%20122%200511"
value="+385911220511" target="_blank">+385
91 122 0511</a><br>
</div>
<div><a moz-do-not-send="true"
href="http://www.kosacrta.hr"
target="_blank">www.kosacrta.hr</a></div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</blockquote>
</div>
<br>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
<a class="moz-txt-link-freetext" href="http://www.vtiger.com/">http://www.vtiger.com/</a></pre>
</blockquote>
<br>
</body>
</html>