Hello,

To accomplish the task you can use the filtration business rules like described in our SDK here. If you implement the same functionality, only the lookup values that are connected to another value chosen first, will be shown. For instance, you choose the state and then are able to select city only from the list of the cities that belong to the state.

Lisa

How can i load the data for drop down list from external web service? Whenever user selected? I mean, i won't retrieve data from database, but external web service.

Hi,

There is good description here how to write such queries. When reading pay attention to "Adding columns to query" section there. You can not only use aggregation in queries but also can use aggregation in filters

Hello!

It is hard to tell, at the moment, what exactly appears to be an issue. At this point I would suggest you to make sure that all necessary Windows components are on as well as the web.config file is set up correctly. Moreover, please make sure that you are using a distinct redis db for your application. Checking the browser's developer console could also be helpful.

In case none of the above instructions help I would recommend you to contact the support team directly in order to investigate the issue thoroughly.

Matt

Dear Jose,

To do such an operation you can simply copy the URL of the document you want to display and insert it like a text into the detail that you've created. When users will click on this link, they will be moved to this document and they will be able to see it.

Thank you for choosing bpm’online!

Oscar Dylan,

Thanks Oscar, but there is no URL, I still need the field to be displayed as a link. I will add some logic to open the document once the link is clicked. 

Hello Jose,

Our application considers all links to be links in text fields. So, if you will insert a text that is the link then our application automatically consider it to be link. If this link can be opened via web-browser or via any other application that can read links than it will be opened via our application. The main point for you now is to create a link to the element in your storage system that can be read. And then you can simply insert it into the text field of our application.

Oscar Dylan,

Your response gives me an idea, but the link would be too long to display on the page. The link will be something like 

https://<server name>/0/ServiceModel/ProcessEngineService.svc/DisplayImage/Execute?ImageID=123456789 

instead of displaying all that on the page I want to display just 123456789 and to go to that URL when the link is clicked.

Thanks,

Jose

Jose Hernandez,

There is a perfect article in our bpmonline academy and it regards adding pop-up hints. You can do one for the text field you need. For example, you have the field with document id and you can add a pop-up hint in one of the ways that are described in the academy and anyone can click on this hint and get additional information that is needed via link that you can put in the hint. Please, pay attention to the "Adding a web-resource link to a tooltip" section in this article because it describes the process of adding the link.

Another way to solve the issue is to add another string field near "document id" field, name it, for example, "Description" and then put the link into this field. You can choose any of these ways and they will both work.

Oscar Dylan,

Thanks Oscar. I tried the article you mentioned, but I could not make it work. The article instructions are for an edit page and I need the changes on a detail. 

I finally was able to make work by making some modifications to the instructions given on https://community.bpmonline.com/questions/show-captions-instead-absolut… (see below) . I'm not sure if there is a more efficient way to get the document id, but the changes worked for me.

Thanks,

Jose

Basically instead of 

addColumnLink: function(item, column) {
                this.callParent(arguments);
            },

I did 

addColumnLink: function(item, column) {

                if (column.columnPath === "UsrDocumentCdrId") {

                    var columnPath = column.columnPath;

                    var onColumnLinkClickName = "on" + columnPath + "LinkClick";

                    var value =  this.get("Resources.Strings.OpenCdrDocumentCaption");                    

                    if (Ext.isEmpty(item[onColumnLinkClickName])) {

                        item[onColumnLinkClickName] = function() {

                            var config = {

                                title: value,

                                caption: value,

                                target: "_blank"

                            };

                            return config;

                        };

                    }

                }

                this.callParent(arguments);

            }

and instead of 

linkClicked: function(recordId, columnName) {
                if (columnName === "UsrCaption") {
                    var path = this.get("UsrURL"); //"https://www.google.com";
                    window.open(path);
                }
                this.callParent(arguments);
            }

I did

            linkClicked: function(recordId, columnName) {

                if (columnName === "UsrDocumentCdrId") {

                    var esq = this.Ext.create("Terrasoft.EntitySchemaQuery", {

                        rootSchemaName: "UsrCfrDocuments"

                    });

                    esq.addColumn("UsrDocumentCdrId", "UsrDocumentCdrId");

                    esq.getEntity(recordId, function(result) {

                        if (!result.success) {

                            this.showInformationDialog("Resources.Strings.UnableToGetDocumentIdLink");

                            return;

                        }

                        var documentCdrId = result.entity.get("UsrDocumentCdrId");

                        var path = this.getCdrDocumentUrl(documentCdrId);

                        window.open(path);

                    }, this);

                    return false;

                }

                this.callParent(arguments);

            },

            getCdrDocumentUrl: function(documentId) {

                return " https://<server name>/0/ServiceModel/ProcessEngineService.svc/DisplayImage/Execute?ImageID=" + documentId;

            }

Hello,

We do not recommend to use the business data in the preproduction application. You may use it for the functionality development, though user roles, access rights, system users etc should be created in the production environment directly.

