+- CoreBOSBB (https://discussions.corebos.org)
+-- Forum: Support (https://discussions.corebos.org/forumdisplay.php?fid=17)
+--- Forum: Administrator Support (https://discussions.corebos.org/forumdisplay.php?fid=8)
+--- Thread: Suggestion - Find Duplicates (/showthread.php?tid=622)
Suggestion - Find Duplicates - rslemer - 03-28-2017
When you try cleaner some data, using a duplicated check icon, to found a possible duplicated, one problem is a field you need search, has many registry without any information ( blank field )
This case, all registry ( have no information ) is showed as duplicated
I think a good ideia is not considered, in this case, filed in blank, or created a global variable to set this ( see blank field or not )
Or better, create a new GV with value to be ignored when duplicated check. I think SQL command is possible isn't ?
See attached screen
RE: Suggestion - Find Duplicates - joebordes - 09-13-2017
This is not easy. It gets complicated with the interactions among the different fields. I will keep it in mind but even a global variable is complicated to get right.