Hello!

You can find more information about it here:

https://academy.creatio.com/docs/8.x/setup-and-administration/on-site-d…

https://academy.creatio.com/docs/8.x/setup-and-administration/on-site-d…

Hello Syed,

The issue here is that these values are also storred in cache and direct updating of these values are not reflected in the cache. That's why you have old values after updating values from the database directly.

What should be done after updating values in the database is Redis flush. But this will lead to all users to be logged out from the system and obviously cannot be performed during business hours for the application (or users should be notified that the Redis will be flushed soon). After Redis flush new system settings values will be used when working in the application.

Hi Damien,

If I understood your question correctly, I recommend you look at this discussion.

As described there, the most suitable solution, in this case, is a business process.

Printscreen of Error Logs

Managed to solve the problem by re-compiling FinApplicationSpec

Hi Federica,

The "BETArchiveFirstGeneration" and "BETArchiveSecondGeneration" tables have been added in the 7.17.1 version of Creatio. They are used as a way to archive old records from the BulkEmailTarget table. Records older than 1 year go into those tables.

To get information about the OLD licenses usage you would need to use the VwBulkEmailTarget view as it looks into both the BulkEmailTarget and BETArchive tables. 

Best regards,

Max.

Thank you very much Max for clarifying! :)

Hi Ibrahim,

Unfortunately, the SQL query console plugin is not supported anymore. As of now there are no alternatives but we are working on creating one. You can send the scripts you need to execute to our support address support@creatio.com and we will run them for you!

Best regards,

Max.

I am currently working on a new marketplace add-on for this as well.

For now, if you have the previous SQL Executor add-on in another system, you can export the package from the configuration to install into another system.

Ryan

Ryan Farley,

wondering if you have already created something useable, because the old SQL console is not really working anymore in the latest releases.

I'd be happy to contribute either with testing or development!

Thanks for your effort!

Ryan Farley,

Ditto, I'd be happy to contribute either with testing or development!

Hello,

It is possible. See https://customerfx.com/article/executing-direct-sql-statements-in-a-pro…

Ryan

Hi Jonathan, 

Please add the next using -     

     using Terrasoft.Common;   

on the top of the page(if you didn't have this one). 

Then in the part of the code when you are trying to retrieve the age:

if (name.IsNullOrEmpty())

{

return 0;

}

else

{

return age;

}

Best Regards, 

Bogdan L.

Hi Jonathan,

Usually you use dataReader to get the value from your select query. What you can do is:

bool hasRecord = false;
using (DBExecutor executor = UserConnection.EnsureDBConnection()) {
using (IDataReader dataReader = select.ExecuteReader(executor)) {
  while (dataReader.Read()) {
    hasRecord  = true;
  }
 }
}
if(hasrecord){
  return age
}else{
  return 0
}

Or you can just set the default value of the age =0. Therefore if the dataReader does not return any record, the default value age (0) will be returned.



regards,

Cheng Gong

Bogdan Lesyk,

Thanks for your answer. It helped a lot !

Cheng Gong,

Your answer is really perfect ! Thanks a lot, i'll definitely save this snippet of code for my future implementations.

Regards,

Jonathan

If you want to remove it completely:

1) Make sure your package has Samarasoft.SqlConsole as a dependency (or add this in Custom package)

2) Create a replacing view model and select parent "SystemDesigner"

3) Add this code:

define("SystemDesigner", [], function() {
	return {
		diff: [
			{
				"operation": "remove",
				"name": "SqlConsoleLink"
			}
		]
	};
});

If you want to only show it for the Supervisor user, do steps 1 & 2 above, but use this code instead:

define("SystemDesigner", [], function() {
	return {
		attributes: {
			"IsSqlConsoleVisible": {
				dataValueType: Terrasoft.DataValueType.BOOLEAN
			}
		},
		methods: {
			init: function() {
				this.callParent(arguments);
				this.set("IsSqlConsoleVisible", 
					Terrasoft.SysValue.CURRENT_USER_CONTACT.displayValue === "Supervisor"
				);
			}
		},
		diff: [
			{
				"operation": "merge",
				"name": "SqlConsoleLink",
				"values": {
					"visible": { "bindTo": "IsSqlConsoleVisible" }
				}
			}
		]
	};
});

