7.11 | Community Creatio

11:19 Jun 08, 2018

Hi,

You can implement the application on-site and have the access to the dll's. Alternatively, you can write an email to support@bpmonline.com and the libraries will be sent to your email address.

The first option is preferable, though, as having the application on-site will be useful for your development further as well.

Lisa

Timothy Lindsay

16:30 Jun 08, 2018

Thanks!

Show all comments

Question

#aggregation functions

ESQ

ESQ Aggregation functions

Creating new website to store documents after approval from HR

18:58 Jun 07, 2018

Hi Community!

How are you?

How could I put together a query similar to that with ESQ on the server side? Can I use aggregation functions?

SELECT Max(l.CreatedOn), l.SmrRecordId

FROM SmrLoggingRecord l

   JOIN [dbo].[Case] c

       ON l.SmrRecordId = c.Id

       AND c.UpriEstadoCasoId = '78346E42-83AD-4790-B901-DB750A1D157E'

WHERE l.SmrColumnCaption = 'Estado del Caso'

GROUP BY SmrRecordId

King Regards!

Ezequiel

1 comments

Peter Vdovukhin

12:48 Jun 08, 2018

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

Show all comments

Question

Reshma

18:58 May 29, 2018

I am new to bpm online. I need to create an application to save user data, save documents and store the documents after approval workflow by HR. Where can I start the development? What is the IDE for creating this? I have gone through https://academy.bpmonline.com/. But not able to find proper information for a starting developer. Where can I create a list? Where do I need to write code for saving data to list? Can anyone please help me?

1 comments

09:00 Jun 01, 2018

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

Show all comments

Question

data import

Import with assistant, data of the boolean type (check)

16:04 May 24, 2018

Hi Community!

In this Opportunity, i want know how import Boolean data with "Import Wizard".

That is, in the excel I have some fields of the Boolean type to map in the corresponding fields of some entity in this case, the entity is "Case"

I tried putting in Excel, the values 0,1, T, F, Yes, No, for the correspondence with true / false but none works, the field in the application does not map

I attach images below

I hope your can help me!

King Regards,

Ezequiel

1 comments

Lily Johnson

12:22 May 25, 2018

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

Show all comments

Question

MS Word Plugin word 2013 64 bits

sales

ULISSES DE PAULA

18:59 May 21, 2018

I've installed the plugin for MS Word 2013 64 bits ok, but after I selected the printable form the table with the fields doesn't appear to select the fields.

Any help?

Thanks

5 comments

Philip Pol

03:49 May 22, 2018

Hi Ulisses!

Did you defined what printable fields you'd want to have on your printable in the Lookup named "Printable"

https://academy.bpmonline.com/documents/studio/7-12/setting-ms-word-printable-template

Lily Johnson

10:52 May 22, 2018

Hello,

Philip is right. This can be connected to the fact that the columns for the template are not set in the Printables lookup yet. Before setting up the template in Word, please follow these instructions: https://academy.bpmonline.com/documents/studio/7-12/registering-ms-word-printable

After that please set up a template in Word as it described here: https://academy.bpmonline.com/documents/studio/7-12/setting-ms-word-printable-template

If it is not the case, please describe your issue in more detail along with the screenshots.

Best regards,

Lily

ULISSES DE PAULA

15:53 May 22, 2018

Philip Wierciszewski,

Thank you for you help, Philip.

I had already done it.

Regards

Ulisses

ULISSES DE PAULA

16:02 May 22, 2018

Lily Johnson,

Hi Lily,

Thanks for your help.

The problem was related with the "MS Word printables setup wizard" from Marketplace.

After install it the problem occurs.

I tried to manage reports with a new demo version and before install the "MS Word printables setup wizard" every thing worked perfectly, but after install it, the same problem happened.

I think it could be useful to other, in the same situation.

Regards

Ulisses

Lily Johnson

16:58 May 22, 2018

Hello,

If you installed the app or add-on from the marketplace, please check the support email. In case the developer is set as bpm'online, please send an email to bpmonlinelabs@bpmonline.com

Best regards,

Lily

Show all comments

Question

Apply rule based on condition

23:06 May 17, 2018

Hi community!

How are you?

How can I apply a rule only if a condition is met? In this case, if the logged-in user has the CASACENTRAL organizational role, the rule does not apply, otherwise the rule will apply

