Listview with Filter not working properly

Hello everyone,

on a fresh installed vtiger (actual master) , i've tried to create a filtered LISTVIEW on Opportunities. The filter looks like:

Amount - greater or equal - 9000

But the List ist showing ALL records. regardless of the amount.

I've also tried the other filter types. the following are not working:

less than

greater than

less or equal

greator or equal

Can anyone help me out? Best regards, Ralph

Do you mean something like what is mentioned #1117 (closed) ?

Sorry for the late reply. This is just a bug regarding number filters. (regardless if its with a related module)

It looks like the Query being generated is incorrect. The number/currency value is wrapped with escaped "'" single quotes:

SELECT vtiger_potential.potential_no, vtiger_potential.potentialname, vtiger_potential.related_to, vtiger_potential.contact_id, vtiger_potential.closingdate, vtiger_potential.sales_stage, vtiger_potential.fc_nrc, vtiger_potential.potentialid, vtiger_crmentity_user_field.starred FROM vtiger_potential  INNER JOIN vtiger_crmentity ON vtiger_potential.potentialid = vtiger_crmentity.crmid LEFT JOIN vtiger_crmentity_user_field ON vtiger_potential.potentialid = vtiger_crmentity_user_field.recordid AND vtiger_crmentity_user_field.userid=19  WHERE vtiger_crmentity.deleted=0 AND   (  (( vtiger_potential.fc_nrc > '\'100000\'') )) AND vtiger_potential.potentialid > 0 ORDER BY vtiger_crmentity.modifiedtime DESC LIMIT 0,21

If I run this directly on the database it seems to just ignore that clause. Removing the single quotes, e.g:

SELECT vtiger_potential.potential_no, vtiger_potential.potentialname, vtiger_potential.related_to, vtiger_potential.contact_id, vtiger_potential.closingdate, vtiger_potential.sales_stage, vtiger_potential.fc_nrc, vtiger_potential.potentialid, vtiger_crmentity_user_field.starred FROM vtiger_potential INNER JOIN vtiger_crmentity ON vtiger_potential.potentialid = vtiger_crmentity.crmid LEFT JOIN vtiger_crmentity_user_field ON vtiger_potential.potentialid = vtiger_crmentity_user_field.recordid AND vtiger_crmentity_user_field.userid=19 WHERE vtiger_crmentity.deleted=0 AND ( (( vtiger_potential.fc_nrc > 100000) )) AND vtiger_potential.potentialid > 0 ORDER BY vtiger_crmentity.modifiedtime DESC LIMIT 0,21 

makes it then work correctly.

This query is being generated probably in the QueryGenerator I guess.

Oooh - see line 1161 - try removing the

$db->quote($

value) function and just return the $value...

http://code.vtiger.com/vtiger/vtigercrm/commit/1b80f8358508b3dd660fe63834468d2836c8d58e#e7c2249cb967ae196200103b3868ef6275bb759d_1159_1161

mentioned in commit 1b80f835

Hi Alan,

i've tried it right away with the link you've sent me. first try worked ... but my second one not ;) i'll test it a little bit and give you feedback soon as possible

Status changed to closed by commit 8c13e5e6

It might not be the correct fix. But the call to $db->quote() is probably what is causing the problem.

@lord_alan - call to quote was removed in last commit, can you review?

Yes - it works now. My comment was added at about the same time you pushed the commit ;-)

Milestone changed to 7.2.0