Dear Team,

                    Here I wrote a code in script task in business process I.e.,

                    Select selectqry = new Terrasoft.Core.DB.Select(userConnection)

                   .Column("UsrHrStatusId")

                   .Column("Usrcandresponse")

                   .Column("UsrCandidateNameId")

                   .From("UsrInterview")

                   .Where("UsrIndentLocationId").IsEqual(Column.Parameter(LocationId)) as Select;        

                   I am getting the below error:          

                   How to solve this error?PFA.

Like 0

Like

1 comments

Dear Sekhar,

It is hard to tel exactly what is the issue is caused by. Please double-check the code on line 75 of the schema, which the compilation errors window is indicating to. 

As for the Select class, please see the examples on the bpm'online academy on usage of this class and its construction. Implement the same example in your script task:

https://academy.bpmonline.com/api/SDKNETAPI/7.10.0.en/Terrasoft.Core~Te…

https://academy.bpmonline.com/documents/technic-sdk/7-13/retrieving-inf…

Regards,

Anastasia

Show all comments

Can I have multiple object addition signals within a single process? 

Like 0

Like

1 comments

Dear Kumar,

Yes, you can more than one signal to start a process.For example if record is created or modified. 

Best regards,

Angela

Show all comments

Is it possible to enable Timeline for the Portal Users' Case Page?

Like 0

Like

2 comments

Dear Mitch,

There are no basic tools to add the timeline tab through the section wizard. The same relates to the portal case page. You will need to involve the development process to add the timeline tab to any page in the system but as for portal, there is no much reason to add it since this detail has multiple connections to other entities in the system. Apart from that, the portal users might not have the access rights those entities. 

Could you please let us know what is your business task?

Thank you beforehand.

Dean

Thank you Dean. If it requires custom development, I don't think we would want to implement. We were just checking to see if there was a standard and simple solution. 

We enjoy the timeline tab for internal cases, we like how you can filter by date and by type of activity on the timeline. We thought it would be beneficial for our portal users to have this function if it was an option so they could put time filters on the entities that they have access to.

Thanks for your response, my question has been answered. 

Show all comments

Hi Community,

How can I change the cell color of the grid in a detail just like this example below on how to change the text and background color of section records

https://academy.bpmonline.com/documents/technic-sdk/7-13/how-highlight-…

Like 0

Like

7 comments

Hello Fulgen,

The idea is to connect your custom css styles to the desired detail. 

Here is the article which is describing it: https://academy.bpmonline.com/documents/technic-sdk/7-13/advanced-setti….



I recommend to test your styles in devtools before adding css to the schema. It is the most effective way to make cells look like you want .



Best regards,

Alex

Thank you alex,

What I need also is to put logic on every record to identify which color it will be. The same as overriding the prepareResponseCollectionItem method in section, It will be like the code below, but I need to apply it on detail records. How can I do that with detail? repareResponseCollectionItem: function(item) {

                // Calling the base method.
                this.callParent(arguments);
                item.customStyle = null;
                // Determining the order status.
                var running = item.get("Status");
                //If the status of the order is "In progress", the record style changes.
                if (running.value === OrderConfigurationConstants.Order.OrderStatus.Running) {
                    item.customStyle = {
                        // The text color is white.
                        "color": "white",
                        // The background color is green.
                        "background": "8ecb60"
                    };
                }
            }

 

Fulgen Ninofranco,

Actually, the grid details are using same method, so you should override it in detail schema. For example, I added this method to my detail  

http://prntscr.com/mpw1qy

and now items where quantity = 1 have red text color http://prntscr.com/mpw48t



Best regards,

Alex

Thank you Alex, overriding this method also works for detail grid.

Do you have any idea how to do this, one of our client requirements is to change only the color of status column, not all the columns in a row?

Hello!



We  have tried to apply this in editable detail. But colors are not changed when record is changed and saved.

Colors are applied only when the page is reopened or refreshed

 

What can we do with that?



Thank you!

Vladimir Sokolov,

The only way I could get that to work was a bit hacky. Add a saveDataRow method to override the existing one and do something like this (using Ext to reapply the styles). The code I used looked something like this (this is a shortened version)

saveDataRow: function(row, callback, scope) {
	// this returns something like { "background-color": "#080808" } etc
	var style = this.getRowStyle(row); 
 
	setTimeout(function() {
		Ext.select("div[id$=item-" + row.get(row.primaryColumnName) + "].grid-row-selected").applyStyles(style);
	}, 1000);
 
	this.mixins.ConfigurationGridUtilities.saveDataRow.apply(this, arguments);
},

The problem is that depending on how long for the row to get actually saved could make this not work. I plan on revisiting this to apply the styles once the update is complete (instead of when the save starts) boy replacing the callback arg passed, but sharing this now so maybe it gets you in the right direction.

Ryan

Show all comments

Hi, Is the MS word plugin for MAC available?

Like 0

Like

12 comments

Hello,

