For generic Activities there is one important Connected to category that is not included: Activity!   We often use long-life Activities that can contain many individual Activities as sub tasks.  However, we end up listing all of the individual Activities against an Opportunity or Account, without any sub structure.

 

Is there no way to add Activity to the list of objects that an Activity can be Connected to? 

 

Version Sales Team 8.0.1.1990

4 comments

We create many-to-many detail 'Linked Activities' and link there. 

Vladimir Sokolov,

Please elaborate....

Hello!

 

Creating details is a good idea.

 

Perhaps the following implementation will help you in solving your business problem:

 

1) It is necessary to create a lookup field in which we will bind activities: for example, "Main Activity".

 

2) Create a "Related activity" detail based on the Activity object.

 

3) Add a detail to the "Activity" page and link it to the section under the "Main Activity" column in the details.

 

 

As a result, if you fill in the "Main Activity" field in the activity, and go to this activity, then all related activities will be displayed in the detail.

There will be a one-to many relationships, one parent will have many child activities.

For example:

 

 

 

 

I hope this helps you.

 

Best regards,

Kate

As we don't define Parent - Child and use many-to-many relation, we have another schemas:

So, the object looks like

Detail 'Linked activity' is added to the Activity page with following filter:



 

			linkedActivityFilter: function() {
				var id = this.get("Id");
				var filterGroup = new this.Terrasoft.createFilterGroup();
				filterGroup.logicalOperation = this.Terrasoft.LogicalOperatorType.OR;
				filterGroup.add("activityAFilter", this.Terrasoft.createColumnFilterWithParameter(
					this.Terrasoft.ComparisonType.EQUAL, "UsrActivityA", id));
				filterGroup.add("activityBFilter", this.Terrasoft.createColumnFilterWithParameter(
					this.Terrasoft.ComparisonType.EQUAL, "UsrActivityB", id));
				return filterGroup;
			},

 

Show all comments

I want to show only the Completed value, not the other values of the lookup.

Printscreen:

Another printscreen :

Is there some lookup where these values are stored, or they are hardcoded an I cant modify them ?

Like 0

Like

2 comments
Best reply

Hello Petrika,

 

For the 1st image, you can search for the lookup named "Activity results" and set the "Available in business process only" column to true/Yes for the values which you don't want to see in the dropdown:

 

 

For the 2nd image, you can search for the lookup named "Activity statuses" and delete/add the values which you want to see in the dropdown:

 

 

Regards,

Sourav

Hello Petrika,

 

For the 1st image, you can search for the lookup named "Activity results" and set the "Available in business process only" column to true/Yes for the values which you don't want to see in the dropdown:

 

 

For the 2nd image, you can search for the lookup named "Activity statuses" and delete/add the values which you want to see in the dropdown:

 

 

Regards,

Sourav

Sourav Kumar Samal,

Thank you very much , it worked

Show all comments

Hello Community!

I have modified the Activity object in order to display a custom Object (Order) and added an Activity column too. 

Now, when clicking on the RightSideMenu I have the same object (Activity = Attività, and Ordini = Orders) repeated twice. Does anybody know which module is in charge of displaying the options within this menu? Or do you have any idea of what the "cleanest" solution might be?

Thank you and have a great day! :) 

Like 0

Like

5 comments
Best reply

Federica,

 

Basically, there is a table in the database called EntityConnection. You can delete all the records from this table that refer to the objects which you do not need (for example, contact, requests etc).

You can do the following:

delete from EntityConnection where SysEntitySchemaUid in (select Uid from SysSchema where Name = '')

where '' is the name of the object, for example, Contact.

But the thing is if you delete the records from the EntityConnection table - the next fields on the activity page will be deleted automatically as well:



Best regards,

Bogdan

Hello Federica,



Could you please send the screenshot once again?



Best regards,

Bogdan

Hello Bogdan,



Here's the image, sorry for the mishap

Federica,

 

Basically, there is a table in the database called EntityConnection. You can delete all the records from this table that refer to the objects which you do not need (for example, contact, requests etc).

You can do the following:

delete from EntityConnection where SysEntitySchemaUid in (select Uid from SysSchema where Name = '')

where '' is the name of the object, for example, Contact.

But the thing is if you delete the records from the EntityConnection table - the next fields on the activity page will be deleted automatically as well:



Best regards,

Bogdan

Thank you Bogdan! That's exactly what I did (according to your suggestion) ! :) Do you happen to know how to change the icon too? 

 

I made a few tests and to access the icons I need to implement EmailItemSchema client module

Now: 

Show all comments

