I am creating a new record:

var schema = UserConnection.EntitySchemaManager.GetInstanceByName("UsrTable");
var entity = schema.CreateEntity(UserConnection);
entity.SetDefColumnValues();
entity.SetColumnValue("UsrColumn", columnValue);
entity.Save();
var recordId = entity.GetColumnValue("Id");

and then creating a linked record in a related table:

var schema2 = UserConnection.EntitySchemaManager.GetInstanceByName("UsrRelatedTable");
var entity2 = schema2.CreateEntity(UserConnection);
entity2.SetDefColumnValues();
entity2.SetColumnValue("UsrTable", recordId);
entity2.Save();

I'm getting the following error referring to the `UsrTable` lookup column in `UsrRelatedTable` table when running the process:

Terrasoft.Common.ItemNotFoundException: Value "UsrTable" was not found.
   at Terrasoft.Core.Entities.EntityColumnValueCollection.GetByName(String name)
   at Terrasoft.Core.Entities.Entity.SetColumnValue(String valueName, Object value)
   at Terrasoft.Core.Process.UsrImportCustomersSubMethodsWrapper.DeserialiseJSONExecute(ProcessExecutingContext context)
   at Terrasoft.Core.Process.ProcessScriptTask.InternalExecute(ProcessExecutingContext context)
   at Terrasoft.Core.Process.ProcessFlowElement.ExecuteItem(ProcessExecutingContext context)
   at Terrasoft.Core.Process.ProcessFlowElement.Execute(ProcessExecutingContext context)

The question is essentially how to initialise a lookup column with a record Id.

I need to create a lookup filter for the following SQL

DECLARE @P1 uniqueidentifier = 'D21F0468-F86B-4707-9FDB-C093CF0F6F87';
 
SELECT UsrProductList.Name
FROM UsrProductList
WHERE EXISTS (
	SELECT UsrProductLineOfBusiness.UsrProduct
	FROM UsrProductLineOfBusiness
	WHERE UsrProductLineOfBusiness.UsrProductId = UsrProductList.Id
	AND UsrProductLineOfBusiness.UsrLineOfBusinessId = @P1
)

Following this post I got as far as

"UsrProduct": {
	"dataValueType": Terrasoft.DataValueType.LOOKUP,
	"lookupListConfig": {
		"filter": function() {
			var opportunityLobId = this.get("Opportunity.UsrOpportunityLineOfBusiness").value;
			var filterGroup= this.Ext.create("Terrasoft.FilterGroup");
			var subFilter = Terrasoft.createFilterGroup(Terrasoft.createColumnFilterWithParameter(Terrasoft.ComparisonType.EQUAL, *** GROUND TO A HALT HERE *** , opportunityLobId));
			subFilter.addItem();
			filterGroup.add(Terrasoft.createExistsFilter([UsrProductLineOfBusiness:UsrProduct].id, subFilter));
			return filterGroup;
		}
	}
}

However ground to a halt at `UsrProductLineOfBusiness.UsrProductId = UsrProductList.Id` in the subquery.  If anyone has any clues they would be appreciated!

Hi there!

I'm trying to run clio in Docker on Ubuntu Server 20.04.

Following instructions provided here - https://github.com/Advance-Technologies-Foundation/clio#installation-an…, I have downloaded the source code, and executed "docker build -f ./install/Dockerfile -t clio ."

But I got unexpected output, and, seems, clio container did not even started:



 

DEPRECATED: The legacy builder is deprecated and will be removed in a future release.
            Install the buildx component to build images with BuildKit:
            https://docs.docker.com/go/buildx/
 
Sending build context to Docker daemon  2.899MB
Step 1/13 : FROM mcr.microsoft.com/dotnet/sdk:3.1 as base
 ---> 1e8401d05dea
Step 2/13 : WORKDIR /app
 ---> Using cache
 ---> 18f52a48e0a5
Step 3/13 : FROM mcr.microsoft.com/dotnet/sdk:3.1 AS build
 ---> 1e8401d05dea
Step 4/13 : WORKDIR /app
 ---> Using cache
 ---> 18f52a48e0a5
Step 5/13 : COPY clio clio
 ---> Using cache
 ---> fa0fb42a25ec
Step 6/13 : COPY clio.sln clio.sln
 ---> Using cache
 ---> d8527c9fcc93
Step 7/13 : WORKDIR /app/clio
 ---> Using cache
 ---> f4ae3f90ec62
Step 8/13 : RUN dotnet publish -c Release -o /app/published
 ---> Running in 432ba7ef38dd
Microsoft (R) Build Engine version 16.7.3+2f374e28e for .NET
Copyright (C) Microsoft Corporation. All rights reserved.
 
  Determining projects to restore...
/app/clio/clio.csproj : error NU1202: Package DocumentFormat.OpenXmlSDK 2.0.0 is not compatible with net6.0 (.NETCoreApp,Version=v6.0). Package DocumentFormat.OpenXmlSDK 2.0.0 supports: net35 (.NETFramework,Version=v3.5)
  Failed to restore /app/clio/clio.csproj (in 6.4 sec).
The command '/bin/sh -c dotnet publish -c Release -o /app/published' returned a non-zero code: 1

Is it possible to configure time based workflows - i.e., end dates and durations specified for workflow stages?

Подскажите мне пожалуйста - в сиситеме есть разделы, а в разделах вкладки и поля, нет ли возможности просмотреть историю изменения данных полей например через логирования ?

Спасибо 

Hello, the system does not log in, what is the problem, please tell me?

Approvals by the user's manager are showing in the Approvals tab on the Opportunities section edit page, however I assume they should also show on the Communications panel / Notification centre / Approvals tab with the 'Show only my approvals' flag unticked.

Is there any reason why they might not show here?

Thanks,

Здравствуйте!

У нас печатные формы договоров двуязычные. Т.е в одном шаблоне слева Казахский язык, справа - Русский.

Столкнулись с проблемой того, что на двух языках формат разный. Примеры адресов:

Рус: 050060, Республика Казахстан, Алматинская область, г. Алматы, ул. Розыбакиева, 263

Каз: 050060, Қазақстан Республикасы, Алматы облысы, Алматы қ, Розыбакиев к., 263

1. В справочнике стран наша страна = Казахстан. Переименовывать не хочется.
2. Для значений полей Страна, Область, Город значения на двух языках разные с приставками-сокращениями города (г.). Да и сами названия - разные.
3. На двух языках улица - разная и позиция слова разная: ул. пишется перед названием улицы, к. пишется после названия улицы, но и оно ручками пишется.
4. Названия улиц так-же склоняются по разному. Для рус - ул. Розыбакиева, для каз - Розыбакиев к..

Есть ли у вас уже решения или рекоммендации по решению таких задач?

Greetings. 

I have a need to give users the ability to decide, which fields should be required for a particular page. I had some sort of the solution in my head. It makes an request and returns with a list of fields that need to be required for this particular page. The problem I am facing is making fields required via JS code (not in Diff section but in the code section, like "onEntityInitialized"). Looking forward to seeing the possible ways to solve this problem.

Hi all,

Is there a way to force a detail to remain expanded for all users?