Hi,

I'm trying to retrieve a collection using EntitySchemaQuery but when try to assign it to a Parameter i get the following error:

System.NotSupportedException: EntityCollection
   at Terrasoft.Core.Process.FlowEngineStateService.InternalSetValue[T](Guid processUId, String parameterPath, T value)
   at Terrasoft.Core.Process.FlowEngineStateService.Terrasoft.Core.Process.IInternalProcessParameterStore.InternalSetParameterValue[T](Guid processUId, String parameterPath, T value)
   at Terrasoft.Core.Process.ProcessInstanceParameterStore.SetParameterValue[TValue](String parameterPath, TValue value)
   at Terrasoft.Core.Process.ProcessInstanceParameterStore.SetParameterValue[TValue](ProcessSchemaParameter parameter, Guid schemaElementUId, TValue value)
   at Terrasoft.Core.Process.ProcessModel.SetParameterValue[T](FoundParameterData result, T value)
   at Terrasoft.Core.Process.ProcessModel.TrySetValue[T](ProcessSchema processSchema, String propertyPath, T value)
   at Terrasoft.Core.Process.ProcessModel.Set[T](String propertyPath, T value)
   at Terrasoft.Core.Process.UsrGetLeadsBySalesCompanyMethodsWrapper.ScriptTask1Execute(ProcessExecutingContext context)
   at Terrasoft.Core.Process.ProcessScriptTask.InternalExecute(ProcessExecutingContext context)
   at Terrasoft.Core.Process.ProcessFlowElement.Execute(ProcessExecutingContext context)

Example code:

var salesCompanyId = Get<Guid>("InSalesCompany");
 
// Creating a query instance with the "Lead" root schema.
var esqLead = new EntitySchemaQuery(UserConnection.EntitySchemaManager, "Lead");
esqLead.AddColumn("UsrSalesCompany");
esqLead.AddColumn("CreatedOn");
esqLead.AddColumn("UsrLeadPriority");
esqLead.AddColumn("Id");
esqLead.Filters.Add(esqLead.CreateFilterWithParameters(FilterComparisonType.Equal, "UsrSalesCompany.Id", salesCompanyId));
 
// Filters in the query filter collection will be combined with the logical OR operator.
esqLead.Filters.LogicalOperation = LogicalOperationStrict.Or;
 
 
var entities = Get<ICompositeObjectList<ICompositeObject>>("ReadActiveOverrides.ResultCompositeObjectList");
foreach(var entity in entities) {
 
    Guid value;
    var fromSalesCompanyId = entity.TryGetValue<Guid>("UsrFromSalesCompany", out value) ? value : Guid.Empty;
    var toSalesCompanyId = entity.TryGetValue<Guid>("UsrToSalesCompany", out value) ? value : Guid.Empty;
 
    if(fromSalesCompanyId == Guid.Empty){
        throw new Exception($"fromSalesCompanyId it is an empty guid {entity.ToString()}");
    }
 
    if(toSalesCompanyId == Guid.Empty){
        throw new Exception($"toSalesCompanyId it is an empty guid {entity.ToString()}");
    }
 
	esqLead.Filters.Add(esqLead.CreateFilterWithParameters(FilterComparisonType.Equal, "UsrSalesCompany.Id", fromSalesCompanyId));
}
 
/*
Select selectEsq = esqLead.GetSelectQuery(UserConnection);
throw new Exception(selectEsq.GetSqlText());
*/
 
var res = esqLead.GetEntityCollection(UserConnection);
 
Set("OutLeads", res);

Paremeter OutLeads is a Collection of Objects (EntityCollection)

Any help is appreciated

Hi Guys ,

Please guide me, how to rename the main page (system ) display name ?

Secondly, How to add web page on the "About" section ?

---pfa--

In short, is this possible? For example, I want to require entry of a Contact Type on a new contact entry page, but I want to do it in the UI, not by making the underlying data column a NOT NULL column.

Hi guys, 

Do you know how to include a space between 2 buttons in an Edit page?

Thank you so much!

Hi, 

Is it possible to specify a different attribute (unique attribute from the source table) instead of Name in the Data Import templates for Lookup columns? 

For example, to update existing prices an import to Product Price table must be done. In the Data Import Template for Product Price table, there is a Product (Lookup) column. The name of the product goes in the Product column for bpmonline to identify the referenced product. Is it possible to use Product code instead of Product Name as there may be more than 1 product with the same name but the code is unique across the entire product catalog. 

Regards,

Hatim

Hi guys,

Can you please guide me to how to add images in dashboard sections ?

Hi,

I have the Project detail section included on one of my Account tabs, so that users can see all current and past projects we have worked on with that customer.

The issue is that his Project section detail list includes Project Tasks as well as the Project, where I only wish to display the Projects. I cannot find a way to filter out the Project Tasks from this display and the simple workaround of displaying the Project Task Type in the output is not great, as this only allows the user to identify and not remove. The live filter option is a one time thing and would mean a user has to create the filter each time they load the page up, which is not efficient.

How can I have this only showing Projects?

Добрый день, коллеги!

На нашем коммерческом проекте сильно увеличился размер БД - разрослись системные таблицы.

Подскажите, можно ли уменьшить размер системных таблиц в БД? 

Предполагаю, что возможно очистить таблицу SysProcessElementLog.

I am trying to used lookup for “VwSysSchemaInfo” which lists the Object’s Name(For example : in LandingType table, column name schemaUid for object lists). But am getting foreign key error like

“SqlException. Foreign key 'FKYLKAi7ejsTUaCmQl1hwk3jQcw' references object 'dbo.VwSysSchemaInfo' which is not a user table. Could not create constraint or index. See previous errors.”

Please help.

I need to have this lookup. Why am I not able to use this. Since its already by implemented in one of the table (LandingType), why is this not possible for custom objects.

Also please help me to use this as a lookup column.

I am trying to generate a printable from the opportunity object (which will be a quote) and attach this printable to an email after generating.

I am getting stuck on the generate and save printable script task. 

This is the error I am getting

Terrasoft.Common.ItemNotFoundException: Value "Name" 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.UsrlabSavePrintableAndEmailQuote1Custom6.ScriptTask1Execute(ProcessExecutingContext context)
   at Terrasoft.Core.Process.ProcessFlowElement.Execute(ProcessExecutingContext context)

I'm not sure what the issue is. I tried hardcoding the name in the script but that doesn't seem to work either. 

My script action that is failing.

var reportService = new Terrasoft.Configuration.ReportService.ReportService();
Terrasoft.Configuration.ReportService.ReportData report = reportService.GenerateMSWordReport(
    (PrintableId.ToString()), ObjectId.ToString(), ConvertToPdf);
var entity = UserConnection.EntitySchemaManager.GetInstanceByName("Opportunity");
var fileEntity = entity.CreateEntity(UserConnection);
fileEntity.SetDefColumnValues();
fileEntity.SetColumnValue("Id", OpportunityId);
fileEntity.SetColumnValue("TypeId", AttachmentType);
fileEntity.SetColumnValue("Name", "ExamplePrintable.docx");
fileEntity.SetColumnValue("Data", report.Data);
fileEntity.Save();
 
 
return true;

Let me know if you need any more information.

Also, any documentation where I can read up on this myself. Like the fileEntity variable, or just how this code works in general.

Any help is appreciated thanks!