If there is no possibility to re-input this information manually you can use custom SQL scripts in package in order to transfer such information. Below you can find tables that store information about access rights:

1. Sys[SectionName]Rights

2. SysEntitySchemaColumnRight

3. SysEntitySchemaOperationRight

Lisa

Hello,

Thank you for your answer. 

Hello,

Thank you for your answer.

Lisa Brown writes:

Hello,

We do not recommend to use the business data in the preproduction application. You may use it for the functionality development, though user roles, access rights, system users etc should be created in the production environment directly.

If there is no possibility to re-input this information manually you can use custom SQL scripts in package in order to transfer such information. Below you can find tables that store information about access rights:

1. Sys[SectionName]Rights

2. SysEntitySchemaColumnRight

3. SysEntitySchemaOperationRight

Lisa

Hello,

I know this is a very old discussion, but did anyone actually succeed in writing such SQL scripts?

I could really need some help here...

Thanks,

Robert

Robert Pordes,

Hello,

In case you need to transfer access rights records between two applications you need to firstly merge existing records in all the Sys[SectionSchema]Right (meaning SysConactRight, SysAccountRight and so on) tables for the dev app and prod app and exclude all the records that exist both in dev and prod. Once done you need to create an

INSERT INTO SysContactRight (Id, RecordId, SysAdminUnitId,Operation,RightLevel,Position) VALUES (...)

query that could insert records to prod that exist in dev, but don't exist in prod. This INSERT query should be created for all Sys[SectionSchema]Right tables and bound to the package via SQL script tab.

And once done these queries will be bound to the package and once the package is installed to another app those scripts will be automatically executed and access rights will be inserted to the system.

This will be a complicated task and instead we suggest using the Marketpace app wich can ease access rights setup: https://marketplace.creatio.com/app/access-rights-setup-wizard-creatio

Best regards,

Oscar

Robert Pordes,

it was discussed here - 

https://community.creatio.com/questions/deployment-permissions

It can be done only for transferring access rights for existing records. 

Dear Reshma,

We have a separate part of the Academy dedicated to the development on our platform - https://academy.bpmonline.com/documents/technic-sdk/7-12/bpmonline-development-guide. You will be able to find a lot of useful manuals and examples there. 

Most of the described tasks can be achieved without the development though. You can use our out-of-the-box system to cover the cases of storing the user data, saving and approving documents, creating lists etc. Thus, you may also turn to the manuals from Academy for the functionality description. 

Lisa

Dear Tomek,

Please refer to these two related articles. They can help you to understand on how to access the process parameter from the script task: 

https://community.bpmonline.com/questions/access-business-process-parameter-script-task

https://community.bpmonline.com/questions/use-collection-parameter-script-task

Best regards,

Lily

Dear Ezequiel,

Please change the fields type in Excel file to text format:

Then please type in all in lower case true/false:



Then try to import the data. It should work in this way as expected. Our R&D team is working on improving this functionality.

Best regards,

Lily

 

Dear Ezequiel,

Check the manual from our SDK that provide the examples of setting up the conditions for the business rules - https://academy.bpmonline.com/documents/technic-sdk/7-12/bindparameter-rule-how-make-field-required-based-specific-condition

Lisa

Dear Lisa,

Thanks you for your response.

In this case, the rule type is "FILTRATION". I don't have the possibility of set a conditions array for decide if the rule apply or not. Is that so?

How can I do it?

King Regards,

Ezequiel

Dear Ezequiel,

There is no option to configure if the rule is applied based on the condition. You can add the JS-code to the page schema that will accomplish the same task as the business rule. You can find the example of such code in the SDK and then customize it by adding the current user role check. 

Lisa

Dear Lisa,

Thanks you for your response.

Finally, add the attribute wiht fitration to attributes property of view modelm and there i put the logic!

Regards,

Ezequiel

Dear Ezequiel,

There are two separate buttons connected to the feed in the communication panel - the upper one is for the Feed and the lower one is for the Feed notifications. The user can see the posts made in the record he subscribed to when he clicks on the upper ('Feed') button. This one doesn't support the indicators at all, meaning there is no option for the number in a circle to appear near it.

There is a workaround you can use to receive a notification in described scenario, though. The messages themselves are stored in 'Message/Comment' object, the notifications in 'Reminding', the information about the subscriptions in 'SocialSubscription'. You need to make sure that every time the new record is added to 'Message/Comment', the data is added to 'Reminding' using the selection by 'SocialSubscription'.

Lisa

Dear Lisa!

Thanks for your response.

I made a business process to resolve what you told me. At this moment I am trying to notify a particular user about the publication in a case. But i can not put a link to the case in the notification. The link appears in the description but does not go anywhere. How could i do this?

I show below the configuration of the notification

I hope you can help me!

Regards,

Ezequiel

Dear Ezequiel,

You can use the functionality of out-of-the-box notifications (like the one when the user was assigned to the case or tagged in the feed) as an example for your development as the desired logic is already implemented there.

Lisa