Dear Venkata,

It seems the lookup object used for field "Current Industry" was deleted. So now the field doesn't have any object to get the records from.

Please, open the field settings in section wizard and check if the object is selected. Select/create new object and try to save.

In case the issue still occurs feel free to submit a case to support@bpmonline.com.

With best regards,

Oliver Wingston

Dear Ezequiel,

The task was already discussed in another Community post here - https://community.bpmonline.com/questions/call-business-process-script-task. Feel free to check the solution provided there. 

Lisa

Please change return true; to return false; in the main script of the user task .

http://prntscr.com/juzmpl

Hello,

Thank you for your answer. It works.

However, I don't know how to make it disappear after being shown. In fact, is it possible to add a button to close it and terminate my process?

Actually, when I click on the notification, an error appear in the console. I attached the error picture.

Thank you.

if you don't specify anything that should happen after clicking on the notification what do you expect the system to show instead of the error?

The academy article just explains how to show the reminding. Everything else is expected to be written on c# and JavaSctipt by you. 

Please investigate how out-of-the-box user tasks works. It should help.

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

Link is invalid.

Hello!

I believe the documentation that was meant is the following:
https://academy.creatio.com/docs/8.x/dev/development-on-creatio-platform/back-end-development/data-operations-back-end/orm/references/entityschemaquery

https://academy.creatio.com/docs/8.x/dev/development-on-creatio-platfor…

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