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
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.