Ryan

Hello Arthur,

And which connected records does the system show you? Also what happens when you drop the select result to null?

Best regards,

Oscar

Oscar Dylan,

When the screen of the connected records pop-up and I click to check the records there is nothing.

Also, when I set the result to null the same thing happen.

Regards,

Arthur

Arthur Hertz,

What is the result of the 

select top 5 * from MultiDeleteQueue

order by CreatedOn desc

right after trying to delete a record (message column values needed)? Also what error message do you receive in the application logs?

Best regards,

Oscar

Oscar Dylan,

I've put the csv file of the request in the post and also in the application logs in the "MultiDelete.log" file it's telling me this :

Terrasoft.Common.DbOperationException: L'instruction DELETE est en conflit avec la contrainte SAME TABLE REFERENCE "FKPkYRMonMU4O22bg1UtAWBnc3Y8". Le conflit s'est produit dans la base de données "MetropoleGestion", table "dbo.Activity", column 'ActivityConnectionId'.

File link : https://linkintouch-my.sharepoint.com/:x:/g/personal/ahertz_linkintouch_fr/ETEWcqG_sjxBtWFBLG7w0N8B5kXRMSIcl8gmZNvtBY-UKw?e=GhYepw

Regards,

Arthur

Arthur Hertz,

And can you please perform this select:

select ActivityConnectionId from Activity where Id = 'Id of the activity you delete'

and

select Id from Activity where ActivityConnectionId = 'Id of the activity you delete'

?

Seems that this column is not empty for some activity and uses its value as a reference for the activity you delete. 

Best regards,

Oscar 

Oscar Dylan,

The first request ActivityConnectionId is equal to NULL and for the second one there are no records.

Regards,

Arthur

Arthur Hertz,

Then you need to connect your local app to the IDE and debug the execution of deletion in the Visual Studio. There is something with the delete that is provoked by the code you've developed and you need to debug this logic.

Best regards,

Oscar

Oscar Dylan,

I've done it differently, when deleting the activity I send a message with the accountId linked to the activity deleted, and I catch it in the account edit page to do the necessaries processing. I had no problem with this method. Here is the code I've made for the sake of it.

onActivityDeletedReceived: function(scope, message) {
                var sender = message && message.Header.Sender;
                // make sure the message received is the one you sent
                if (sender === "ActivityDeleted") {
                 	 // if you sent some data with the message you can get it from the message Body
                    var MessageText = message.Body;
					var array = [];
                    var esq = Ext.create("Terrasoft.EntitySchemaQuery", {
                    rootSchemaName: "Activity"
                    });
                    // Add column with account name that refers to given account.
                    esq.addColumn("Id", "Id");
                    esq.addColumn("Account.Id", "AccountId");
 
                  	esq.filters.logicalOperation = Terrasoft.LogicalOperatorType.AND;
                  	var esqAccountFilter = esq.createColumnFilterWithParameter(Terrasoft.ComparisonType.EQUAL, "Account.Id", MessageText);
                  	var esqRdvFilter = esq.createColumnFilterWithParameter(Terrasoft.ComparisonType.EQUAL, "ActivityCategory.Id", "42c74c49-58e6-df11-971b-001d60e938c6");
					var esqRealiseFilter = esq.createColumnFilterWithParameter(Terrasoft.ComparisonType.EQUAL, "Status.Id", "4bdbb88f-58e6-df11-971b-001d60e938c6");
 
 
                  	esq.filters.add("esqAccountFilter", esqAccountFilter);
                  	esq.filters.add("esqRdvFilter", esqRdvFilter);
					esq.filters.add("esqRealiseFilter", esqRealiseFilter);
                    // Get entire record collection
                    esq.getEntityCollection(function (result) {
                        if (!result.success) {
                            // error processing/logging, for example
                            this.showInformationDialog("Data query error");
                            return;
                        }
                        result.collection.each(function (item) {
                           array.push(item.get("AccountId"));
                        });
                      	if(array.length === 0)
                        {
							this.set("ContactClientOuRepresentant", {value:"f550b45d-093e-43ba-bdd1-bc0bd43c8e16" , displayValue:"Non"});
							this.save({isSilent:true});
                        }
                    }, this);
				}
            },

Regards,

Arthur