Hi,

In Order section there is a OOB lookups field called "Customer". On click we can select either Account or Contact because both list are appearing for selection.

I have a requirement to implement the similar functionality like combining multiple list into one lookup field.

Please help with the configurations.

Like 0

Like

2 comments
Best reply

Hi Janhavi,

 

You need to study how this lookup is implemented on the BaseOrderPageV2 schema and implement the same logic for your column. It's simple - create two lookup columns (UsrContact and UsrAccount that will point to the Contact and Account objects respectfully), add the following attribute to the section edit page schema:

"Client": {
					"caption": {"bindTo": "Resources.Strings.Client"},
					"dataValueType": this.Terrasoft.DataValueType.LOOKUP,
					"multiLookupColumns": ["UsrContact", "UsrAccount"],
					"isRequired": true
				},

Add the localizable string with the "Client" code and then insert this column somewhere on the page (I've been using the contact profile container as a parent):

{
					"operation": "insert",
					"parentName": "Header",
					"propertyName": "items",
					"name": "Client",
					"values": {
						"layout": {"column": 0, "row": 7, "colSpan": 24, "rowSpan": 1, "layoutName": "ProfileContainer"},
						"controlConfig": {
							"enableLeftIcon": true
						}
					}
				}

As a result you will get the needed lookup:

Best regards,

Oscar

Hi Janhavi,

 

You need to study how this lookup is implemented on the BaseOrderPageV2 schema and implement the same logic for your column. It's simple - create two lookup columns (UsrContact and UsrAccount that will point to the Contact and Account objects respectfully), add the following attribute to the section edit page schema:

"Client": {
					"caption": {"bindTo": "Resources.Strings.Client"},
					"dataValueType": this.Terrasoft.DataValueType.LOOKUP,
					"multiLookupColumns": ["UsrContact", "UsrAccount"],
					"isRequired": true
				},

Add the localizable string with the "Client" code and then insert this column somewhere on the page (I've been using the contact profile container as a parent):

{
					"operation": "insert",
					"parentName": "Header",
					"propertyName": "items",
					"name": "Client",
					"values": {
						"layout": {"column": 0, "row": 7, "colSpan": 24, "rowSpan": 1, "layoutName": "ProfileContainer"},
						"controlConfig": {
							"enableLeftIcon": true
						}
					}
				}

As a result you will get the needed lookup:

Best regards,

Oscar

Oscar Dylan,

It worked 

Thanks!

Show all comments

Hello Everyone.

I want to log in a separate file every communication with a Web-Service (request , response time etc).Is there any built-in , or tools from Marketplace to realize this task. Or I should customize the source -code.  

Like 0

Like

4 comments
Best reply

Petrika,

 

Perfect, then additionally you can use the same approach with EntitySchemaQuery, but create record is some section and then use the standard "Export to excel" functionality to get the file with request calls. So each time something is calling the GetErSumSq method you can create a record in some separate section (for example called "Integration call" and add information like DateTime.Now (to get the date and time when the method was called and which value was returned (sum))). Also you can try looking into the HttpContext, HttpContextAccessor and AppConnection to see which information is available there that can be used to additionally log the method call.

 

Best regards,

Oscar

Hi Petrika,

 

This should be done directly in the code of the 3rd party endpoint to which the call is performed (in case we are discussing the 3rd party webservice call from the business process). Logs of the integration call on the Creatio side are accessible only via standard IIS logs. Or you can enable the process tracing to see the status of the call.

 

In case the webservice is stored in the Creatio configuration (standard anonymous or regular webservice) then you can either add a part of inserting a record to some specific table in Creatio (via InsertQuery class for example) and retrieve data from there.

 

Best regards,

Oscar

Thank you very much for your immediate response Oscar. I have got an idea now.  This is what i am trying to do. I have created a button in the Front-End (Get Sum Ws) which calls in the Back-End a basic web service that caculates the sum of the AmountHC in Details Rows.

This is the code in the back-end

namespace test1323.Files.cs
{
    [EntityEventListener(SchemaName = "PetrikaExpenseReport")]
    [ServiceContract]
    [AspNetCompatibilityRequirements(RequirementsMode = AspNetCompatibilityRequirementsMode.Required)]
    class DemoService : BaseService
    {
 
        [OperationContract]
        [WebInvoke(Method = "POST", RequestFormat = WebMessageFormat.Json, BodyStyle = WebMessageBodyStyle.Wrapped,
ResponseFormat = WebMessageFormat.Json)]
 
        public decimal GetErSumSq(string name) 
        {
 
            EntitySchemaQuery entity = new EntitySchemaQuery(UserConnection.EntitySchemaManager, "PetrikaExpenseReport"); 
 
            entity.AddColumn("Id");
            entity.AddColumn("PetrikaTotalAmount");
            entity.AddColumn("PetrikaName");
            entity.PrimaryQueryColumn.IsVisible = true;                                                                   
 
            IEntitySchemaQueryFilterItem parentfilter =
            entity.CreateFilterWithParameters(FilterComparisonType.Equal,"PetrikaName",name);
            entity.Filters.Add(parentfilter);                                                                            
            EntityCollection records = entity.GetEntityCollection(UserConnection);                                      
            Guid parentId = records[0].GetTypedColumnValue<Guid>("Id");
 
           EntitySchemaQuery rows = new EntitySchemaQuery(UserConnection.EntitySchemaManager, 
           "PetrikaExpenseReportLines");
 
            rows.AddColumn("PetrikaAmountHC");
            rows.AddColumn("PetrikaAmountFC");
            rows.AddColumn("Id");
 
            IEntitySchemaQueryFilterItem childfilter =
            rows.CreateFilterWithParameters(FilterComparisonType.Equal, "PetrikaExpenseReport", parentId);
            rows.Filters.Add(childfilter);                                                                            
            EntityCollection lines = rows.GetEntityCollection(UserConnection);
 
            decimal sum = decimal.Zero;
 
            foreach (var r in lines) 
            {
                sum = sum + r.GetTypedColumnValue<decimal>("PetrikaAmountHC");
            }
            records[0].SetColumnValue("PetrikaTotalAmount", sum);                                             
            records[0].Save();
            return sum;
        }
}
}

I want to log in a separate file every communication (request , response time etc) with GetErSumSq.

Petrika,

 

Perfect, then additionally you can use the same approach with EntitySchemaQuery, but create record is some section and then use the standard "Export to excel" functionality to get the file with request calls. So each time something is calling the GetErSumSq method you can create a record in some separate section (for example called "Integration call" and add information like DateTime.Now (to get the date and time when the method was called and which value was returned (sum))). Also you can try looking into the HttpContext, HttpContextAccessor and AppConnection to see which information is available there that can be used to additionally log the method call.

 

Best regards,

Oscar

Oleg Drobina,

Hi , I can't find the whole solution for logging a web service , it seems some comments have been missed or deleted , any ways , how can i log a web service in creatio ? 

Show all comments

Hello,

 

I am facing an issue with this connector, where we cannot use and save the coordinates generated plus it is not functioning easily on the interface.

 

Kindly advise.

Maher.

Like 0

Like

1 comments

Hello to all!



Note that the add-on saves coordinates to virtual columns. This means that your coordinates not being saved is expected behavior. You have to further develop the add-on according to your business goals.

Show all comments

I configured my local Creatio environment to work in file system mode and setup Visual Studio 2019 as described in Creatio documentation.

I Created a package from Creatio UI setting to be compiled in a separate assembly.

I see that in Pck folder the Package folder has been created with a visual studio project file (csproj file) in "Files" package subfolder.

I created a Business Process in Creatio with a script task and I see that the corresponding "cs" file is created in "Autogenerated/Src" package subfolder and it appears on visual studio.

If I update that cs file, changing something in the script task method the changes are not replicate to Creatio.

I used the "Update Packages from file system" action but the "No changes found" popup appears. I tried compiling the project in Visual Studio, using the external tools to run "WorkspaceConsole" as described in Creatio Documentation but nothing goes from file system to Creatio.. actually I see the Creatio script task version to overwrite my file system file. 

Am I doing something wrong? How can I correctly work with my custom package in file system mode and let my changes to be seen from Creatio?

Thanks

Like 0

Like

1 comments

Dear Massimiliano,

 

Thank you for your question!

 

We have checked this information with our developers and they have confirmed that there is no ability of editing a Business Process in a file system mode.

 

Hope this clarifies!

 

Thank you!

 

Danyil

Show all comments

Hi, I've got a page holding two new checkboxes. If the first checkbox (let's say "A") is marked, the second (let's call it "B") has to be unmarked and the other way around. I set the condition in the rules tab, in the page wizard, and each time I clicked on one of the boxes, the second became unavailable as it was projected. However, clicking on the labels of those boxes allowed for marking both of them! I thought I made a mistake and removed the condition.

Having known that both checkboxes are defined in diff array, I declared two schema attributes controlling if they are enabled/disabled. I also glued to the definition of checkboxes event-handlers in this way that each checkbox has its own click event-handler. Event handlers are defined in the section for methods.

Each event handler is responsible for controlling the state of the second checkbox if the first is marked/unmarked. And this time, it also works like a charm, but only when I click on checkboxes. Again when I click on labels of checkboxes, it's possible to mark both checkboxes at the same time. Moreover, it's impossible to handle click-events from these labels.

If it were "normal" js or ts I would handle that easily. Here, I'm running out of ideas. Could you advise me on how to achieve control on those labels, as well (to be precise, I need to have responsive labels to improve user experience)? What I've done wrong so far?

Like 0

Like

1 comments

Dear Duffy,

 

Thank you for submitting your question!

 

Could you please elaborate more on your question and possibly provide some screenshots?

 

Thank you!

 

Regards,

 

Danyil

Show all comments

Hi community

When placing the GivenName, MiddleName, and Surname fields on the contact's placeholder card, they found that these fields were incorrectly parsed from Name.

This appears to be happening in ContactGmsFieldConverter.

In Italy is usually found contact with 2 given name or 2 surname,

for example the name Carlo Alberto dalla Chiesa should be parsed

  • GivenName: Carlo
  • Middle Name: Alberto
  • Surname: dalla Chiesa

while the ContactGmsFieldConvert parses the FullName in

  • GiveName Carlo
  • Middle Name: Alberto dalla
  • Surname: Chiesa

How can I disable it ?

I created a business process that takes the values filled in the GivenName, MiddleName and Surname fields, concatenates them together and assigns it to the Name field, but I got the unexpected result.

Like 0

Like

2 comments

Hello Stefano,

 

Thank you for your question!

 

The solution here is to leave the system setting with code ContactFieldConverter empty (please see the screenshot below):

 

 

After that, you need to log out of the system and log in again. This should help!

 

Kind regards,

Anastasiia

Anastasiia Lazurenko,

Thank you Anastasiia

it works!

Show all comments

Hi Everyone,

i need some help about adding photo on MS Word Report, i have add the Photo from the object but the photo is'nt showed in Word Report, it just only print the file name. Do you have any idea guys? 

Like 2

Like

2 comments

Dear Fransetya,

 

Thank you for your question!

 

You may find this community post useful for your needs:

https://community.creatio.com/questions/adding-product-image

 

Hope this helps!

 

Regards,

 

Danyil

Dear Danyil,

 

Thank you for your help, it's worked

Show all comments

Dear colleagues,

 

I'm getting from a week ago a "Request Timeout" each time I try to bind some data on a demo site.

 

I did it before, but from a week ago, I cannot anymore, some ideas?

 

See it on https://share.vidyard.com/watch/dpoVmZuUhAHbSS6NzaSnuj?

 

It's on Studio Enterprise 7.18, the version list isn't updated

 

Thank you very much

Like 0

Like

2 comments

Hello Julio,

 

The responsible team is working to fix this. The error appears due to the changes in the basic functionality in version 7.18.3. We plan to publish the updated package no later than the end of October.

Alexander Demidov,

Thank you very much @Alexander! :-)

 

Best regards

Show all comments

Hi,

In the Account section there is detail inserted named "Address".

Any record being added in the Address detail is reflected back on the Account section Address field without running any business process.

Can anyone please help with the logic behind the same?

Like 0

Like

3 comments

Hi,

 

Please provide the screenshot of the attribute under the question.

 

Thank you!

 

Best regards,

Oscar

Hi Janhavi,

 

Go to the advanced setting and search for the object AccountAddress.

You should see a schema which in the Base package. Open it  and click on open process button.

 

After that you see this screen. Click on the highlighted item and you should be able to see how the address is synced with main entity (Account) from Account address. 

 

Also check it in the Account object. 

 

regards,

 

Cheng Gong

Oscar Dylan,

Hi Oscar

The address field at the addresses detail as shown in the image 1. is being directly reflected to the account section address field at image 2.

 

Image 1.

 

Image 2.

Show all comments

hi everyone

i have followed the install guide correctly but it is not working

 

the report still being a MSWord and there isn't an error on the console

 

can you help me please?

Like 0

Like

6 comments

Hi Carlos,

 

You need to check the values in the Creatio system settings connected to the Aspose service. Please refer to the screenshot below to make sure that the Aspose setting values match the respective system settings in Creatio. After applying the changes, log out and log back into Creatio to check for updates.

Alexander Demidov,

i have it like you img , But it doesn't work, it still download a MSWORD

Hi Carlos, which Creatio version and product are you currently using? This helps us reproduce the issue.



Aspose's personal page should also display the conversion requests for the relevant time period, from Creatio. Here is the dashboard link: https://dashboard.aspose.cloud/billing/api-usage/. If there are conversion requests, please send us the error details.

Hi Alex Prusakov,

  1. Creatio 7.18
  2. Sales

 At the Aspose's Page i have it :

 

I have tried with empty CORS and with a url

 

but the registry is not receiving any requests

hi Alex Prusakov,

Any idea what's going on?

Hi to all!

I have installed this application and on my site it works fine.

Maybe you have to recreate a printable template?

Is the problem relevant?

Show all comments