Unfortunately as for now there is no plugin for MAC users, but our R&D team is working on the solution and we have a problem for them that is in "Accepted" status, so the plugin should be available in one of nearest versions of the applicaiton. We will inform them about your request so to raise the priority of the problem. Thank you for helping us to make our application better!

Best regards,

Oscar

Great!! Looking forward for the same.

Oscar Dylan,

Hi Oscar,

is there any update on this? 

Dear Oliver,

 

Thank you for being interested in Creatio products and its add-ons. 

Unfortunately, as for now, there is still no developed plug-in for devices with MacOs. We have increased the priority of this functional request and R&D team is in the progress of creating the needed plug-in. It will only be available in future application releases.

 

Best regards,

Roman

Hi, 

Any news on this subject ?

 

Thank you

Hello Mariam,

 

Thank you for your question.

This solution is yet to be developed but as you can see from the previous responses we will add your question to our R&D request in order to expedite it

 

Thank you.

Hello,



Is there any update on this?



Ty

Hello Solem Khan Abdusalam,

This solution is in the process of being developed by the responsible team.

 

Thank you for your question.

Are there any work arounds to help mac users create reports?

Sean Duffy,

 

Unfortunately, this option has not yet been realized. We have added your request to the list of requests for this feature.



We don't know the date yet, but we hope this option will be available soon.

Hello,

Is there any update on this?

Thank you

Chani Karel,



Hello, 

Unfortunately, this option has not yet been realized. We have added your request to the list of requests for this feature.

As we indicated above, we still don't know when it will be implemented. 

 

Show all comments

I changed the column type of 'UsrBenefitYears' from String to Integer, now I get this error when I try to save a detail or section through the wizard.

Any idea where I start looking to resolve this?

 

Like 0

Like

1 comments

Hello Jordan,



Most likely, you faced with the compilation error. You should go to the configuration, choose the "compile all" option and you will get the error. After that you should fix it basing on received error text. 

Also, you may try to update database structure if you did not perform that action after you changed the type of the column.

Please note, that we don't recommend to change the type of columns because it can lead to unexpected errors. The most convenient way is to create new column with new type.



If you will have further difficulties with resolving the issue, please contact the support team via email : support@bpmonline.com

Show all comments

Hi community,

 

How we can filter the section records in client code

Like 0

Like

1 comments

Hello Fulgen,



To perform some filtration in section via client code you should note on "getFilters" method. Actually, you should create a new replacing client module for your section and override this method. 

The example can be found in "ActivitySectionV2" schema in "NUI" package.



Best regards,

Alex

Show all comments

Here is the method that uses updateQuery.

 

 

 

 

 

//

// Here is the response I am getting

 

//

//

Here is the full response I get from the Uri: https://*.bpmonline.com/0/DataService/json/SyncReply/UpdateQuery

 

Like 0

Like

4 comments

Hello Jordan,

Most likely, in your request you are trying to operate with fields that are not presented in object that is modifying. 

I recommend such way to understand what is going on: Modify the object from bpm'online and catch the update request to the "dataservice" (via fiddler or on network tab in devtools). Caught request will be your example and you should compare 2 request: one that you caught and one that is not valid.



Also, you can find additional information in the article:

https://academy.bpmonline.com/documents/technic-sdk/7-13/dataservice-up…



Best regards,

Alex

Try switching the line on 419 from setColumnValue to setParameterValue. I believe setColumnValue takes different argument types.

Ryan

Ryan Farley,

Thank you Ryan, it appears that was the issue! Is setColumnValue for setting the columns alias?

 

Jordan Kincer,

Glad that was it.

Yes, setColumnValue takes two arguments, one for the column alias and one column expression object which defines an expression for the column. The setParameterValue is for setting the value of a column. 

https://academy.bpmonline.com/api/jscoreapi/7.12.0/index.html#!/api/Ter…

Ryan

Show all comments

Hi,

I checked and tested an example using this documentation (https://academy.bpmonline.com/documents/administration/7-13/web-service-integration). Web service example (http://fixer.io) is JSON formatted and there is no issue to configure in Process library.

I have another web service link which required output is in XML format. I'm not sure if its configurable in Process library or it will be only possible through code customization.

 

Below is screenshot of specific area of output from that web service link

Any help will be highly appreciable. 

 

Regards

Like 0

Like

3 comments

Please deploy the application locally and catch the request and the response with fiddler.

https://docs.telerik.com/fiddler/Configure-Fiddler/Tasks/ConfigureDotNE…

This way you'll get more information. 

Hi Eugene,

Thank you for reply.

It means there will be code customization is required?

 

Regards

The code customization is not required. But in order to create an integration with a web service the skill in working with web services is required. 

Show all comments

Hi Community,

 

In Case stage, how can I make a field mandatory before moving to the next stage?

 

Like 0

Like

1 comments

Dear Fulgen,

You can create Business Rule and make this field mandatory there. For example if stage = in progress make field Resolution time required.

Best regards,

Angela

 

Show all comments