Dear Akshit,

Unfortunately, it is impossible to determine the root cause of the issue using the provided stack trace. Please note that it is only possible to define that the issue happened due to the incorrect sql syntax.

In order to resolve the issue please check all sql-queries and esq calls that are located in the package.

Best regards,

Norton

Dear Akshit, 

Could you please open web console when the issue occurs and send a screenshot of an error that occurs? 

Best regards, 

Dennis 

Dear Akshit, 

Could you please open web console and send a screenshot of an error that occurs? 

Best regards, 

Dennis 

Hi Dennis Hudson,

Yes sure !

Hi Akshit,

Could you please also send the schema name and all code in the schema in the text file? It looks like the issue may be in the different parts of the code. 

Best regards, 

Dennis 

Hello Mark,

For your goal you can use next trigger signal:

This start signal will be triggered by any email realted to the existing case (in our example it will work for incoming and ourgoing emails, but you can change it by selecting the needed value for Message type).

If you want to tigger new cases (which were just created by incoming emails) you need to choose 'Record added' option for "Which event should trigger the signal" fieild.

Best regards,

Roman

Dear Akshit, 

Everything seems to be correct with the code itself. I tried a very similar code with the OOB tables and it returned correct result: 

public void Execute(UserConnection userConnection)
        {
            var result = "";
            var sel = new Select(userConnection)
                    .Column(Func.Sum("Order", "Amount")).As("OrderAmount")
                .From("Order")
                .Where("AccountId").IsEqual(new Select(userConnection)
                                                .Column("Id")
                                                .From("Account")
                                                .Where("Name").IsEqual(Column.Parameter("Accom (sample)")))
                                   .And("StatusId").IsNotEqual(new Select(userConnection)
                                                .Column("Id")
                                                .From("OrderStatus")
                                                .Where("Name").IsEqual(Column.Parameter("2. Confirmation")))
                 as Select;
            result = sel.ExecuteScalar<int>().ToString();
            Console.WriteLine(result);
        }

You get 0 most likely because no records match the filter. Please run this query in SQL (SQL executor if your instance is in the cloud) and check what result you get.  

Best regards, 

Dennis 

Hi Harvey, 



Unfortunately, it is not possible to implement such behavior using out-of-the-box functionality.



But it is possible to do it with the help of additional development

which will perform the page validation to check if here's a file attached.



Thank you!



 

Bohdan Zdor,

Do you have an example of how this might be done so that it integrates nicely with how Case Management works out of the box? i.e. disabling clicking on a subsequent step unless a certain data condition is true? The simplest way I can think to implement this would be to have validation on the save event, but this would still allow the user to click on the subsequent stage but just fail to save, which isn't a great user experience.

Thanks,

Harvey

Harvey Adcock,

 

Such integration is possible in theory, but we did not face such integration before. You can only operate with the information which is available on the Academy.



Thank you.

Dear Akshit, 

For those steps, there is no difference if the section is custom or OOB. If you've made all steps of the instruction correctly please clear cache and cookies. If you still don't see the action please check that you've correctly added it in getSectionActions method and that you don't have any errors in the console. If you check that all steps were done correctly and after clearing cache you don't see the button please send your code for adding the action.

Best regards, 

Dennis  

Hello,

The Detail column in the settings is set to Id that may not be correct in your case.

Try to change the Detail column value from "Id" to "CaseId" . That should help.

Let me know the resuts.

Regards,

Dean

Dean Parrett,

It does not look like that will work. CaseId is not a column on the Changes object.

I recognize this detail was set up wrong, I am not looking to fix it, I just want to know with the existing settings, is it possible to know which Change records were added on which Case record page?

Dear Mitch,

It seems like Changes object is not connected to the Case object. The Detail column field doesn't have Case in the drop down list since the Changes object doesn't have the column based on Case object. Most likely the same happens to Case object, it doesn't have any lookup field based Changes object. I might be wrong if the fields just have different titles. Try to look through the lookup field of both objects and see if there are any lookups based on Cases and Changes objects. If they do exist, you can try to build filter in the section to see if the case records that have some existing records in Changes.

Regards,

Dean

Dean Parrett,

Thanks Dean. I did find that there is a lookup column for Cases on the Changes object, however the column is blank for all records because the objects are not connected. I think I'm out of luck.

Try change .IsEqual() on  .in(select)

and change .IsNotEqual(   on   ..Not().in(select)

Or use CustomQuery for use sql code with creatio

 Smile samples

			var delete = new Delete(UserConnection)
				.From("PersonalAccountRegistration")
				.Where("Id").In(new Select(UserConnection)
					.Column("par","Id")
					.From("PersonalAccountRegistration").As("par")
					.LeftOuterJoin("VerificationCode").As("hvc")
					.On("hvc", "Id").IsEqual("par", "HashId")
					.LeftOuterJoin("VerificationCode").As("svc")
					.On("svc", "Id").IsEqual("par", "VerificationCodeId")
					.Where("hvc", "ExpiresOn").IsLess(Column.Const(nowDate))
					.Or("svc", "ExpiresOn").IsLess(Column.Const(nowDate))
				);
			delete.Execute();

Hi Grigoriy,

I make the changes as per your suggestion but still It shows the same error.

I think the problem is with this bolded select query inside Set method : 

var up = (Update) new Update(UserConnection,"UsrBeta").Set("UsrAmountForTheMonth", new                                                                                Select(UserConnection)

                                                                            .Column("UsrDueAmount")

                                                                            .From("UsrBeta")

                                                                            .Where("Id").In(select)                                                                                                       )

                                                                .Where("Id").In(select);

Beacause I have to update the value of "UsrAmountForTheMonth" column with the value of "UsrDueAmount" column for each selected record in the select query.

But the bolded subquery inside Set method returns the collection of "UsrDueAmount" values.

This is how my section looks like!

Please suggest any solution to the same.

Thanks.

                 

Akshit,

As I wrote above, for complex cases, try writing and debugging a sql query and calling it as in the example below

var sqlText=@"update ....";

var customQuery = new CustomQuery(UserConnection, sqlText);

var rowCount = customQuery.ExecuteScalar<int>();

or

                var selectQueryString =
                    @"update ""Lead"" set ""ScpTimer"" = QS.""ScpLifetimeDays"" - (CAST(NOW() AT TIME ZONE 'UTC' AS date) - CAST(LD.""ScpDateTransitionNewStatus"" AS date))
                    from ""Lead"" as LD
                    inner join ""QualifyStatus"" as QS on QS.""Id"" = LD.""QualifyStatusId""
                    where LD.""Id"" = ""Lead"".""Id"" and ""Lead"".""QualifyStatusId"" in  (
                    'd790a45d-03ff-4ddb-9dea-8087722c582c',
                    'ceb70b3c-985f-4867-ae7c-88f9dd710688',
                    '128c3718-771a-4d1e-9035-6fa135ca5f70',
                    '7a90900b-53b5-4598-92b3-0aee90626c56')";
                var selectQuery = new CustomQuery(userConnection, selectQueryString);
                selectQuery.Execute();

Hi Grigoriy,

This time it works Thank you very much for your constant support! 

Best Regards. 

Try this

.....

.Where(Func.Month("UsrDate")) .IsEqual(Column.Parameter(currentMonth));

Hi Grigoriy,

Thank you very much! It works

Hi Grigoriy,

I have to sum up the values of Column("Score") of several records so for this what should I use in place of Func.Month() .

Can you provide the reference for This Func method? 

Many Thanks.