Reset All Duplicates with one click

[WOP]

Wish 1. For a reset/refresh button, which applies to all modifable fields for all duplicates.

Perhaps one button, in the Duplicates Fields Configuaration box.


It would suit me, anyway. As the current method, does not always work on my setup, which has a number of custom variables.

Thanks
B

[cdicken]

Thanks Bea - I've reported this to the team.

[Bruce]

Hi Bea,

There is a SQL Query you can run on the Database if you want to update custom variables on duplicates.

Please make a backup of the Database before you do anything just to be on the safe side.

First SQL as Query1

SELECT UserDefinedProperties.sContentID,
UserDefinedProperties.nVariableID, UserDefinedProperties.sValue,
UserDefinedProperties.sStatus
FROM UserDefinedProperties
WHERE (((UserDefinedProperties.sContentID) Not Like "*!*") AND
((UserDefinedProperties.nVariableID)=65877));

Second SQL as Query2

SELECT UserDefinedProperties.sContentID,
UserDefinedProperties.nVariableID, UserDefinedProperties.sValue,
UserDefinedProperties.sStatus, Variable.sName
FROM UserDefinedProperties INNER JOIN Variable ON
UserDefinedProperties.nVariableID = Variable.nID
WHERE (((UserDefinedProperties.sContentID) Not Like "*!*") AND
((Variable.sName)=[check name]));

SELECT UserDefinedProperties.sContentID,
UserDefinedProperties.nVariableID, UserDefinedProperties.sValue,
UserDefinedProperties.sStatus, Right([sContentID],Len([sContentID])-2) AS
Expr1, Variable.sName
FROM UserDefinedProperties INNER JOIN Variable ON
UserDefinedProperties.nVariableID = Variable.nID
WHERE (((UserDefinedProperties.sContentID) Like "*!*") AND
((Variable.sName)=[variable name]));

it will ask u to enter the variable name, in ur DB u need to enter the appropriate value.

Third SQL
UPDATE Query2 INNER JOIN Query1 ON Query2.Expr1 = Query1.sContentID SET
Query2.sValue = [Query1]![sValue];


Note: If you are not comfortable doing this leave it well alone.

Kind regards,

[Jan]

AND
((UserDefinedProperties.nVariableID)=65877));

this bit looks wrong Bruce that would only update 1 particular variable.

Regards.

Jan

[WOP]

Please confirm SQL queries

Hi Bruce,
This seems to be just what I need.

Could you confirm whether the SQL Queries would update all my duplicates please?

Thank you
B

[cdicken]

Yeah - looking at the code it looks like it will reset the custom properties for ALL your duplicates.

[gabrielcrowe]

There is a SQL Query you can run on the Database if you want to update custom variables on duplicates.

nice SQL, mind if i pinch it for Actinet?

[george]

nice SQL, mind if i pinch it for Actinet?

Err, aye okay.


*invoices Gabriel for Agents Fee*