What is the counterpart of CreateFilterGroup, CreateExistsFilter and Sub Filters in server side

Hi Community,

 

I need to convert below client code to server side code. I could not find samples of CreateExistsFilter with sub filters in server side code. Any Idea please?

 

var subFilters = Terrasoft.createFilterGroup();
subFilters.addItem(Terrasoft.createColumnFilterWithParameter(Terrasoft.ComparisonType.EQUAL, "Owner", "a6b4ea0c-420c-45ab-81e7-6e76c8cc15f7"));
 
var existsFilter = Terrasoft.createExistsFilter("[Activity:Account].Id", subFilters)
esq.filters.addItem(existsFilter);
Like 0

Like

1 comments

Hello,

The Terrasoft.Core.Entities.EntitySchemaQuery class is used to build queries for selecting records in Creatio database tables. As a result of creating and configuring the instance of this class, the SELECT SQL-expression query to the application database will be built. You can add the needed columns, filters, and restriction conditions to the query.

In the Creatio Academy documentation, you can find a description of the CreateExistsFilter method.
Useful links:
https://academy.creatio.com/docs/8.x/dev/development-on-creatio-platform/back-end-development/data-operations-back-end/orm/references/entityschemaquery

https://academy.creatio.com/api/netcoreapi/8.0.0/api/Terrasoft.Core.Entities.EntitySchemaQuery.html#Terrasoft_Core_Entities_EntitySchemaQuery_CreateExistsFilter_System_String_


We also recommend that you review the example provided in this post on the Creatio Community:
https://community.creatio.com/questions/syntax-createexistsfilter-sub-f…


Thank you.

Show all comments