Coming soon: Your brand new Help Center & Community! Get a sneak-peek here

The interest pin in the person archive is visible even if a person do not have an interest ticked in the interest tab.

Hi all,

Version: SuperOffice 8.0 SR5 Build 6352

We have done some deletions from the interest tables using SQL.
Someting like this.
delete crm7.personinterest where person_id in (select person_id from dbo.personstodeleteinterestsfor)

For the persons where interests have been deleted the interest pin in the person archive is still showing.
If I open the person card/dialog there are no dot on the interest tab and no interests ticked.
If I save the person the interest pin in the person archive is gone.

The behaviour is the same in the web client.

Are there more places in the database where information about person interests are stored than in the personinterest table?

Best regards

Patrik

 

RE: The interest pin in the person archive is visible even if a person do not have an interest ticked in the interest tab.

Hello,

See the "activeInterests" field on the PERSON and CONTACT tables.  You can recalculate these fields using the DBSetup -> database consistency check:

Af: David Hollegien 17. okt 2018

RE: The interest pin in the person archive is visible even if a person do not have an interest ticked in the interest tab.

Thanks.

Af: Patrik Lindholm 17. okt 2018

RE: The interest pin in the person archive is visible even if a person do not have an interest ticked in the interest tab.

Checked again, it did not help.

Best regards

Patrik

Af: Patrik Lindholm 17. okt 2018

RE: The interest pin in the person archive is visible even if a person do not have an interest ticked in the interest tab.

Or use Bulk Update on a selection to Add/Remove any interests....
You can do both in the same job.
/conrad

 

Af: Conrad Weyns 17. okt 2018

RE: The interest pin in the person archive is visible even if a person do not have an interest ticked in the interest tab.

Thanks Conrad,

Bulk Update is not avaliable, it is 8.0 SR5

Where are the information stored, is it cached somewhere, userpreferences, ...?

Best regards

Af: Patrik Lindholm 17. okt 2018

RE: The interest pin in the person archive is visible even if a person do not have an interest ticked in the interest tab.

Sorry,

I found Add/Remove interests on selection but that does not help me in this case.

The interests are already removed, it is just the interest pin that is wrongly shown.

 

Best regards

 

Af: Patrik Lindholm 17. okt 2018

RE: The interest pin in the person archive is visible even if a person do not have an interest ticked in the interest tab.

Maybe you should delete SOCache and restart SuperOffice (Windows).

Af: Martin Andersen 17. okt 2018

RE: The interest pin in the person archive is visible even if a person do not have an interest ticked in the interest tab.

Hi Martin,

Thanks.

Have done that, it does not help.

Best regards.

Af: Patrik Lindholm 17. okt 2018

RE: The interest pin in the person archive is visible even if a person do not have an interest ticked in the interest tab.

Hello,

Do the following query's give a result?

SELECT * FROM CRM7.CONTACT WHERE
activeInterests != (SELECT COUNT(*) FROM CRM7.CONTACTINTEREST WHERE CRM7.CONTACTINTEREST.contact_id = CRM7.CONTACT.contact_id) 

SELECT * FROM CRM7.PERSON WHERE
activeInterests != (SELECT COUNT(*) FROM CRM7.PERSONINTEREST WHERE CRM7.PERSONINTEREST.person_id = CRM7.PERSON.person_id) 

If true, use these query's to update:

UPDATE CRM7.CONTACT 
SET activeInterests = (SELECT COUNT(*) FROM CRM7.CONTACTINTEREST WHERE CRM7.CONTACTINTEREST.contact_id = CRM7.CONTACT.contact_id) 
WHERE
activeInterests != (SELECT COUNT(*) FROM CRM7.CONTACTINTEREST WHERE CRM7.CONTACTINTEREST.contact_id = CRM7.CONTACT.contact_id) 

UPDATE CRM7.PERSON 
SET activeInterests = (SELECT COUNT(*) FROM CRM7.PERSONINTEREST WHERE CRM7.PERSONINTEREST.person_id = CRM7.PERSON.person_id) 
WHERE
activeInterests != (SELECT COUNT(*) FROM CRM7.PERSONINTEREST WHERE CRM7.PERSONINTEREST.person_id = CRM7.PERSON.person_id) 
Af: David Hollegien 17. okt 2018

RE: The interest pin in the person archive is visible even if a person do not have an interest ticked in the interest tab.

Thanks, that helped me fix it.

Either I'll buy you ar beer on Expander world or you will get one of drink tickets (if we get drink tickets this year) :)

Best regards

Patrik

Af: Patrik Lindholm 17. okt 2018

RE: The interest pin in the person archive is visible even if a person do not have an interest ticked in the interest tab.

Great to hear that that fixed it! I will be at expander world ;)

 

Af: David Hollegien 17. okt 2018