"UpriNino": {
      FiltrarRegionNinoPorRegionJI: {
            ruleType: BusinessRuleModule.enums.RuleType.FILTRATION,
            //autocomplete: true,
            autoClean: true,
            baseAttributePatch: "UpriRegion",
            comparisonType: Terrasoft.ComparisonType.EQUAL,
            type: BusinessRuleModule.enums.ValueType.ATTRIBUTE,
            attribute: "UpriEstRegion"
      }
 },

if the user has the CASACENTRAL role, there should not be any filter in the UpriNino field

I hope your can help me!

King Regards

Ezequiel!

4 comments

07:08 May 18, 2018

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

16:09 May 18, 2018

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

01:50 May 19, 2018

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

16:07 May 24, 2018

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

Show all comments

Question

notification

Notify about new news in case

22:28 May 17, 2018

Hi community!

How are you?

I entered the application with "ipedraza" user, I created a case and then I published a news item in it as the image shows

Then,I enter with the user "pjarab", who has access to the case and who follows the news of the case. If I click on the News button in the communication panel, I see what was published in the case,

but I would like an alert or notification to be sent to me to notify me beforehand, only the news but no notification appears. How could I do it?

King Regards,

Ezequiel

3 comments

07:29 May 18, 2018

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

19:13 May 24, 2018

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

13:46 May 25, 2018

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

Show all comments

Question

changes tracking

Add "Change log for bpm'online" for register changes in Case

21:45 May 17, 2018

Hi community!

How are you?

I just installed the module "change log" of marketplace, configure the permissions for "System administrators" to the operations,

configure the fields of the section of which I want to register the changes,

but I do not know how to see the tab "History of Changes" on the page of Cases. Surely I'm missing some step. Could you help me?

King Regards,

Ezequiel

2 comments

00:33 May 18, 2018

Hi Community!

It was language problem. Configuring the user's language in English and entering again works. Any suggestions on what to modify so that it works in another language? In this case Spanish.

King Regards,

Ezequiel

18:13 May 25, 2018

Dear Ezequiel,

The procedure of localizing the applications differ depending on whether you are going to move the customization to another application or not. Please note that the necessary condition to be able to translate the application is activating the language in the system beforehand.

If you are going to use the translation on the specific instance only, you need to open the Translations section and translate the necessary lines one-by-one. You can find the necessary lines by the date the package was installed. Once all the necessary lines are translated, you need to apply the translation.

Lisa

Show all comments

Question

BPM'Online upgrade from 7.11.3 to 7.12.0

service

Alin Sampalean

14:44 May 16, 2018

I'm trying to upgrade from 7.11.3 to 7.12.0 and when running BpmonlineUpdater.exe I have the following errors in the console:

Error: Could not load file or assembly 'SharpSvn, Version=1.9007.3987.251, Culture=neutral, PublicKeyToken=d729672594885a28' or one of its dependencies. Operation is not supported. (Exception from HRESULT: 0x80131515)

Error: Could not load file or assembly 'file:///D:\BPM 7.12 PS\CRM\Terrasoft.WebApp\DesktopBin\WorkspaceConsole\x64\SharpSvn.dll' or one of its dependencies. Operation is not supported. (Exception from HRESULT: 0x80131515)

Upgrade process completed with ERRORS. Please contact our support team.

Find upgrade logs in the folder: D:\BPM 7.12 PS\CRM\Terrasoft.WebApp\DesktopBin\WorkspaceConsole\Log

PLEASE NOTE: If you can login to the site but still have errors in log, updrade process is not finished yet!

After Website restarting i have error "Versions of application "7.12.0.2702" and configuration "7.11.3" are incompatible"

Do you have any idea how to fix the problem?

Thank you!

1 comments

03:14 May 17, 2018

Dear Alin,

Please check that you have the SharpSvn.dll file in Terrasoft.WebApp\DesktopBin\WorkspaceConsole\x64\ folder.

Also it would be useful to double-check that the .Net Framework and MS Visual C++ versions meet the requirements of the system. You may use the following links for the last available versions of the software:

Microsoft Visual C++ Redistributable

Microsoft .NET Framework 4.7.1

After the updates are installed you need to re-register the ASP.Net version and run the following command:

aspnet_regiis.exe /iru.

Aspnet_regiis.exe file can be found in one of the following places:

%windir%\Microsoft.NET\Framework\v4.0.30319

%windir%\Microsoft.NET\Framework64\v4.0.30319

Also make sure the loadFromRemoteSources parameter is set to 'True' in the config files.

Lisa

Show all comments

Question