Hello community!

I need get the title of the column form ESQ. The query not have the tile localization.

How can get it? Any function or ESQ query to have that?

 

Regards,

 

Like 0

Like

3 comments

It should be something like this

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

var activityQuery = new EntitySchemaQuery(userConnection.EntitySchemaManager,"Activity");

activityQuery.AddAllSchemaColumns();

var activityId = new Guid("0afe839a-ff8c-4543-a7b8-29e4aab9787a");

var filter = activityQuery.CreateFilterWithParameters(FilterComparisonType.Equal, "Id", activityId);

activityQuery.Filters.Add(filter);

var activityEntities = activityQuery.GetEntityCollection(userConnection);

foreach (var activityEntity in activityEntities)

{

    var titleColumnCaption = activityEntity.Schema.Columns.GetByName("Title").Caption.Value;

}

return true;

Eugene Podkovka, This is only for c#? is posible in javascript?

In JS columns are already loaded. You can get access to the columns in the following way.

https://academy.bpmonline.com/documents/technic-sdk/7-11/use-entitysche…

Show all comments



Hello community!

I need your help.

I'm using a BaseFieldDetail like the sample in the academy:

https://academy.bpmonline.com/documents/technic-sdk/7-11/creating-custom-detail-fields

the problem is that my mastercolum is not the Id of the record, is just a column with a related contact.

i need reload/refresh the detail when the contact change for another. I did try with loadDetail() because the reloadDetail is obsolete but not refresh the data.



Any Idea?

 

Like 0

Like

2 comments

Solved with this.updateDetail({detail: "DetailName"});

Frederico, thanks for the update!. I was facing the same issue and it solved my problem. Regards.

Show all comments

I am trying to open a new record of a existing custom object using Pre-Configured Process element. I am able to load the card schema when the process runs but when I save it, it closes the form and i can see a record saved. But in the Process log, it is still running and in an infinite loop.

<>

How can i get the ID of the record running in the Pre-configured page? I want the system to run a set of activities after it save the record. I am not able to use Edit Page process element as it gives me the below error:

"Terrasoft.Core.LicException: Cannot add more than 1000 records to table "ActivityParticipant" in demo mode".

Any suggestion will be highly appreciated.

 

File attachments
Like 2

Like

7 comments

Dear Anupama,

This error indicates that you have added more than 1000 records to the ActivityParticipant object in the demo mode. As this limit is reached, the system cannot add more records to this object so that the process cannot be completed. You need to delete some records from this object to test your process in demo mode.

Best regards,

Lily

Dear Lily,

Thanks for your prompt reply.

Since there are some in progress activities which has some participants connected to it, how can I remove the Activity participants records without affecting any task and I am not sure which participant's task is currently active. 

Appreciable if you can share the steps on how to do it? 

 

Thanks

Anupama

Dear Anupama,

You can try to delete some completed or any other activities that you do not need so that the Activity participants should be also deleted for those records. Please try to deal with it in this way. 

Best regards,

Lily

Let me reframe this question, will deleting activities remove the participants from activity participants object? 

Please let me know as it is bit confusing for me now?

ok. great. I guess we both commented at the same time. Sure let me try to do the way recommended.

 

Dear Anupama,

Great! In case you have any other questions, feel free to ask. 

It worked. Thanks Lily.

Show all comments

We use different templates of documents to different types of business and services.

And how we can use conditions?

For example:

How we can define that if type of business 'b2b' (at contragents card) then system should print "form №1", else - "form №2"?

Or if type of product "internet" at printable form choose "1 static IP", else "_"?

Thank you, for you support!

Like 0

Like

2 comments

Dear Alexander,

You can make the field visible or hidden if the printable meets some conditions with the help of the development tools only. Please use the following script as an example for further investigation. It hides a form depending on a field value (if it’s less than 350 000 in this case) and you can alter it to reach your aim:

define("OpportunitySectionV2", ["VisaHelper", "LookupUtilities", "BaseFiltersGenerateModule", "css!VisaHelper"], 
function(VisaHelper, LookupUtilities, BaseFiltersGenerateModule) { return { entitySchemaName: "Opportunity", 
attributes: {}, 
methods: { preparePrintFormsMenuCollection: function(printForms) { this.callParent(arguments); printForms.eachKey(function(key, item) { if (item.values.Caption === "Quotation" &amp;&amp; this.get(“Amount”)&lt;350000 item.set("Visible", false); } }, this); } }, 
diff: /**SCHEMA_DIFF*/[]/**SCHEMA_DIFF*/ }; });

Please also note that such idea has been registered for our R&D team to include the functionality in the upcoming releases in the out-of-the-box version.

Best regards,

Lily

Lily Johnson,

Thank you, Lily)

Show all comments

Hello community!!

I need apply a style to the left container but don't know who.

The idea is have the label and control align to left on all controls of the container.

Any style to apply this??

Like 0

Like

3 comments

Please find the answer on how to add a custom style to a page in the article by the link below.

https://community.bpmonline.com/questions/how-add-custom-style-control-…

Thanks Eugene Podkovka, exist a sample on the system to inherit?

It's not possible to inherit styles.

Show all comments

Hi all,

I try to retrieve a schema by its name (on the client side), I've seen it in the standard, just can't remember where it was ...

 

Like 0

Like

2 comments

Dear Jerome,

You can find the schema by the name in the configuration (System Designer -> Advanced settings -> Configuration). Please note that there may be a few schemas with the same name belonging to different packages. The schemas with the user customization are placed in the Custom package and if there is no schema in that package you'll need to create it to be able to apply any changes. 

Lisa

Sorry, I mean by script. Not on the UI.

Something like .EntitySchemaManager.GetInstanceByName("SysSchema") in C#

Show all comments
Question

Hello,

 

When a new account is created it also creates an account address. I was wondering if there is any way to disable this?

 

Thank you.

Like 0

Like

1 comments

Dear Cristian,

In out-of-the-box version of the system the Address fields are not required for creating a new account, so you may leave them empty. If in your system you cannot skip this step, please write an email to support@bpmonline.com with the URL of your instance so we could check and provide you with the further assistance.

Lisa

Show all comments

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 0

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

Show all comments

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 0

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.

Show all comments

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 0

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

Show all comments