Question

Cases: Feed

Hi community!

 

I need to insert feeds in Cases through database, please help me to find out the relations between tables.

I have found that feed is stored in "SocialMessage". How is it related to "Case", which tables must be updated ?

What are "EntityShemaUid", "EntityId" in "SocialMessage" table?

 

Best regards,

Jana

Like 0

Like

2 comments
Best reply

Hello Jana!

 

EntityShemaUid - this is the ID of Section, where the feed is stored

 

EntityId - this is the ID of particular record in Section

 

In order to insert feeds in Cases through database, please find the Uid of Case section:

 

SELECT Name, Uid from SysSchema

 

Then insert needed info and specify values for these columns in the INSERT query.

 

Best Regards, 

 

Bogdan L.

 

 

Hello Jana!

 

EntityShemaUid - this is the ID of Section, where the feed is stored

 

EntityId - this is the ID of particular record in Section

 

In order to insert feeds in Cases through database, please find the Uid of Case section:

 

SELECT Name, Uid from SysSchema

 

Then insert needed info and specify values for these columns in the INSERT query.

 

Best Regards, 

 

Bogdan L.

 

 

Bogdan, thank u smiley

 

Show all comments