Dear Toan, 



 

1) Instead of stored procedure you can can create a DB View and use it to display data in a grid as if it were a regular schema.

In this case every time grid is loaded, select to DB view will be performed.

Find details on how to create DB view in step 1 and step 2 in article https://academy.creatio.com/documents/technic-sdk/7-16/localizing-views

2) If you still need to use Stored procedure, you can create a regular detail grid and use store procedure to insert/update data to the table.

Use StoredProcedure class from Terrasoft.Core.DB namespace to execute stored procedure from a business process.

 

public void RunProcedire(string storedProcedureName) 
{
    var storedProcedure = new StoredProcedure(_userConnection, storedProcedureName);
    using (DBExecutor dbExecutor = _userConnection.EnsureDBConnection())
    {
        dbExecutor.CommandTimeout = 300;
        storedProcedure.Execute(dbExecutor);
    }
}

Kind regards,

Roman

Roman Brown,

Thanks for replying my question, but I need show the result of store procedure into a grid (like section or detail) instead of insert/update in business process. 

About use DB view, please give me more details because I don't know what you mentioned "In this case every time grid is loaded, select to DB view will be performed.". Can I create something like section to show DB view data and can filter?

Toan Mai

Hello Julia,

Thank you for your post! Could you please re-send screenshots? The attached pictures are corrupted and cannot be opened.

Thank you in advance!
Olga.

Olga Avis,

Done. Thanks!

Hello Julia,

The Requestor needs to click [Actions] and select [Send for approval] (please refer to the screenshot below) to run the "Vacation leave request" process.

Hi Andre,

I activated the process by clicking the "Send for approval" button from Actions, but then there was no result: for some seconds there was a preloader on a screen, but then nothing and in process log there were no records associated with this process, that meant that process wasn't started at all. Unfortunatelly I wasn't able to find out the reason. 

Andre Kosolapenko,

Hi Andre,

I activated the process by clicking the "Send for approval" button from Actions, but then there was no result: for some seconds there was a preloader on a screen, but then nothing and in process log there were no records associated with this process, that meant that process wasn't started at all. Unfortunatelly I wasn't able to find out the reason. 

Dear Akshit, 



Starting from 7.16.0 you can stream data with OData v4.

See details here:

https://academy.creatio.com/documents/technic-sdk/7-16/working-stream-data



Kind regards,

Roman

Hi Roman ,

Does It means that I need to write a webservice(OData) on creatio's end and use that to read files and upload it into creatio database only.

I have seen this community article : 

https://community.creatio.com/questions/how-upload-attachments-odata

This certainly becomes a very urgent requirement now. Please respond

Many thanks!

Dear Adharsh, 



Please add the following packages to the new package dependencies for the service product: 

ServiceEnterpriseSoftkey

ServiceEnterpriseDefSettings

Release

ServiceEnterpriseMobile



Kind regards,

Roman

Hi Roman,

Thanks for the reply. We are using the Customer Center version of the sales module and not the enterprise version. Can you please help with the list of dependency packages that we should use for this?

From the list we can see the below,

CustomerCenterSoftkey

CustomerCenterDefSettings

Is it fine for us to add only these two packages in dependency?

Thanks.

Roman Brown,

Hi Roman, Request your input on Halludeen's question above

M Shrikanth,

You should use the packages that contain functionality that will be used. For example, if you want to use Customer Center functionality you add 

CustomerCenterSoftkey package.

Best regards,

Angela

Angela Reyes,

Hi Angela. We spoke to Customer support and got our answers. Thank you. 

In my own experience: I recommend only adding ProductCore.

I allways have to regret it when I do more changes to this

Hello Nicolas,

At the moment the scale settings can be configured and saved only for all users and there is no out-of-the-box logic that allows you customizing the gauge dashboard in the way you've described. As a solution of your case you can try to create your own custom widget via additional development (this Academy article will be useful: https://academy.creatio.com/documents/technic-sdk/7-16/adding-custom-dashboard-widget). And in the following article you can find information about how to configure the “Gauge” dashboard in general: https://academy.creatio.com/documents/base/7-16/gauge-dashboard-tile

Also, you can check marketplace application which are related to dashboards and possibly you will be able to find some tools that will resolve your business task.

For example, if you need using formulas in a dashboard - this marketplace app provides this functionality: https://marketplace.creatio.com/app/calculated-charts-creatio

Advanced dashboard designer will help to design your dashboards in easier way: https://marketplace.creatio.com/app/advanced-dashboard-designer

Best regards,

Roman

Dear Ernesto,

Currently PDF converter is not available for all relatively new instances. If your websites databases are quite old and you already have Aspose package in advanced settings - it is possible to use PDF. If that is the case - it is necessary to update the package. In this respect - please approach the support team to update the Aspose pacakge to make the PDF converter working again.

Regards,

Dean

Hello,

Yes, Creatio moves to daylight saving time automatically. There is no need to perform any specific adjustments. It is enough for a user to have the non-daylight time zone selected, like EDT, and the time will changed to daylight saving when necessary.

As for changing the time zones lookup, it is not possible. It contains standard Windows time zones lookup that also have connection to the web server time.

Regards,

Dean

dean parrett,

Hi Dean Parrett. You mean that if a user chooses EST, It will automatically account for daylight saving?

There is no EDT timezone available in the default lookup.

dean parrett,

Also, can this be added to the Creatio documentation? Neither is it indicated anywhere in the documentation nor is it available in the community. Thanks in advance! 

dean parrett,

Hi Dean. A follow up question - 



Lets say that day light saving kicks in and GMT-4.00 changes to GMT-5.00. It was mentioned in the community link that Creatio handles this automatically.

1. Does Creatio store GMT-4.00 or GMT-5.00 in the DB? What will be shown to the user inside user profile on the GUI as the time zone offset? 
2. From where can I get the value of GMT-5.00? Will it change in the 'Offset' column in the Time zone table??

Appreciate your response.

Hello M Shrikanth, 



1. Yes, you can use it. For more details on this please Check the official Microsoft docs.

For example, the following article;

https://docs.microsoft.com/en-us/dotnet/api/system.servicemodel.web.web…



2. No, unfortunately there is no way to bypass adding of the mentioned prefix. 



Kind regards, 

Roman



 

Roman Brown,

Hi Roman. Thank you for the response. 



How does one enable PUT and PATCH methods on a custom configuration service endpoint?? Are there any specific settings or attributes to be added? 

Dear,

The issue happened due to the incorrect using of the file development mode for working with the server side source code.

Please find the information about how to do it propery in the article by the link below:

https://academy.creatio.com/documents/technic-sdk/7-16/overview

Best regards,

Norton

Dear Nicolas,

This error message indicates that Creatio application could not connect fo mail server using the connection parameters specified in mail server settings. It says that Creatio sends a connection request and the mail server closes the connection for some reason. To check the source of the issue network settings and logs on the mail server side should be checked on the same time period as those error messages. 

Best regards,

Angela

We have the same errors currently