I'm trying to get a query to return rows 51-100 by using esq (serverside). I thought this would do the trick : 

 var userconnection = UserConnection.Current;
 var esq = new EntitySchemaQuery(userconnection.EntitySchemaManager, "Contact");

 esq.AddColumn("Name");
 esq.AddColumn("Email");

 // Skip the first 50 rows
 esq.SkipRowCount = 50;

 // Return the next 50 rows
 esq.RowCount = 50;

 var entities = esq.GetEntityCollection(userconnection)

I assumed the SkipRowCount would skip the first 50 records, and the RowCountt would then return the next 50 records in the table. However, i get 0 records as result. Does anyone see what I'm missing here?

Hello Creatio Community,

I’m working on creating a custom complex filter logic in a User Page JS and ran into a problem.

The following code works fine:

filter.addSchemaColumnFilterWithParameter(
    sdk.ComparisonType.Equal,
    "[TableA:TableB].ColumnX.Id",
    "1048f156-620f-4e01-8796-a43ee5182dcc"
);

However, this does not work:

filter.addSchemaColumnFilterWithParameter(
    sdk.ComparisonType.Equal,
    "[TableA:TableB].ColumnX.Id",
    "[TableA:TableB].ColumnX.[TableC:TableD].ColumnY.Id"
);

It seems like addSchemaColumnFilterWithParameter does not accept two expressions as parameters (i.e., the second argument as a schema column and the third argument as another schema column instead of a value).

Is there any other function or approach that allows passing two schema column expressions to create a complex filter like this?

can update object record permission i got error object reference error

2025-09-17 09:33:22,658 [398] ERROR IIS APPPOOL\MASTERWORK Terrasoft.Core.Entities.Entity MoveNext - VwWorkspaceObjects (Id: [53f044d6-a2df-4209-8a52-3d19e2672b54])
System.NullReferenceException: Object reference not set to an instance of an object.
  at Terrasoft.Configuration.VwWorkspaceObjects_CrtBaseEventsProcess`1.CreateRightRecordsSchema(Guid entitySchemaId)
  at Terrasoft.Configuration.VwWorkspaceObjects_CrtBaseEventsProcess`1.ScriptVwWorkspaceObjectsUpdatedExecute(ProcessExecutingContext context)
  at Terrasoft.Core.Process.ProcessFlowElement.CallInternalExecute(ProcessExecutingContext context)
  at Terrasoft.Core.Process.ProcessFlowElement.ExecuteItem(ProcessExecutingContext context)
  at Terrasoft.Core.Process.ProcessFlowElement.Execute(ProcessExecutingContext context)
  at Terrasoft.Configuration.VwWorkspaceObjects_CrtBaseEventsProcess`1.ProcessQueue(ProcessExecutingContext context)
  at Terrasoft.Core.Process.ProcessFlowElement.OnExecuted(ProcessActivityAfterEventArgs e)
  at Terrasoft.Core.Process.ProcessFlowElement.Execute(ProcessExecutingContext context)
  at Terrasoft.Configuration.VwWorkspaceObjects_CrtBaseEventsProcess`1.ProcessQueue(ProcessExecutingContext context)
  at Terrasoft.Configuration.BaseLookup_CrtCoreBaseEventsProcess`1.ThrowEvent(ProcessExecutingContext context, String message)
  at Terrasoft.Configuration.VwWorkspaceObjects_CrtBaseEventsProcess`1.ThrowEvent(ProcessExecutingContext context, String message)
  at Terrasoft.Core.Entities.Entity.ThrowEvent(String message, EventArgs eventArgs)
  at Terrasoft.Core.Entities.Entity.OnUpdated(EntityAfterEventArgs e, Boolean trackChanges)
  at Terrasoft.Core.Entities.Entity.TriggerOnUpdated(Boolean trackChanges, EntityColumnValueCollection modifiedColumnValues)
  at Terrasoft.Core.Entities.Entity.d__368.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
  at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
  at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
  at Terrasoft.Core.Entities.Entity.UpdateInDB(Boolean validateRequired, Boolean trackChanges)
  at Terrasoft.Core.Entities.Entity.d__342.MoveNext()

Hello, 

I am creating a campaign that creates a lead and an activity. The activity has to be linked to the lead. How do I do this? Currently, activity isn't a column of Leads

Hello Creatio Community,

I’m trying to implement a custom filter for a contacts dropdown on my mini page, and I need help constructing it properly.

The filter has two main conditions combined with AND:

1. The first condition itself has two sub-conditions depending on whether a certain column is null or not:
   • If the column is not null, get a string value from the related column1id table and compare it with the contacts.
   • If the column is null, get an ID value from the related column2id table, then use that ID to retrieve a string for comparison with the contacts dropdown.
2. The second condition involves a specific field ID:
   • Use this ID to filter contacts who have a checkbox selected that corresponds to this ID.

How would you tackle retrieving data from data source? How can I build a filter that applies these conditions properly with AND logic between them? 

Edit: Question no.  2:
Would it be possible to do all the filtering logic in JS (manually send a query to the database) and somehow push the result to the dropdown as datasource?