ESQ | Community Creatio

19:13 Feb 09, 2024

Hello Harvey,

You can use out-of-the-box examples of bulk deletion logic. For example we can take the BulkEmailTargetArchiver class and...MoreLess

Show all comments (1)

Add all the columns in ESQ

Rakshith Dheer Reddy

12:21 Jun 07, 2023

Hi Community,

I want to add all the columns to the ESQ query without giving manually for each column ?

1 comments

12:50 Jun 07, 2023

Hi Rakshith,

Please don't do this since this may result in heavy SQL query with unnecessary columns that is sent to the database each time...MoreLess

Show all comments

Asynchronous

Client-side

Financial_Services_Creatio_lending_edition

8.0

Async method client side

User1997

10:47 Jan 19, 2023

Hello Creatio community,

I am using Creatio base method:

/**
 * Opens edit page for selected record.
 * @protected
 */
editCurrentRecord: function() {
	const primaryColumnValue = this.getPrimaryColumnValue();
	// ** ESQ Method
	var object = this.GetObjData(primaryColumnValue);
	// existing implementation
	...

1 comments

Dmytro Vovchenko

11:32 Jan 19, 2023

Hello,

if you want to make your methods work in a defined order, you need to use the Terrasoft.chain logic. More about it in this article.

Show all comments

Sections

Sales_Creatio_commerce_edition

esqfetchdata

8.0

fetch section record if any three fields match

Sarika Sharma

12:05 Dec 20, 2022

Hi Team,

I'm looking for a solution where I can fetch the list of records from a section if the value of any three fields that i enter in the edit page form of a new record match with the current entry field values.

For example : In my current record I enter the values as follows for the customer...MoreLess

1 comments

Sergii Zhmurko

18:19 Dec 27, 2022

Hello,

Please, specify the problem in more detail, what are the user's steps when reproducing it, what is the actual result and what is expected...MoreLess

Show all comments

Confused | ESQ and Attribute

attributes

8.0

Solem Khn

19:37 Nov 15, 2022

Why is this not working? I am genuinely confuse.

Setting visibility using ESQ is not working. Am I missing something?

define("OpportunitySectionV2", ["ConfigurationConstants"], function(ConfigurationConstants) {
	return {
		entitySchemaName: "Opportunity",
		details: /**SCHEMA_DETAILS*/{}/**SCHEMA_DETAILS*/...

5 comments

Best reply

How to Modify the filters in "ProductSelectionSchema" for product list | OOTB Orders?

18:28 Nov 16, 2022

Solem Khan Abdusalam,

It's been a bit since I last tried this, but I've tried binding visible (and caption) of buttons in ActiveRowActions and...MoreLess

Show all comments (4)

Bhoobalan Palanivelu

12:48 Oct 31, 2022

Hi Team,

I would like to modify the filters for the list of Product Displayed while adding products in OrderProduct (In Order record).

Step 1: How does the add button event open ProductSelectionSchema?

Step 2: Need to update the filters in ProductSelectionSchema?

The Product selection schema has...MoreLess

3 comments

Dariy Pavlyk

17:37 Nov 04, 2022

Hello Bhoobalan,

Regarding the first question, the add button is defined in the ProductDetailV2 schema from the ProductCatalogue package. In...MoreLess

Bhoobalan Palanivelu

18:05 Nov 14, 2022

Dariy Pavlyk,

Thanks for sharing this!

Is it possible to make the Product object in the Opportunity section (OpportunityProductInterest) t...MoreLess

Dariy Pavlyk

14:00 Nov 23, 2022

Bhoobalan Palanivelu,

We're glad to see that you were able to achieve this functionality as mentioned in these articles

https://community.creatio...MoreLess

Show all comments (2)

How to access Lookup values in ESQ and further compare it with other fields

Prashant Jha

07:10 Aug 30, 2022

Hi Team,

There is a requirement in which I have to verify a specific condition based on fields and lookup values on clicking the SAVE button. I am using ESQ in edit page schema while overriding asyncValidate method to achieve this.

But, I am unable to figure out which commands can be used to get further field values of that lookup, and then compare it. For reference, here in my case, Contact lookup is on Custom section and I want to fetch Department value of it .

Thanks in Advance, Prashant Jha

4 comments

Anastasiia Zhuravel

07:21 Aug 30, 2022

Hello,

Please check the below Community post for an example of the implementation:

https://community.creatio.com/questions/actually-i-have-developed-code-…

Let...MoreLess

Prashant Jha

09:09 Aug 30, 2022

Hi Anastasiia,

How can we fetch columns of other object through ESQ by matching them with a condition. Any example or syntax will be helpful.

Dmytro Vovchenko

14:25 Aug 30, 2022

Prashant Jha,

Hi, take a look at this article, I believe this is what you needed.

In any case, you can use another ESQ request based on the...MoreLess

Prashant Jha

06:34 Sep 01, 2022

Hi, I am overriding asyncValidate method with multiple filters (A AND C) AND (B AND C). Here C is the field from the same object, A and B are...MoreLess

Show all comments (3)

Atlas_release

Freedom UI esq

Jerome BERGES

18:02 Jul 25, 2022

Hi all,

Have you played with Freedom UI Sdk yet ?

Have you any idea of how to execute an esq ?

Best regards

5 comments

Anastasiia Marushenko

14:40 Jul 26, 2022

Hello,

Thank you for reaching out.

Could you please clarify what issue do you have and what is your business task?

Thanks in advance.

Best regards,

Anastasiia

Jerome BERGES

15:15 Jul 26, 2022

Anastasiia Marushenko,

Hi need to be able to do the following, but in freedom UI :

			setDefaultLieu: function(clientFinalId) {
					if...

16:59 Feb 09, 2023

Hello,

Freedom UI allows to call esq query (for example using the code below when the esq call is connected to attribute change):

{
				 request...

20:09 Feb 09, 2023

Oleg Drobina,

There is already support for EntitySchemaQuery in the new Creatio DevKit SDK that returns a promise that you can await rather...MoreLess

20:48 Mar 02, 2023

Jerome,

I've been told the intended use on a Freedom UI page is to use the Model class for retrieving, adding, updating, deleting dat...MoreLess

Show all comments (4)

#array

#filter

SectionActionsDashboardTabs

Studio_Creatio

7.18

Unable to push values into array correctly.

Rishabh Baghel

14:11 Jun 06, 2022

Hi Community,

I am facing an issue which is related to SectionActions Button for sending multiple records. I need to send some records (out of all selected records) to a business process in an array after filtering with esq inside section edit page.

Issue: The filtered Id's are not being pushed int...MoreLess

1 comments

Terrasoft.ComparisonType.EXISTS

15:25 Jun 07, 2022

Hi,

The issue here is that ESQ is asynchronous and as a result once the:

selectedRows.forEach(fnProgramABCArray);

is called, the browser...MoreLess

Show all comments

Filters

Service_Creatio_customer_center_edition

Syntax for using 'Terrasoft.ComparisonType.EXISTS' filter

17:23 May 15, 2022

I'm optimising a query attempting to use a filter with 'Terrasoft.ComparisonType.EXISTS', I'm guessing at the syntax and it isn't working. If anyone could point out where I'm going wrong here:

...
const subFilter = Terrasoft.createFilterGroup();
subFilter.addItem(Terrasoft.createColumnFilterWithParameter...

8 comments

17:41 May 15, 2022

Hello Gareth,

Terrasoft.ComparisonType.EXISTS is not used in the client-side system logic anymore since it was replaced with the createExistsFilter...MoreLess

18:42 May 15, 2022

Oscar Dylan,

I have tried the following but it is returning more than one record:

const caseId = this.get("MasterRecordId");
const esq = this...

18:59 May 15, 2022

Gareth Osler,

Hi Gareth. Here is a sample of how to get a count (this gets a count of all accounts with a type of "Customer", however, to just...MoreLess

20:26 May 15, 2022

Ryan Farley, Thank you for the reply. I am querying with an exists filter on the same table as the esq query, the esq query is on table...MoreLess

21:20 May 15, 2022

Gareth Osler,

I'm not 100% sure I follow. So you want to know if there's a UsrItemInOrder record for the parent Order that has a value of true...MoreLess

22:50 May 15, 2022

Ryan Farley,

That is essentially what I have done. But could that query be optimized with an exists query, it is being run on a database with circa 1.5 million records.

18:19 May 16, 2022

Gareth Osler,

What I was trying to do is illustrated in SQL terms in this stackexchange question,

SELECT TOP (1) id 
  FROM dbo.table
  WHERE...

18:46 May 16, 2022

Gareth Osler,

The only way to do a "top" or "limit" that I know of via ESQ is like this:

var esq = Ext.create("Terrasoft.EntitySchemaQuery"...