Question

I am attempting to call a stored procedure via a script object in a Business Process. When the system complies, I get the error:‘

UserConnection’ is a type, which is not valid in the given context

Any suggestions on how to resolve this?

Below is my code:

StoredProcedure storedProcedure = new StoredProcedure(UserConnection, "mystoredprocedure") ;
storedProcedure.Execute();
return true;

Thanks in advance.

Like

0 comments
Log in or register to comment
Question

Hi Consultants,

I want to add some fields from contact section inside order section, Currently, only the contact lookup that shows the name of the contact is available out of the box, I want to add extra fields from contact like Country and City fields so they will be populated automatically once I select a contact inside order section.

We are using the cloud version of bmp'online sales commerce.

Best regards,

Mohammad

Like

1 comments

Dear Mohammad,

The easiest option to achieve your purpose would be creating a custom business process that would be triggered by the field Contact changed on the Order page. The process will read the contact data (including City and Country) and auto-populate the fields with the help of Modify Data element. So this would be a simple process that consists of three elements only. 

Lisa

Log in or register to comment
Question

Hi all,

I would like to know how to create a section for the InvoiceProduct schema.

I have found some info for the Usr one, but not on the standard ones ?

Like

2 comments

Dear Jerome,

The new section can be created based on the existing object in database directly only. 

Here is the example of the query you should run to create a new section based on the Activity object:

insert into SysModule
(Caption, SysModuleEntityId, Image16, Image20, FolderModeId, GlobalSearchAvailable, HasAnalytics, HasActions, HasRecent, Code, ModuleHeader, CardSchemaUId, SectionModuleSchemaUId, SectionSchemaUId, CardModuleUId, Image32Id, LogoId)
values
('Emails', 'a2e7bf65-7380-e011-afbc-00155d04320c', (select Image16 from SysModule where Id = '055063c9-8180-e011-afbc-00155d04320c'), (select Image20 from SysModule where Id = '055063c9-8180-e011-afbc-00155d04320c'), 'b659d704-3955-e011-981f-00155d043204',
1, 1, 1, 0, 'Email', 'List of mails', '80918b27-ff37-4d8c-ba73-c985d74d3dc2', 'df58589e-26a6-44d1-b8d4-edf1734d02b4', '569aaf1a-5943-4f87-ab47-948d941e4920', '4e1670dc-10db-4217-929a-669f906e5d75', 'abe30a95-e663-43a9-a881-834b70de5206', '631b1018-9b82-43fe-9f5e-aad272aae679' )

This is the first step to create a separate section that will display the activities with the type email only. The following actions you should perform are:

1) changing the section page schema

2) changing the edit page schema

3) changing the minipage schema etc

Lisa

 

 

Lisa Brown,

Thank you very much for your quick response.

Log in or register to comment
Question

Has anyone been able to use PowerShell to call bmp'online's Rest API to get data?  any examples of the JSON body contents of the GET request?  I just need to read a few fields on a specific account for an external integration tool.

Thanks.

Like

1 comments

Please find the requests that you need to build in the article by the link below. 

https://academy.bpmonline.com/documents/technic-sdk/7-11/executing-odat…

If you need to read data, then you need to create a login request, receive login cookies and then create a get request with the received cookies.

Please find how to create a get request with PowerShell in the microsoft documentation by the link below

https://docs.microsoft.com/en-us/powershell/module/microsoft.powershell…

https://www.jokecamp.com/blog/invoke-restmethod-powershell-examples/

Log in or register to comment
Question

Hello Community!

I need know how detect when a lookup is change get the old value and new value.

Any have a example?

Regards,

 

Like

1 comments

Dear Federico,

You can set up the Change Log for the object the lookup is based on. This way you'll be able to track all the modifications including old/new values.

Lisa

Log in or register to comment