Question

Hi Community. 
I have this piece of code: 

segmentationBatch is List 

but postgres throws an error that it can't compare uuid with uuid[] - which is understandable, but how do I pass a list of Id's into the update? 

Has anyone came accross this issue? 

 

P.S. I need it that way because it's a batch of records that I need to update and I need to keep those Id's for the following logic so I cannot rebuild the filtering criteria here.

var update = new Update(UserConnection, EntitySchemaName)
                .Set("UsrProfitCenter", Column.Parameter(segmentation.ProfitCenter))
                .Where("Id").In(Column.Parameter(segmentationBatch)) as Update;
            return update.Execute();
Like 0

Like

0 comments
Show all comments

When we set up a filter on the List page of the web interface, it works on the web interface but not on the mobile interface.

Filtering is not working in the Creatio Mobile (Freedom UI)

Could  you please let us know, how can we setup filter in mobile.

Like 0

Like

0 comments
Show all comments

Hi.

 

I have this simple BP that has a Guid parameter which represents the Id of a real file inside the system. I take this file into a "Process file" element and tries to save it inside a specific Contact's attachment detail:

 

Then, in another "Process file" element up next, I take that file created inside the Contact's attachment detail in order to use it in the "Send Email" element:

 

 

However, upon checking both the email Activity created from this BP, as well as the Process log for this BP, nothing is attached:

Also, the resulting file collection from the second "Process File" element seems to be empty as well:

 

 

What am I doing wrong? I feel like this should work, it's a pretty simple example.

 

Thanks in advance,

Laurentiu

Like 1

Like

1 comments

Your account attachments/files could be using one of two file locations/objects. With Freedom UI a generic " attached file" object was introduced that could be used with any object. However, many objects have specific file/attachments objects, such as "Account files", or "Contact files" (sometimes those are named "File and link of account"). Make sure that you're using the correct object based on what you have on the screens. To check this, open the page in the designer and click on the attachments list, you'll see the object the page is actually using there in the "File storage location" property. 

Ryan

Show all comments

Hi all,

 

In our project we need to produce with Creatio application some .pdf documents. In order to do this we found a Creatio Application (Aspose.PDF connector). This application is not free of charge.

 

We were wondering if exists an OOTB (free of charge) functionality to produce .pdf documents. We are asking since on our view 'production of .pdf document' must be an OOTB functionality. Moreover it's very hard to convince a customer that this functionality it not free of charge.

 

Best Regards

 

Stefano    

Like 2

Like

2 comments

Hello, 

By default, Creatio provides a plugin to be able to upload only in Word format.
https://academy.creatio.com/docs/8.x/no-code-customization/category/pri…;
https://academy.creatio.com/online-courses/article-courses-18

PDF conversion in printables is available after installing this marketplace app https://marketplace.creatio.com/app/asposepdf-connector-creatio. The first 150 conversions are for free, but other conversions require additional payment (prices are available here https://purchase.aspose.cloud/pricing). 

So for test purposes, you can use the free 150 conversions provided in the app. 

We have already registered the idea for our R&D team to implement this functionality in further releases. I will assign your case to this project in order to increase its priority.

Best regards,
Ivan

Besides, this aspose means that your document will go through some 3rd-party service, that is not acceptable by many customers security polices.

So, it is extremely necessary to have this functionality inside Creatio system

Show all comments

i built a process of giving permissions to users and i have that error what does it means ?

Like 0

Like

1 comments

Is the role that is being set using a formula? If so, that formula looks incorrect.

Show all comments

Hi All, 

 

Greetings!

Attaching my source code file.

 

UsrDate -> Date 

UsrStartTime -> Time

CreatedOn -> Date/Time

 

I am getting following error in few records - 

Worklogs Integrations synchronized with errors: {"bd455ee2-8f6e-4aed-bafc-890304110ac3":"SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.","3d4508d8-bf40-48b4-ab65-d836c7c0b3da":"SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM."}

screenshot from the source code is below - 


Screenshot of the record is below - 

 

 

Is it because Start time is NULL ?

If yes how can I handle this in the code so that the records gets synchronized with NULL ?


 

Thanks.

File attachments
Like 0

Like

0 comments
Show all comments

I want to create a process whose trigger is the entry of a user through the SSO interface for initial connection and then I will build the process regarding permissions for each user. Can help with how my process trigger should be? 

 

thanks

Like 0

Like

2 comments

Hello!

 

Unfortunately, it is not possible to trigger the process after successful logging due to how new sessions are added to the system. They are not adding through Entity logic, which is why they will not trigger process triggers.

 

For example, by reading from User Session object, you can find the last authorization to the system (and other information about this session):

 

 

But such a signal will not trigger due to the behavior that I mentioned earlier:

 

Such a solution is possible only by using some custom development.

 

Kyrylo Atamanenko,

Thanks! 

can I ask you In the business process I am creating, do I use an element  (modify data) that updates the user's permissions (Organizational roles). is it possible? If possible, what object is this? 

Show all comments

Hello,

we have succesfully configured identity service and some processess integrating Creatio and other apps through Zapier. The problem is, the integration works in 30-50% of zap runs. In other cases we encounter error like this below:

What we concluded is that Zapier connector connects to our Creatio URL https://creatio.astor.com.pl, where it is redirected to login page and this is somehow the case. W changed the default timeout of login session to unlimited and it didn't changed anything.

 

We asked Creatio support about that and heard that "this connector is not supported by Creatio team so ask DevLabs" but DevLabs says on its Creatio Partner website that I should write a post here, in community. So now I do :) Please help us solve this puzzle, because without Zapier connector we are pushed to reconsider our next moves about Creatio development.

Like 1

Like

1 comments

The Zapier connector for Creatio is somewhat limited and does have some problems. Another option, plus much more reliable route (in my opinion) is to simply use Creatio webhooks. See https://academy.creatio.com/docs/8.x/no-code-customization/base-integrations/webhook-service-integration/overview

Zapier can easily send webhooks to Creatio, plus the use of webhooks is much more flexible and allows for a greater set of objects and fields to be used since the Zapier connector is limited to just a couple of objects (last I checked). 

Since your system looks like it's self-hosted based on the URL, assume you might need to contact support for getting webhooks setup for use.

Ryan

Show all comments

Hello, I have a [Object A] form page where I have an Expanded List (detail) inside it [Object B] created. In [Object B] I need to have multiple records, so now I need to make a relationship between [Object A] and [Object B], but the app doesn't show me a relationship between IDs or anything like that.

I've already tried manually creating a Lookup inside [Object B] pointing to [Object A], but I was wondering if there's a better way to do it?

Like 1

Like

1 comments

Hello,

You need to create one-to-many relations between these objects. To do this, you need to create a lookup column in each object that will refer to another object. After that, you will be able to use filters and relationships to display and customize the necessary lists.
You can't do it using no-code elements because this connection is set up at the object level.

Show all comments