Hello team,

 

Can somebody help me or give me some hint what to do regarding my problem. 

So I want to remove one Activity from this menu, see my screenshot: 

I want to remove this "übergeordnete Aktivität" from this meni. 

Can you please help me out with this problem, thanks in advance!

 

Kind regards,

Marijana

Like 0

Like

1 comments

Hello Marijana, 

 

In order to delete the object from this list, there is a need to delete corresponding records from the EntityConnection system table.

You can delete all the records from this table that refer to the objects which you do not need (for example, contact, requests etc).

You can do the following:

delete from EntityConnection where SysEntitySchemaUid in (select Uid from SysSchema where Name = ''), 

where '' is the name of the object, for example, Contact.

But let me mention, that if you delete the records from the EntityConnection table - the corresponding fields will be deleted not only from this list but also from the "Connected to" detail of the email activity page:

 

Best regards,

Anastasiia

Show all comments

Dear Community,

 

Does any1 know how to remove some of the sections under 'Connected To' field group in 'Activity' section? Please see attached picture

And at later stage, if I want to add them back how can I do

 

Please kindly advise

 

Many thanks

 

Mich

Like 0

Like

3 comments

Hello Mihn,

 

Unfortunately, your task cannot be achieved by using OOTB tools.

Business rules functionality can be used for "Connected to" detail only for filtration. But sadly, other rules will not be applied to this detail.

 

We have already registered the corresponding query for our R&D team and will be waiting for the implementation of this functionality in future releases.

 

Thank you,

Artem.

Hello Mihn,

you can hide using css rule

hi Stefano,

 

Can you show me a bit in details about CSS rule please

 

Thanks in advance 

 

Mi

Show all comments

Hi, community.

When you click an activity on dashboard within Case, you get mini page where you can complete the activity or cancel it. I need to remove the "cancel activity" button for specific type of case service.

I have found how to remove 'Cancel activity' from all  mini pages,

diff: 
/**SCHEMA_DIFF*/[ 
{ "operation": "remove", "name": "CopyButton" }, 
{ "operation": "remove", "name": "DeleteButton" }, 
{ "operation": "remove", "name": "OpenButton" } }

but need to add extra condition to apply it only for cases with specific Service.

 

Best regards,

Jana

 

Like 0

Like

2 comments

Hello Jana,

 

You can try replace ActivityMiniPage view model by this code. Inside canCancelActivity method You can implement Your logic.

 define("ActivityMiniPage", [], function() {
	return {
		entitySchemaName: "Activity",
		messages:{
				"GetColumnsValues": {
				mode: Terrasoft.MessageMode.PTP,
				direction: Terrasoft.MessageDirectionType.PUBLISH
			},
		},
		methods: {
			canCancelActivity: function() {
				var stage = this.sandbox.publish("GetColumnsValues", ["Stage"], [this.values.MiniPageSourceSandboxId]);
				return stage.Stage.displayValue=='Presentation'? true : false;
			},
		},
		diff: /**SCHEMA_DIFF*/[
			{
				"operation": "merge",
				"name": "CancelButton",
				"values": {
					"visible": {"bindTo": "canCancelActivity"},
					"tag": "Cancel"
				}
			}
		]/**SCHEMA_DIFF*/,
		rules: {}
	};
});

Best regards,

Marcin

Marcin Kott,

Thank you!

Show all comments

how can I add a link to a created activity on the email sent by "Send email to case assignee"  process ?? 

 

 

Like 0

Like

3 comments

Hello Eran, 

 

Could you please elaborate a bit on your business task, do you need to have the direct link to the activity page ( meaning email record sent by "Send email to case assignee"  process) or which functionality exactly should be achieved?

 

Thank you in advance!

Best regards, 

Anastasiia 

Hi,

There is a process (in process library) "Send email to case assignee" that sends email to the employee once a task is assigned to him. 

This process creates a new activity (for the employee to handle the case) and populate the "Specifying case assignee" email template, then sends it to the employee email.

 

I need to add a link in this template that will take the user directly to the newly activity page that was created by the process.

 

I hope it's clearer now  :-).

 

Thanks.

Hello Eran,

 

We've been able to build a process that would make such an idea work. Please follow this link to download the process, then you need to install it on your instance to see how everything works.

 

Just a few comments though:

In the [Add data] element, you would need to change the "To" and "From" fields to the values you need. Also, please remember that this is just an example of how such logic can be implemented and that it is possible. However, though this process could work on its own, you will need to implement it into the "Send email to case assignee" business process on your own and make changes to it so it could work seamlessly within the main process.

 

