Author Topic: Find an merge results order (Read 1409 times)

alanski · November 06, 2009, 09:15:15 am

I get different lists ( or order of lists) when clicking 'Use Rule' under Find and Merge.

Is this a bug or is some other logic at work

alanski

Donald Lobo · November 06, 2009, 09:27:55 am

can u check if the contents of the lists are the same for all invocation of the same rule?

the order can potentially be explained as a mysql temp table creation and select statement where there are multiple matches on the same combined weight

lobo

alanski · November 07, 2009, 02:45:08 am

Yes they appear to be identical but in no specific order.

I made the individual rule weights unqiue and bingo - same order each time.

cheers

alanski

alanski · November 07, 2009, 03:42:46 am

Actually I lied.
It only works for one rule, other rules are still in error.

Does temp table you mentioned need dropping or is there something else going on?

alanski

Donald Lobo · November 07, 2009, 07:19:31 am

if the contents are the same, why does the order matter?

You can put an additional ORDER clause in:

CRM/Dedupe/BAO/RuleGroup.php, function thresholdQuery

lobo

CiviCRM Community Forums (archive)

News: