Hello tomasz,



It can be achieved via triggering some method for filtering when the field is changing. You will need to create new attribute with dependencies properties where column and method should be specified. For example:

 

"OnColumnNameChange":{
    "dependencies":[
        {
         "columns":["columnName"],
         "methodName":"methodThatTriggersWhenColumnNameChanges"
         }]
}

Also please note on these articles: 

https://community.bpmonline.com/questions/filter-detail

https://community.bpmonline.com/articles/filtering-details-several-fiel…

Dear Glenn,

You can use Fiddler to catch requests that are being sent to and from the application and use it for debbuging. But you will be able to do it starting from 7.13.2 version of the applciaiton. Until that you can either create the functionality and then use it after the upgrade or create the request on c# via a script task element.

Best regards,

Oscar

Oscar Dylan,

Both bpm'online and the service are in cloud, so I cannot use fiddler.  What is the target release for 7.13.2?

Dear Glenn,

You will be able to use fiddler to catch requests even if the instance is located on-cloud. As for 7.13.2 version - please take a look at release notes here https://academy.bpmonline.com/documents/bpmonline-release-notes-7-13-2.

Best regards,

Oscar

I get this notification: Import complete. 1 of 1 records imported from the source file "AK_Relationships.xlsx".

Hello

The Relationship table has following columns: http://prntscr.com/mkwsvu

In order to import relations you need to populate the RelationTypeId, ReverseRelationTypeId, Active, AccountAId(ContactAId) and AccountBId(ContactBId) columns. Please note, that you need to fill in the columns with the precise names in order for these relations to be connected to the existing records. Else, the duplicates might be created.

Best regards,

Matt

Dear Fulgen,

You can do that in the following way:

1) Open the replacing object that is usually in the Custom package (in the configuration).

2) Open all settings of the object: http://prntscr.com/ioprlo

3) Then you can set the usage mode for the column is None.

Please note that if you set such usage mode for the column, you won't be able to filter the records by it but also you won't be able to add this field to be displayed in the tile or list view in the section. 

Best regards, 

Dennis

Dear Aaykay,

The system may request you to choose the object where you want to add the new detail. For instance, if you choose the Accounts from the list, the detail will be referring to the Accounts object http://prntscr.com/mjc55 Here is the article for more details 

https://academy.bpmonline.com/documents/technic-sdk/7-13/creating-detai…

If you need to add a new object here is another resource that will help you out:

https://academy.bpmonline.com/documents/technic-sdk/7-13/creating-entit…

Best regards,

Dean

Hello, 

You can see all tables with it's content in the Lookup section in system designer. For that you would need to create a lookup connected to the needed object. You can't use queries in the lookup, though. for this purposes The marketplace app SQL Executor can be used. https://marketplace.bpmonline.com/app/sql-executor-bpmonline

Best regards, 

Dennis

Hello,

Please submit a case to support@bpmonline.com. We will be glad to help you!

Best regards,

Angela

Not sure what's the point of having a "community" is then if you're gonna give solutions via emails.

But will do that.

Got it sorted by removing the columns from the Excel that would not match with the Columns in tables within Bpm Online and it worked fine.

Not sure how that worked out but was able to upload the contacts.

Angela Reyes writes:

Hello ayman,



To achieve it you should set instalation type = Update existing and check column [Forced update]

[Update existing] - when updating a package, only those object columns that are marked with [Required for update ([Forced update]) in the [Columns] group will be updated. This type of installation is used, for example, when delivering hotfix updates!



Best regards,

Alex

Alex_Tim,

I still get the warning when saving the data binding with [Update existing] installation method chosen, should this not be the case? I have forced update set on the system setting I'm updating as well. Presumably this warning can be ignored, since the data is bound in another (OOTB) package which won't be installed with my package, but it does seem odd that the warning is still shown.

Hello Harvey, 

Could you please specify why do you need to bind the data that is already in one of the base packages?

Thank you in advance for your reply!

Olga. 

Hi Olga, in this case it's because I'm binding the default maximum repetitions of Business Processes system setting to the package to a higher number, but in general just to be able to bind any pre-existing System Setting to the package.

Harvey Adcock,

Thank you for the clarification! This warning has no impact on data binding. 

Best regards,

Olga. 

Hello Sekhar,



If we speaking about converting base64 string to a file you can check the possible realisation of this case here: https://snipplr.com/view/6034/base64-encode-or-decode-a-file/



Also, when the task is to upload file to bpmonline, OData service is used for that purposes, here is an example:  https://community.bpmonline.com/questions/how-upload-attachments-odata



If you have any questions, please specify more precisely what exactly you are trying to achieve.



Best regards,

Alex

Thanks Alex.

You can set process parameter in the script:

Set("PipelineId", pipelineId);

That sets the parameter for the process that contains the script task, but not for a subprocess that is further down the line from the script task (see the first link I included), I thought? Or do processes and subprocesses share parameters?

Dear Jonas,

You can use this coder to pass the value:

UserConnection userConnection = Get<UserConnection>("UserConnection");

IProcessEngine processEngine = userConnection.ProcessEngine;

IProcessExecutor processExecutor = processEngine.ProcessExecutor;

var nameValues = new Dictionary<string, string>();

int parameter1Value = 100;

nameValues["parameter1"] = parameter1Value.ToString();

processExecutor.Execute("UsrProcessCustom", nameValues);

return true;

Best regards,

Dean

Thank you. I will start testing this today. 

Now I need to know how to get data back from that process. Is that possible?

Dear Jonas,

You can try to add another element in your subprocess and use the same script to pass the values back to the parent process. 

Dean