Please let me know if any questions appear or additional information is needed!

 

Kind regards,

Mira

Show all comments

Dear Team,

 

We have changed/added new stages based on the customer requirement and they don’t want any activities to be created/performed in stage movement. Hence only stages are added but OOTB activates are showing up. Even though no activities are available in the opportunity case stage.

 

Question : How To disable/remove the OOTB activities from the section .

 

Thanks in advance! 

Like 0

Like

1 comments

Hello,

 

These activities are most likely created by different business processes. I would suggest checking if there are any processes in the process log that are starting immediately after you change the stage. There might be processes that are being triggered by the DCM or the ones that have the starting signal set to a change in the stage of the opportunity. The processes can contain "Perform task" elements which you can remove or disable these processes altogether.

 

Hope it helps!

 

Best regards,

Max.

Show all comments
Question

Hi community!

Please help me to find out where are activity reminders stored in the database?

I mean this kind of reminders ->btn_com_notification_center_reminders.png – activity reminders created for you when you are the owner or the author of the activity.

I was searching in the "Reminding" table by "SourceId" column (passing here Activity Id), but nothing was found. In the notification panel reminder appeared. Any suggestions?

Best regards,

Jana

Like 0

Like

2 comments
Best reply

Hi Jana,

 

Sharing a little lifehack on how to track the record in the database:

 

1) When switching to the "Activity reminders" tab you need to have the developer console opened in the "Network" tab.

 

2) You need to track all the "SelectQuery" requests that were sent after the switch to the "Activity reminders" (the request is the only one in our case):

 3) Click on this request, go to it's payload and find the value for the "rootSchenaName" key:

 

So the table we are interested in is "Reminding".

 

4) Create some reminding in any activity that has no reminding (for example specify the value for the "Remind to owner date" column as current time minus 15 minutes). This action will create a new record in the "Reminding" table.

 

5) Go to the database and execute this query:

--MSSQL
SELECT
	TOP 1 *
FROM
	Reminding
ORDER BY
	CreatedOn DESC
 
--PostgreSQL
SELECT
	*
FROM
	"Reminding"
LIMIT 1;

As a result you will find a newly created record:

Now you can easily track column references:

 

1) Activity Id from which you've initialized the reminding is stored in the SubjectId column;

2) The reference to the schema of the "Activity" (meaning that the reminding was created for the record in the "Activity" section) is stored in the SysEntitySchemaId column that references SysSchema table (UId column);

3) SourceId column defines if the reminding was initialized either for owner or reporter (RemindingSource table reference);

4) Description column stores the subject of an activity for which the reminder was generated.

 

Try this approach on your side and you will be able to easily track database tables in which data from any section/detail/tab is stored.

 

Best regards,

Oscar

Hi Jana,

 

Sharing a little lifehack on how to track the record in the database:

 

1) When switching to the "Activity reminders" tab you need to have the developer console opened in the "Network" tab.

 

2) You need to track all the "SelectQuery" requests that were sent after the switch to the "Activity reminders" (the request is the only one in our case):

 3) Click on this request, go to it's payload and find the value for the "rootSchenaName" key:

 

So the table we are interested in is "Reminding".

 

4) Create some reminding in any activity that has no reminding (for example specify the value for the "Remind to owner date" column as current time minus 15 minutes). This action will create a new record in the "Reminding" table.

 

5) Go to the database and execute this query:

--MSSQL
SELECT
	TOP 1 *
FROM
	Reminding
ORDER BY
	CreatedOn DESC
 
--PostgreSQL
SELECT
	*
FROM
	"Reminding"
LIMIT 1;

As a result you will find a newly created record:

Now you can easily track column references:

 

1) Activity Id from which you've initialized the reminding is stored in the SubjectId column;

2) The reference to the schema of the "Activity" (meaning that the reminding was created for the record in the "Activity" section) is stored in the SysEntitySchemaId column that references SysSchema table (UId column);

3) SourceId column defines if the reminding was initialized either for owner or reporter (RemindingSource table reference);

4) Description column stores the subject of an activity for which the reminder was generated.

 

Try this approach on your side and you will be able to easily track database tables in which data from any section/detail/tab is stored.

 

Best regards,

Oscar

Hi Oscar, 

 

Thank you for the lifehack and detailed response! It was very useful for meyes

 

Best regards, 

Jana

 

Show all comments

Hi Community,

 

We are lookin at making the activity mini page(New task creation page in Activity section) draggable.

 

Any info on converting the mini page draggable will be of much help.

 

Regards

Like 0

Like

0 comments
Show all comments