Hello.
Thank you for your question.

Please provide more details on the issue you've faced. Where exactly the issue occurs (custom webservice, business process etc.), which database type is used in your local installation (MS SQL, PostgreSQL or Oracle), which value is stored in the database record in the specific column of DateTime type, which is the column settings in the database (which type is used?), what is the error message in the Error.log?

It is very unclear how you are getting that exception but this article might be handy.

I am eager to receive your answer! 

Good day, 

You can use business processes for this purpose.

You can receive a signal on change of the status of the Approval

after which you can read the details of the said approval

and modify the approver to correspond to the current user 
and the date to correspond to the current date as follows:


 

Hello,

To ensure that the process does not stop, you can use parallel branching and add a “Wait for Signal” element in the business process. In this element, you can insert your record ID and configure a signal for changes in the record. After clicking the button, the record is saved, and the signal will be triggered. You can then place a sub-process or continue the algorithm in the existing business process if you need to use the new data for further actions.

Additionally, you can merge the parallel branches into one using the signal trigger. You can plan ahead what signal this will be and configure it so that the execution logic is always correct. I have also provided an example of a business process design that might be useful to you and serve as a foundation for creating the appropriate business logic you need.



Thank you for reaching out!

Hello Manoj,
Thank you for your question.

There is an article available on the Academy that covers this topic with an example.

Regarding following question: "Is there any alternative available for the same". 

It depends on what you mean here. You can call a web service from different parts of an application. For example, you can make a business process that makes a call to a web service (link).

Hope this helps, let me know if you have any question left.

Yevhenii Grytsiuk,

Hi Yevhenii,

Apologies if my previous message was unclear. I want to add a button to each row in the native list, specifically as a column, and trigger a web service call when this button is clicked to sync data from another system.


 

For example, I need to add a sync icon as a column in the Project List. When the sync button for Project 1 is clicked, it should call the web service to sync data related to Project 1 from another system. Similarly, clicking the sync button for Project 2 should sync data related to Project 2, and so on.
 

I hope this clarifies my request. Thank you!

Manoj Patil,

You can add the following to the diff of the section: 

{
	"operation": "insert",
	"name": "DataGridActiveRowSyncButton",
	"parentName": "DataGrid",
	"propertyName": "activeRowActions",
	"values": {
		"className": "Terrasoft.Button",
		"style": "green",
		"tag": "sync",
		"caption": "Sync"
	}
}

This will add the button. Then for handling the click, add this to the methods:

onActiveRowAction: function(buttonTag, primaryColumnValue) {
	this.callParent(arguments);
 
	if (buttonTag === "sync") {
		// do your stuff here
		// primaryColumnValue is the row's Id value
 
		// you can get other values from the row using
		var row = this.getActiveRow()
		var val = row.get("UsrSomeColumn");
	}
}

Ryan

Ryan Farley,

Hi Ryan,
 

Thank you for the details. 

This section is created via Section Wizard and it correctly appears in Application Hub. However, I do not a find a place where this code needs to be added. Please guide me on the same as I am unsure if I am missing anything here.

The Section wizard creates two client schema files. One ending in "Page" and one ending in "Schema". The one ending in "Schema" is the one you want to add this code to. To see these files you need to look at the contents of the package containing your customizations, either by opening Advanced Settings from your application in App Hub or using the Advanced Settings link in the System designer.

Ryan

Ryan Farley,

I am unable to locate the System Designer icon on the Project List Page. See below screengrab.

I went to Advanced Settings and didn't find the schema files ending with "Page" and others ending with "Schema". See below screengrab.

Therefore, I navigated to Application Hub, Navigation Sections, and Selected Project which opened Projects: Section. 

In the Section Pages, I selected Edit Page which opened the Section Wizard screen with Tabs Pages, Business Rules, and Source Code at the top of the screen. 

I clicked on the Source Code tab and pasted the code at this place but it didn't reflect the new button in the list. 

I am unsure why the System Designer icon does not appear on the Project List screen. (Could it be a Creatio Version Issue? I am using Version 8.1.3.6734)
Why schema files ending with "Page" and "Schema" are not available in the Advanced Settings. (Could it be a Creatio Version Issue? I am using Version 8.1.3.6734) 
I assume I am placing the code on the Project Detail page and not on the Project List Page.

Hello Ajay,

Thank you for your question.

I suggest you to change your approach. You can override a default crt.HandleViewModelInitRequest  handler that is called before a page is fully rendered. There you might want to put your API call and depending on the result open a specific page. 

Here is a code snippet on how this might look
In this case you also need to add @creatio-devkit/common dependency to schema dependencies

It is not recommended to dynamically modify entire schema configuration. Thus a better solution in your case could be binding your API call response to page element properties such as "visible" or "enabled".

Some helpful articles on the Academy: 
1. Generic handlers.
2. Open a Freedom UI page from a handler

Hope this helps and let me know if you have any questions left!
 

If all this is doing is reading data, instead of using an ESQ, use the Select class or direct database query. Neither option will have the 20,000 record limit.

Be aware that both of these options are reading direct from the database tables, bypassing any record access security, etc.

Note, if you want to stick with using ESQ you can page back the results using RowCount and SkipRowCount to read pages less than 20K at a time.

Ryan

Ryan Farley,

Thank you for your response, I have to first read data and then I need to push this data to external Database. So more specifically in this case I am reading data from Project table in creatio and then I have to upsert data to Project table in external Database (outside creatio)  by iterating on the records I will read. 

Do you think Select class or direct database query this will work in this case? 

Thanks.

AS,

Yes either one should work fine, and will likely run faster than using ESQ since it's not adding all the other logic in the Creatio entity model and just reading the data directly from the database.

Ryan

Hello!

You can set up several lists and connect buttons (with processes) to them.
These articles can be useful to resolve the task:
https://academy.creatio.com/docs/8.x/no-code-customization/customization-tools/ui-and-business-logic-customization/element-setup-examples/components/set-up-button-components
https://academy.creatio.com/docs/8.x/no-code-customization/customization-tools/ui-and-business-logic-customization/element-setup-examples/components/set-up-list-components
https://academy.creatio.com/docs/8.x/no-code-customization/customizatio…

Hi,
 

You can implement logic similar to the DurationInMinutes and DurationInMinutesAndHours fields in the Activity object (CrtCoreBase).
 

You can check the logic for calculating these columns and build similar event-driven logic (an object-level process).
 

Method: CalculateDurationOnSaving();
 

Alternatively, you can build a business process that will trigger when the Start Time or End Time fields are changed and calculate the required Duration field using a formula.

https://academy.creatio.com/docs/8.x/no-code-customization/bpm-tools/business-process-setup/process-formulas

Best regards,
Pavlo!

Hello Nicolas,
Thank you for you question.

If i understood you correctly you successfully binded field value change to attribute in your record page but you could not achieve same result in the section page. It might be because those two pages have different fields (e.g in record page there are fields related to that specific record and in section page there is information related to the list of those records). 

In section page i created a method that checks status of selected row. If the status of an order is completed than a button becomes hidden.

Here is how i accomplished that: 

Alternatively you can directly subscribe to changes in ActiveRow in your section page by overriding init method as follows:

Hope this helps and let me know if you have any other question left!

 

Dear Sergey,

Could you please provide us with an example and more details of this issue?

Thank you in advance!