<html><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /></head><body style='font-size: 10pt; font-family: Verdana,Geneva,sans-serif'>
<p>Thanks Alan for your fix, I'm sure it will be useful, I have already added it to the system</p>
<div>---<br />
<p>Z poważaniem / Regards</p>
<div> </div>
<div><strong>Mariusz Krzaczkowski</strong></div>
<div><em>Director of Product Development</em></div>
<div>M: +48 884-998-123<br />E: <a title="Mail do Mariusz Krzaczkowski" href="mailto:m.krzaczkowski@yetiforce.com" rel="noreferrer">m.krzaczkowski@yetiforce.com</a></div>
<hr />
<p><span>We created an innovative open source project called YetiForceCRM. You can test it </span><a href="https://test.yetiforce.com/" rel="noreferrer">here</a><span>, </span><a href="https://github.com/YetiForceCompany/YetiForceCRM" rel="noreferrer">download</a><span> it for free or read its </span><a href="https://yetiforce.com/en/documentation.html" rel="noreferrer">documentation</a><span>. Follow us on </span><a href="https://twitter.com/YetiForceEN" rel="noreferrer">Twitter</a><span> to get real-time info about new functionalities and articles.</span></p>
</div>
<p> </p>
<p>W dniu 2015-06-02 11:42, Alan Lord napisał(a):</p>
<blockquote type="cite" style="padding: 0 0.4em; border-left: #1010ff 2px solid; margin: 0"><!-- html ignored --><!-- head ignored --><!-- meta ignored -->
<div class="pre" style="margin: 0; padding: 0; font-family: monospace">On 01/06/15 16:47, Mariusz Krzaczkowski wrote:
<blockquote type="cite" style="padding: 0 0.4em; border-left: #1010ff 2px solid; margin: 0">Alan had a good idea, suggested on your idea and I corrected it. see:<br /><br /><a href="https://github.com/YetiForceCompany/YetiForceCRM/blob/master/include/QueryGenerator/QueryGenerator.php#L721">https://github.com/YetiForceCompany/YetiForceCRM/blob/master/include/QueryGenerator/QueryGenerator.php#L721</a></blockquote>
<br /> Thanks for the cluebat :-)<br /><br /> I have also fixed the bit just below it so that if you want to filter a column and the Users Module's entityfield is _not_ set to first_name,last_name works too (it's around line 744):<br /><br /><br />
<blockquote type="cite" style="padding: 0 0.4em; border-left: #1010ff 2px solid; margin: 0">} elseif (in_array($fieldName, $this->ownerFields)) {<br /> if($fieldName == 'created_user_id'){<br /> $concatSql = getSqlForNameInDisplayFormat(array('first_name'=>"vtiger_users$fieldName.first_name",'last_name'=>"vtiger_users$fieldName.last_name"), 'Users');<br /> $fieldSql .= "$fieldGlue (trim($concatSql) $valueSql)";<br /> }else{<br /> $entityFields = Vtiger_Functions::getEntityModuleInfoFieldsFormatted('Users');<br /> if(count($entityFields['fieldname']) > 1) {<br /> $columns = array();<br /> foreach($entityFields['fieldname'] as $i => $fieldname) {<br /> $columns[$fieldname] = $entityFields['tablename'] . '.' . $fieldname;<br /> }<br /> $concatSql = getSqlForNameInDisplayFormat($columns, 'Users');<br /> $fieldSql .= "$fieldGlue (trim($concatSql) $valueSql OR "."vtiger_groups.groupname $valueSql)";<br /> } else {<br /> $columnSql = $entityFields['tablename'] . '.' . $entityFields['fieldname'];<br /> $fieldSql .= "$fieldGlue (trim($columnSql) $valueSql OR "."vtiger_groups.groupname $valueSql)";<br /> }<br /> }</blockquote>
<br /> Cheers<br /><br /> Al<br /><br /><br /> _______________________________________________<br /><a href="http://www.vtiger.com/">http://www.vtiger.com/</a></div>
</blockquote>
</body></html>