7.11
sales_enterprise

Hello Community!

In a script task need get from the EntitySchemaQuery the column name and the value (string) of them.

Any example?

 

Like 0

Like

2 comments

You could create new ESQ instance, then pull columns with the addcolumn method, then do something with that date. 

 

Example:

//Create esq instance 

var esq = new EntitySchemaQuery(UserConnection.EntitySchemaManager, "Account");

//Add column method returns object, and save a reference to column object in var nameColumn

var nameColumn = esq.AddColumn("Name");

//add a filter or more columns . . .

//when youre finished setting up the columns and filter you can run the "GetEntityCollection" method to grab data

var entityCollection = esq.GetEntityCollection(UserConnection);

//do something with data 

return true;

 

What exactly are you trying to do?

Please find the answer in the post by the link below

https://community.bpmonline.com/questions/get-title-columns-esq

Show all comments
7.11
sales_enterprise



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

Hello Community!

I need put the same style of mobile and email to a custom section. 

When can find the style to implement in a custom CSS.

Regards,

 

Like 0

Like

1 comments

Dear Federico,

The implementation of the custom style is discussed in the thread below:

https://community.bpmonline.com/questions/how-add-custom-style-control-page-based-condition

You can inspect the elements using the developer tools and check which styles you want to use.

Best regards,

Matt

Show all comments
style
control
align
7.11
sales_enterprise

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
7.11
sales_enterprise

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
relationship
contacts
7.11
sales_enterprise

Hello community I'm trying show a Contact.Type in a custom profile. But i have a error when put the diff:

	{
		"operation": "insert",
		"name": "ContactType",
		"values": {
			"layout": {
				"colSpan": 24,
				"rowSpan": 1,
				"column": 0,
				"row": 1,
				"layoutName": "UsrLeftContainer"
			},
			"bindTo": "Contact.Type",
			"enabled": true,
			"contentType": 5
		},
		"parentName": "UsrLeftContainer",
		"propertyName": "items",
		"index": 0
	},

And the console return me:

Heading for label Contact.Type not found.

 

Is something worn in the code?

 

Regards,

 

 

 

Like 0

Like

1 comments

Unfortunately, the out-of-the-box system doesn't allow displaying linked fields. If you want to do this, you need to create a custom control that will process the linked field. If you want only show the value without a modification option, please consider creating a new field linked to an attribute (virtual column). This way you'll need to fill the attribute in with the needed value with a method. Please search the "dependencies" keyword in an out-of-the-box js code for more information. 

Show all comments
7.11
sales_enterprise

Hello Community!!

 

I have 2 sections appoint to contact and I regiter this sections in sysModule table and all works ok but the problem is the menssages on the Feed. 

If I put a menssage to ahoter user. When the user want open the message (in the notification Center) I get the function:

 

Terrasoft.ModuleUtils.getEntityStructureByName(entitySchemaName); 

 

TypeError: entityStructure is undefined NetworkUtilities.js:101:8

 

Any know if need register the section in other table related with Feed Notifications?

 

Regards,

 

Like 0

Like

3 comments

Dear Federico,

First of all, we recommend you to create sections via the section wizard, since creating them the way you have described can lead to various conflicts in a database structure. Also, it is not recommended to create two sections, that point to the exact same object for the same reason.

Moreover, we recommend you to debug your customization using your browser's developers tools in case you still want to proceed working with your customization. Also, you can refer to the development documentation for more information.

Best regards,

Matt Watts

Matt Watts,

 Thank you! Can you please give me the code of the function?

Terrasoft.ModuleUtils.getEntityStructureByName(entitySchemaName); may be can check the code to see the error.

Federico Buffa,

You can find the needed method in the ModuleUtils schema of the NUI package.

Here is the code sample you need, but you can refer to the schema if needed.

getEntityStructureByName: function(entitySchemaName) {
			var entityStructure = this.entityStructure || {};
			return entityStructure[entitySchemaName];
		},

Best regards, 

Matt

Show all comments
container
LeftModulesContainers
7.11
sales_enterprise



Hello Community!!

How can add a new Left Container in the LeftModulesContainers? I need a new container with fields like profilecontainer.

Regards,

 

Like 0

Like

3 comments

It seems like you can do this with a section wizard. Just add fields into the container showed on the screenshot below and the system will create a new container automatically. 

 

 

Eugene Podkovka,

 In the custom sections only shows the profilecontainer.

Please add a new container manually and then use "Section wizard" to fill it in.

{

        "operation": "insert",

        "name": "UsrLeftContainer",

        "parentName": "LeftModulesContainer",

        "propertyName": "items",

        "values": {

            "itemType": Terrasoft.ViewItemType.GRID_LAYOUT,

            "items": []

        }

    }

 

Show all comments
7.11
sales_enterprise

Hi All,

We would like to put extra filter on a detail.



For example: A list of open opportunities. I could not file good example in the documentaion.



Is there anyone who has same experience?

Like 0

Like

2 comments
Best reply

Dear Cheng,

You can use the Email detail from the Contact page as an example. There is a fixed filter there that allows the user to see the activities with the certain category (Email) only. 

The schema looks like this:

EmailDetailV2: {
   schemaName: "EmailDetailV2",
   filter: {
      masterColumn: "Id",
      detailColumn: "Contact"
   },
   filterMethod: "emailDetailFilter"
}

You need to pay attention to the filterMethod usage and create the necessary ESQ filters inside the method:

filterGroup.add(
   "EmailFilter",
   this.Terrasoft.createColumnFilterWithParameter(
      this.Terrasoft.ComparisonType.EQUAL,
      "Type",
      ConfigurationConstants.Activity.Type.Email
   )
);

Lisa

Dear Cheng,

You can use the Email detail from the Contact page as an example. There is a fixed filter there that allows the user to see the activities with the certain category (Email) only. 

The schema looks like this:

EmailDetailV2: {
   schemaName: "EmailDetailV2",
   filter: {
      masterColumn: "Id",
      detailColumn: "Contact"
   },
   filterMethod: "emailDetailFilter"
}

You need to pay attention to the filterMethod usage and create the necessary ESQ filters inside the method:

filterGroup.add(
   "EmailFilter",
   this.Terrasoft.createColumnFilterWithParameter(
      this.Terrasoft.ComparisonType.EQUAL,
      "Type",
      ConfigurationConstants.Activity.Type.Email
   )
);

Lisa

Lisa Brown,

Thank you. It works now.

Show all comments
7.11
sales_enterprise
#addProductImage
#Orders

How can we add a Product Image in the Product Selection page in the [Orders] section? Please suggest.

Like 0

Like

1 comments

Dear Anupama,

This is a quite complex functionality to implement, which requires developer's skills. In the core, the idea is to add one extra column to the grid of product selection page and display product image there.

In order to add extra field to the grid you need to do the following:

1. Add the ProductSelectionViewModel replacing schema

2. Copy all the code to the replaced schema from the parent schema

3. Add Dependencies as in the parent schema

4. Add a custom variable in all methods where the standard fields "Unit, Price , Currency, Tax, Code, Available" are

5. Save the replaced schema

6. Add the ProductSelectionView replacement schema

7. Copy all the code to the replaced schema from the parent

8. Add Dependencies from the parent schema

9. In the getEditableGridConfig and getGridCaptionConfig methods, add the custom field for the picture

 10. Save replacement schema

By the means of basic JS methods like "getImageURL" (it is also present in the ProductSelectionViewModel schema) insert image to the  column. You can also take a product page as an example of usage of image functionality.

Hope you find it helpful.

Regards,

Anastasia

Show all comments