Hi all,

Can this document in academy be elaborated with some examples using custom objects or constructing column path with multiple objects.

Build path to columns | Creatio Academy

I want to apply multiple filters on a custom section object based on a status field. And the same status field is also used in a detail object added in Account.

So once the custom section object filter is applied, i want to apply the filter based on the detail in account.

Hi community,

Is it possible to filter a Lookup field type "Selection window" with a ESQ query? I need to use a ESQ query with some logical operators to filter the result of the lookup window.

I Know how to do that with lookup field type "List" but it not works with lookup type "Selection window".

Thanks,

 

Tiago Pierine

Hi all !

On the account section, i would like to filter accounts which have not received any email

I tryed to used the "History on account section" with the Object email but it looks like it did not work because in my example below the account is having an email in its timeline tab.

On the account i ve an email record in the history tab:

Does anybody knows how can i retrieve accounts with no emails history ?

Thank you

nicolas

Hi Community,

What is the syntax for EntitySchemaQuery createColumnIsNotNullFilter in server side code?

Thanks

Hi

I have applied filtration logic for one Contact lookup field in a section edit page based on User Role and role-based contacts alone getting listed in that field. But when I put the same filter in portal edit page of the section for the same lookup field, it is not showing the contacts. 

Please find below the used code.

Case: Users having Role Id : 'KYC', has to be listed in the lookup field.

Filter code:  Inside Attributes,

"GlbKYC": { 

// Attribute data type.

"dataValueType": Terrasoft.DataValueType.LOOKUP,

// The configuration object of the LOOKUP type.

"lookupListConfig": {

"filters": [

function() {

var filterGroup = Ext.create("Terrasoft.FilterGroup");

filterGroup.add("IsKYC",

Terrasoft.createColumnFilterWithParameter(Terrasoft.ComparisonType.EQUAL, "[SysAdminUnit:Contact].[SysAdminUnitInRole:SysAdminUnit].SysAdminUnitRoleId", "C14E5787-4BF5-4FA8-A407-96FB942A02E2"));

return filterGroup;

}]}},

Kindly help to resolve this.

Regards

Abinaya

Hello Colleagues,

I need to add a different "filter Business rule" for the same field regarding the value of another field, this is not possible using the Filter Business rule wizard, how can I did it?

In my case, regarding the contact Account Type I want to filter the possible Contact Types we want to enable, for example

• if the account type is Our Company, contacts type just can be Employee,
• if account type is Customer, contact type just could be "Customer" or "Contact Person"

Thanks in advance

Dear community,

We added a detail to our product page where we can add options.

These options are products as well so whenever we press on the "+" we get a popup with a muliselect where we can choose all the options:

https://prnt.sc/xtcr11

The problem here is that we can see all the options with different Categories.

How can we filter so it only shows the category that is the same as the product above it?

thank you!

Kind regards,

Yosef

Is it possible to have a date filter on a folder or search that excludes/includes for last 6 months from the current date?

Hi everyone,

We created a custom entity that has a Contact lookup called [UsrConsumidor] and we need to get a value from a Contact's field called [UsrTotalPtsAcumulados].



We got an exemple from the bpm'online academy (https://academy.bpmonline.com/documents/technic-sdk/7-10/entityschemaqu…) and followed the exactly same structure, but it's not working. 

​var contactId = this.get("UsrConsumidor");
 
// Create Terrasoft.EntitySchemaQuery class instance with [Contact] root schema.
	var esq = this.Ext.create("Terrasoft.EntitySchemaQuery", {
	rootSchemaName: "Contact"
});
 
// Add column with name of main contact of accounts that refers to given contact.
esq.addColumn("UsrVouchers.UsrConsumidor.UsrTotalPtsAcumulados", "ContactTotalPtsAcumulados");
 
// Get one record from selection on the basis of [Id] of card object and display it in an info window.
esq.getEntity(contactId, function(result) {
	if (!result.success) {
		// error processing/logging, for example
		this.showInformationDialog("Data query error");
		return;
	}
	this.showInformationDialog(result.entity.get("ContactTotalPtsAcumulados"));
}, this);

The error that is given in the console is: "errorCode: "FormatException", message: "Expected hex 0x in '{0}'." "

Am I doing something wrong or is there an easier way to get an object by ID?

Best regards,

Rogério Zampieri.