Hello,



I have checked this information with the R&D team responsible for the SSO integration. They confirmed that it is possible to set up Google SSO authorization. Unfortunately, we do not have specific instructions, as this authentification is not quite popular among our clients, but you can use, for example, this instruction to set it up. 



Furthermore, we will register the project for our R&D team to publish the required instruction

If you look at the Cases_FormPage it hide a lot of elements of the page is in “create” mode using a business rule that just checks if CreatedOn is filled in or not. 

Ryan

Hi Ryan,

I couldn't find the CreatedOn field/property via business rule or the JS. There is a field called created time though. Also, do you have any suggestions for the update?

Thanks,

J

Hello,



There is no such OOB intergmation. 



But we've registered it in our R&D team backlog for consideration and implementation in future application releases.



As for now, you can make your own integration using API\Odata:

https://academy.creatio.com/docs/developer/integrations_and_api/data_se…

Thank you for helping us to improve our product. 

MIght be simpler in the future :) https://academy.creatio.com/docs/release/creatio-roadmap?status[]=1510&…

Damien Collot,

Thanks for sharing, but unfortunately I don't have access to see the content of the link

Also don't have access to the link:)

This module is named OmniChatModule and it is pretty unique. As you may noticed it doesn't have a structure where elements are contained in a diff panel, instead, it creates them in code (check the method render() in it).

Currently, if you want to add something to it, you need to analyze the logic of the OmniChatModule schema and OmniChatUtilities to write your own version. For example, when you click on the context name, it triggers the method openContactCard in OmniChatUtilities.

To be honest, I can't guarantee that it is even possible to modify this panel in the current version.

Hello Javier,

Regarding the general function of OData, you can find detailed information in the following resource:

OData Overview

For more specific examples and methods, you can refer to this documentation:

OData Methods and Examples

API for file management

Hello,

You can use the EntitySchemaQuery to get the number of attachments:

onEntityInitialized: function() {
				this.callParent(arguments);
				var contactId = this.get("Id");
				var esq = Ext.create("Terrasoft.EntitySchemaQuery", {rootSchemaName: "ContactFile"});
                esq.addColumn("Contact");
                    var filter = esq.createColumnFilterWithParameter(Terrasoft.ComparisonType.EQUAL, "Contact", contactId);
                    esq.filters.add("filter",filter);
                    esq.getEntityCollection(function (result) {
                        if (result.success) {
                        	window.alert("This record has " + result.collection.collection.length + " attachments");
                        }
                    }, this);
			},

This works, but does produce some odd results on some pages - for example the Case page shows several things once the CreatedOn is populated and it appears that the data isn't reloaded after the save. So you'd probably also have to do a reload in addition to this: 

{
    request: "crt.SaveRecordRequest",
    handler: async (request, next) => {
        request.preventCardClose = true;
        return next.handle(request);
    }
}

Ryan

Thanks for sharing Ryan

If the end result you're after is to add days to a date, you can use a formula such as:

[#Case.TheDateField#].AddDays(3)

Note, the [#Case.TheDateField#] would be the date fields read in the process. the important part is the .AddDays(3) which would add 3 days.

Ryan

Hello,

The problem here is that this user task is written for MSSQL, and there is a query that looks like this:

var selectQuery = new Select(_userConnection) .Column("dow", "Code").As("Code") .From("DayOfWeek").As("dow") .InnerJoin("DayInCalendar").As("dic").On("dow", "Id").IsEqual("dic", "DayOfWeekId") .InnerJoin("DayType").As("dt").On("dic", "DayTypeId").IsEqual("dt", "Id") .Where("dt", "IsWeekend").IsEqual(Column.Parameter(1)) .And("dic", "CalendarId").IsEqual(Column.Parameter(calendarId)) as Select;

We are interested in this line: .Where("dt", "IsWeekend").IsEqual(Column.Parameter(1))

In MSSQL, boolean columns are represented as 0 and 1 (false and true, respectively), whereas in PostgreSQL, they are represented as true and false. To address this issue, there are a few options:

- Avoid using this line of code and find an alternative way to filter the data without relying on the boolean comparison directly.

- Reach out to the addon developer and ask them to make the necessary adjustments to handle the PostgreSQL boolean representation.

- Try searching for a PostgreSQL-specific cast or conversion function that can convert an integer (1 or 0) to a boolean (true or false). 

Ryan Farley,

Thank you, but I need to add only working days.  The user task named  

"Add Business Days" is what I need but the problem is that it only works for MSSQL and not for PostgreSQL. 

Claudia.

Hello!

At the moment we are carrying out preparatory work to move the product line from large products to composable applications and to comply with the upcoming release of the new pricing.

As part of this work, ITIL sections (including the Configurations section) have been removed from the builds for the new sites. For backwards compatibility when upgrading, the ITIL functionality packages remain on the existing sites.



Best regards,

Maria

Kevin,

You can see in this post that the ITIL sections are back when installing the component. Please follow this thread: https://community.creatio.com/ideas/itil-objects-configuration-items-pr…