SDK
support
cases
Filtering detail records based on selected record of other detail
Tatiana Rogova
02:14 Sep 19, 2018

Main detail code

define("UsrMasterDetail", [], function() {
    return {
        entitySchemaName: "Country",
        messages: {
            "RelatedDetailUpdateFilter": {
                mode: this.Terrasoft.MessageMode.PTP,
                direction: this.Terrasoft.MessageDirectionType.PUBLISH
            }
        },
        methods: {
            onActiveRowChange: function() {
                var activeRow = this.get("ActiveRow");
                var masterDetailRecordId = typeof activeRow === "object" ? activeRow && activeRow.value : activeRow;
                this.sandbox.publish("RelatedDetailUpdateFilter", masterDetailRecordId,
                    [this.sandbox.id.replace(this.name, "MasterDetailRecordId")]);
                this.callParent(arguments);
            }
        }
    };
});

Related detail code

define("UsrRelatedDetail", [], function() {
    return {
        entitySchemaName: "City",
        messages: {
            "RelatedDetailUpdateFilter": {
                mode: this.Terrasoft.MessageMode.PTP,
                direction: this.Terrasoft.MessageDirectionType.SUBSCRIBE
            }
        },
        attributes: {
            "MasterDetailRecordId": {
                "dataValueType": this.Terrasoft.DataValueType.GUID
            }
        },
        methods: {
            init: function() {
                this.sandbox.subscribe("RelatedDetailUpdateFilter", function(masterDetailRecordId) {
                    this.set("MasterDetailRecordId", masterDetailRecordId);
                    this.setFilterByMasterRecord(masterDetailRecordId);
                    this.reloadGridData();
                }, this, [this.sandbox.id.replace(this.name, "MasterDetailRecordId")]);
                this.callParent(arguments);
            },
            loadGridData: function() {
                if (this.get("MasterDetailRecordId")) {
                    this.callParent(arguments);
                } else {
                    this.onGridDataLoaded({success: true});
                }
            },
            setFilterByMasterRecord: function(masterDetailRecordId) {
                var filters = this.get("Filter");
                filters.removeByKey("FilterByMasterDetail");
                if (masterDetailRecordId) {
                    filters.add("FilterByMasterDetail", this.Terrasoft.createColumnFilterWithParameter(
                        this.Terrasoft.ComparisonType.EQUAL, "Country", masterDetailRecordId));
                }
            }
        }
    };
});

Insert details into page

define("ContactPageV2", [], function() {
    return {
        entitySchemaName: "Contact",
        details: /**SCHEMA_DETAILS*/{
            "UsrMasterDetail": {
                "schemaName": "UsrMasterDetail",
                "filterMethod": "getGlbDetailFilter"
            },
            "UsrRelatedDetail": {
                "schemaName": "UsrRelatedDetail",
                "filterMethod": "getGlbDetailFilter"
            }
        }/**SCHEMA_DETAILS*/,
        diff: /**SCHEMA_DIFF*/[
            {
                "operation": "insert",
                "name": "UsrMasterDetail",
                "values": {
                    "itemType": this.Terrasoft.ViewItemType.DETAIL
                },
                "parentName": "GeneralInfoTab",
                "propertyName": "items"
            },
            {
                "operation": "insert",
                "name": "UsrRelatedDetail",
                "values": {
                    "itemType": this.Terrasoft.ViewItemType.DETAIL
                },
                "parentName": "GeneralInfoTab",
                "propertyName": "items"
            }
        ]/**SCHEMA_DIFF*/,
        methods: {
            getGlbDetailFilter: function() {
                var filterGroup = new this.Terrasoft.createFilterGroup();
                return filterGroup;
            }
        }
    };
});

Result:

Like 0

Like

Share

2 comments
Federico Buffa
19:09 Nov 02, 2020

Hello Tatiana,

This is still working in the last versions of creatio?

 

Roman Rak
16:37 Nov 03, 2020

Hello Federico,

 

Thank you for your interest!

 

There were implemented some updates and for now, the code looks like it's described below:

 

Main detail code

define("UsrMasterDetail", [], function() {
    return {
        entitySchemaName: "Country",
        messages: {
            "RelatedDetailUpdateFilter": {
                mode: this.Terrasoft.MessageMode.PTP,
                direction: this.Terrasoft.MessageDirectionType.PUBLISH
            }
        },
        methods: {
            onActiveRowChange: function() {
                var activeRow = this.get("ActiveRow");
                var masterDetailRecordId = typeof activeRow === "object" ? activeRow && activeRow.value : activeRow;
                var detailId = this.sandbox.id.replace(this.name, "MasterDetailRecordId");
                detailId = detailId.replace(this.entitySchemaName, "");
                this.sandbox.publish("RelatedDetailUpdateFilter", masterDetailRecordId, [detailId, this.sandbox.id]);
                this.callParent(arguments);
            }
        }
    };
});

 

Related detail code

define("UsrRelatedDetail", [], function() {
    return {
        entitySchemaName: "City",
        messages: {
            "RelatedDetailUpdateFilter": {
                mode: this.Terrasoft.MessageMode.PTP,
                direction: this.Terrasoft.MessageDirectionType.SUBSCRIBE
            }
        },
        attributes: {
            "MasterDetailRecordId": {
                "dataValueType": this.Terrasoft.DataValueType.GUID
            }
        },
        methods: {
            subscribeSandboxEvents: function() {
                this.callParent(arguments);
                var detailId = this.sandbox.id.replace(this.name, "MasterDetailRecordId");
                detailId = detailId.replace(this.entitySchemaName, "");
                this.sandbox.subscribe("RelatedDetailUpdateFilter", function(masterDetailRecordId) {
                    this.set("MasterDetailRecordId", masterDetailRecordId);
                    this.setFilterByMasterRecord(masterDetailRecordId);
                    this.reloadGridData();
                }, this, [detailId]);
            },
            loadGridData: function() {
                if (this.get("MasterDetailRecordId")) {
                    this.callParent(arguments);
                } else {
                    this.onGridDataLoaded({success: true});
                }
            },
            setFilterByMasterRecord: function(masterDetailRecordId) {
                var filters = this.get("Filter");
                filters.removeByKey("FilterByMasterDetail");
                if (masterDetailRecordId) {
                    filters.add("FilterByMasterDetail", this.Terrasoft.createColumnFilterWithParameter(
                        this.Terrasoft.ComparisonType.EQUAL, "Country", masterDetailRecordId));
                }
            }
        }
    };
});

 

Insert details into the page

define("ContactPageV2", [], function() {
    return {
        entitySchemaName: "Contact",
        details: /**SCHEMA_DETAILS*/{
            "UsrMasterDetail": {
                "schemaName": "UsrMasterDetail",
                "filterMethod": "getGlbDetailFilter"
            },
            "UsrRelatedDetail": {
                "schemaName": "UsrRelatedDetail",
                "filterMethod": "getGlbDetailFilter"
            }
        }/**SCHEMA_DETAILS*/,
        diff: /**SCHEMA_DIFF*/[
            {
                "operation": "insert",
                "name": "UsrMasterDetail",
                "values": {
                    "itemType": this.Terrasoft.ViewItemType.DETAIL
                },
                "parentName": "GeneralInfoTab",
                "propertyName": "items"
            },
            {
                "operation": "insert",
                "name": "UsrRelatedDetail",
                "values": {
                    "itemType": this.Terrasoft.ViewItemType.DETAIL
                },
                "parentName": "GeneralInfoTab",
                "propertyName": "items"
            }
        ]/**SCHEMA_DIFF*/,
        methods: {
            getGlbDetailFilter: function() {
                var filterGroup = new this.Terrasoft.createFilterGroup();
                return filterGroup;
            }
        }
    };
});

 

The result will be the same:

 

Also before providing any changes in schemas we suggest to save original schemas as backups.

 

Best regards,

Roman

Show all comments
SDK
support
Q&A
7.x
How to get a list of the lookup IDs from the interface
Tatiana Rogova
03:35 Sep 13, 2018

Question

How to get a list of the lookup IDs from the interface

Answer

1. Open your entity (Custom package)



2. Select that lookup, that you want to get values from. Copy its Lookup entity name.



3. Paste the Lookup name into the configuration search bar and press Enter. Copy the name of the schema with lookups caption.



4. Paste the lookup name from the step 3 instead of “SchemaName” in this code:

select = Ext.create("Terrasoft.EntitySchemaQuery", {
    rootSchemaName: "SchemaName"
});
select.addMacrosColumn(Terrasoft.QueryMacrosType.PRIMARY_COLUMN, "Id");
select.addColumn("Name");
select.execute(function(response) {
    if (response.success) {
        if (response.collection.getCount() > 0) {
            console.log("Id | Name");
            response.collection.each(function(career) {
                console.log(career.get("Id")+ " | " + career.get("Name"));
            });
        }
    }
});



5. Go to some users page with Chrome browser, open there a developing tools panel (F12 for Chrome) and select a Console.



6. Paste the code into the console and wait a few seconds for the response. You’ll get a response at the console below.

 

 

 

Like 0

Like

Share

0 comments
Show all comments
SDK
support
cases
Generate printable and send it as attachment by email
Tatiana Rogova
02:19 Sep 12, 2018

Case description:

We want to generate printable and send it as attachment by email.

Algorithm of realization:

    1. You should create new business process.

    2. Add "Add data" which will create new activity with values:

      a. Category - Email (lookup value)

      b. Type - Email (lookup value)

      c. From

      d. To

      e. Subject



       

    3. Add "Script task" that will create ActivityFile entity and to generate print form:

      Important: Uncheck "For interpreted process" in all blocks "Script task" that describes in this tutorial

      Content of following script task:

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

      PrintableId - Id of your printable from "Printable" lookup

      ObjectId - Id of object for which we will generate printable

      ConvertToPdf (bool) - if false than will generate printable with type .docx else .pdf

      AddActivityUserTask.RecordId - Id of "Add activity" block that we added above

      AttachmentType - value "File" from lookup "Attachment Type"

      "ExamplePrintable.docx" - name of generated file

      Important: you should add type of file (.docx or .pdf). It depends on bool argument when you generate printable by using "GenerateMSWordReport"

      report.Data - generated printable

    4. Add "Script task" that will send email with created attachment:



      Uncheck "For interpreted process"

      Add next usings for process: Terrasoft.Mail, Terrasoft.Mail.Sender, Terrasoft.Core.Factories:

    5. Add following content:
var activityId = AddActivityUserTask.RecordId;
var emailClientFactory = ClassFactory.Get<EmailClientFactory>(new ConstructorArgument("userConnection", UserConnection));
var activityEmailSender = new ActivityEmailSender(emailClientFactory, UserConnection);
activityEmailSender.Send(activityId);
return true;


AddActivityUserTask.RecordId - Id of added email activity from "Add email activity" block

 

Example:

I need to generate printable and send it as attachment by email when status of contract was changed on signed

  1. I created business process and add next parameters

MailSender - value from lookup "Mailbox synchronization settings". (Values in this lookup becomes allow when you sign in in BPMonline by your mail account)

Printable Id - Id of printable from lookup "Printable" which i want to use

      2. Added signal "Contact signed" which start business process when Status becomes "Signed"

      3. Added "Formula" block "Set signed contract id" that sets "Signed contract id" parameter on Id of contact that was signed

      4. Added "Read data" that gives parameter "MailSender" and returns string value "Sender's email" (it uses for sending email)

      5. Added "Read data" that gives parameter "Printable Id" and returns columns: Convert to PDF (bool) and Title of printable

      6. Added "Formula" block "Set ConvertToPdf" that sets "Convert To Pdf" parameter on bool value from "Read Printable"

      7. Added "Formula" block "Set File Name" that sets "File name" parameter on Text value which is formed by "Title" and "Convert to pdf" value (bool) for current record from lookup "Printable"

Formula value:

[#Read Printable.First item of resulting collection.Title#] + ([#Convert To Pdf#] ? ".pdf" : ".docx")

      8. Added "Add data" block "AddActivityUserTask" that create email activity by using added parameters

      9. Added "Generate print form" script task with following content:

var reportService = new Terrasoft.Configuration.ReportService.ReportService(UserConnection);
Terrasoft.Configuration.ReportService.ReportData report = reportService.GenerateMSWordReport(
    (PrintableId.ToString()), SignedContractId.ToString(), ConvertToPdf);
var entity = UserConnection.EntitySchemaManager.GetInstanceByName("ActivityFile");
var fileEntity = entity.CreateEntity(UserConnection);
fileEntity.SetDefColumnValues();
fileEntity.SetColumnValue("ActivityId", AddActivityUserTask.RecordId);
fileEntity.SetColumnValue("TypeId", AttachmentTypeId);
fileEntity.SetColumnValue("Name", FileName.ToString());
fileEntity.SetColumnValue("Data", report.Data);
fileEntity.Save();
return true;

      10. Added "Send email" script task with following content:

var activityId = AddActivityUserTask.RecordId;
var emailClientFactory = ClassFactory.Get<EmailClientFactory>(new ConstructorArgument("userConnection", UserConnection));
var activityEmailSender = new ActivityEmailSender(emailClientFactory, UserConnection);
activityEmailSender.Send(activityId);
return true;

The final business process:

MD file of business process for import (Version 7.10.2) is attached.

Like 0

Like

Share

39 comments
Fulgen Ninofranco
14:26 Sep 09, 2020

Hi,

 

How about instead of generating a word printable(GenerateMSWordReport()) we will generate a FastReport, what would be the method we need to call?

Norton Lingard
15:05 Sep 10, 2020

Fulgen Ninofranco,

 

In order to generate a FastReport report please call the “CreateReport” method from the “FastReportService” service. You can find the source code of this service in the configuration.

 

Best regards,

Norton

Fulgen Ninofranco
14:41 Sep 13, 2020

Norton Lingard,

 

Thank you so much for your reply. on my script task i have this code below:

 

var reportService = new FastReportService(UserConnection);

var result = reportService.CreateReport(reportTemplateId, reportCaption, reportSchemaName, reportFilters);

 

Please note that I am passing correct values on the parameters, same value I am getting when generating my fastReport on section page.

 

 

But upon calling CreateReport method it is returning Internal Server Error. Please suggest, or show me the correct way please.

Fulgen Ninofranco
14:05 Sep 14, 2020

Hi Norton Lingard, any update please?

Norton Lingard
21:20 Sep 14, 2020

Fulgen Ninofranco,

 

Unfortunately, the provided way of generating a FastReport report is not correct. I tested it on my local instance and got the same error.

 

Therefore, I implemented another approach. Please find the example of the script task that generates the FastReport report and adds it to the Activity below:

 

Terrasoft.Configuration.ReportService.ReportData report = new Terrasoft.Configuration.ReportService.ReportData(); 

string reportSchemaName = "Contact";

Guid reportTemplateId = new Guid ("c4901c9f-3242-4b5e-9662-3c1970cd4505"); //id of printable

var reportFilters = "{\"items\":{\"e4e66f27-83af-4d2f-90fe-4bef3c91d07d\":{\"filterType\":4,\"comparisonType\":3,\"isEnabled\":true,\"trimDateTimeParameterToDate\":false,\"leftExpression\":{\"expressionType\":0,\"columnPath\":\"Id\"},\"rightExpressions\":[{\"expressionType\":2,\"parameter\":{\"dataValueType\":1,\"value\":\"c4ed336c-3e9b-40fe-8b82-5632476472b4\"}}]}},\"logicalOperation\":0,\"isEnabled\":true,\"filterType\":6}";



var reportParameters = new Dictionary<string, object> {

                    ["EsqFilters"] = new Dictionary<string, Filters> {

                    [reportSchemaName] = JsonConvert.DeserializeObject<Filters>(reportFilters)

                    }

                };

IReportTemplateProvider reportTemplateProvider = new FastReportTemplateProvider(UserConnection);;

IDataSourceBuilderResolver dataSourceBuilderResolver = new FastReportDataSourceBuilderResolver(UserConnection);;

var CustomCreateReportGenerator = new ReportGenerator(reportTemplateProvider, dataSourceBuilderResolver);

    

var reportGenerator = CustomCreateReportGenerator;

var task = reportGenerator.Generate(reportTemplateId, reportParameters, ReportFormat.Pdf);



var reportBytes = task.Result;



var reportData = new ReportData(); 



reportData.Data = reportBytes; 

reportData.Format = "docs";

reportData.Caption = "Test";



var entity = UserConnection.EntitySchemaManager.GetInstanceByName("ActivityFile");

var fileEntity = entity.CreateEntity(UserConnection);

fileEntity.SetDefColumnValues();

fileEntity.SetColumnValue("ActivityId", AddActivityUserTask.RecordId);

fileEntity.SetColumnValue("TypeId", AttachmentTypeId);

fileEntity.SetColumnValue("Name", FileName.ToString());

fileEntity.SetColumnValue("Data", reportBytes);

fileEntity.Save();



return true;



You can see how the reportFilters is formed if you generate FastReportManually and see how the parameters are passed to CreateReport requests. You can read the necessary Id's (red can be replaced with any valid Guid and green is an Id of the record) and insert them into reportFilters string. FileName is the name of the file, e.g. "Test.pdf".



Here are libraries that I used in the script task (some of them may not be necessary needed for the script and maybe removed) :



Terrasoft.Mail

Terrasoft.Mail.Sender

Terrasoft.Core.Factories

Terrasoft.Configuration

Terrasoft.Nui.ServiceModel.DataContract

Terrasoft.Reporting.Abstractions.Data

Terrasoft.Reporting.DataSource.Abstractions

Terrasoft.Reporting.FastReport

Terrasoft.Reporting.FastReport.Abstractions

Terrasoft.Web.Common

Terrasoft.Configuration.Reporting.FastReport

Terrasoft.Configuration.Reporting.FastReportEngine

Terrasoft.Configuration.ReportService

 

Best regards,

Norton

Fulgen Ninofranco
09:48 Sep 20, 2020

Norton Lingard,

 

Thank you Norton, the given solution is working fine.

Julio.Falcon_Nodos
00:46 Feb 25, 2021

Hello Norton, this is Julio Falcón. I'm trying to implement also the Fastreport version, but get an execution error.

 

The code we have in the Scrip Task is

Terrasoft.Configuration.ReportService.ReportData report = new Terrasoft.Configuration.ReportService.ReportData(); 
string reportSchemaName = "Account";
Guid reportTemplateId = new Guid ("8a474ce6-dd1f-4ad9-b7f7-df3026617f56"); //id of printable
var reportFilters = "{\"items\":{\"CustomFilters\":{\"items\":{\"customFilterAccountCategory_Account\":{\"filterType\":1,\"comparisonType\":3,\"isEnabled\":true,\"trimDateTimeParameterToDate\":false,\"leftExpression\":{\"expressionType\":0,\"columnPath\":\"AccountCategory\"},\"rightExpression\":{\"expressionType\":2,\"parameter\":{\"dataValueType\":10,\"value\":\"37ea507c-55e6-df11-971b-001d60e938c6\"}}}},\"logicalOperation\":0,\"isEnabled\":true,\"filterType\":6}},\"logicalOperation\":0,\"isEnabled\":true,\"filterType\":6}";
//"{"items":{"CustomFilters":{"items":{"customFilterAccountCategory_Account":{"filterType":1,"comparisonType":3,"isEnabled":true,"trimDateTimeParameterToDate":false,"leftExpression":{"expressionType":0,"columnPath":"AccountCategory"},"rightExpression":{"expressionType":2,"parameter":{"dataValueType":10,"value":"37ea507c-55e6-df11-971b-001d60e938c6"}}}},"logicalOperation":0,"isEnabled":true,"filterType":6}},"logicalOperation":0,"isEnabled":true,"filterType":6}";
               //"{\"items\":{\"e4e66f27-83af-4d2f-90fe-4bef3c91d07d\":{\"filterType\":4,\"comparisonType\":3,\"isEnabled\":true,\"trimDateTimeParameterToDate\":false,\"leftExpression\":{\"expressionType\":0,\"columnPath\":\"Id\"},\"rightExpressions\":[{\"expressionType\":2,\"parameter\":{\"dataValueType\":1,\"value\":\"c4ed336c-3e9b-40fe-8b82-5632476472b4\"}}]}},\"logicalOperation\":0,\"isEnabled\":true,\"filterType\":6}";
 
var reportParameters = new Dictionary&lt;string, object&gt; {
                    ["EsqFilters"] = new Dictionary&lt;string, Filters&gt; {
                    [reportSchemaName] = JsonConvert.DeserializeObject&lt;Filters&gt;(reportFilters)
                    }
                };
IReportTemplateProvider reportTemplateProvider = new FastReportTemplateProvider(UserConnection);
IDataSourceBuilderResolver dataSourceBuilderResolver = new FastReportDataSourceBuilderResolver(UserConnection);
var CustomCreateReportGenerator = new ReportGenerator(reportTemplateProvider, dataSourceBuilderResolver);
 
var reportGenerator = CustomCreateReportGenerator;
var task = reportGenerator.Generate(reportTemplateId, reportParameters, ReportFormat.Pdf);
 
var reportBytes = task.Result;
 
var reportData = new ReportData(); 
 
reportData.Data = reportBytes; 
reportData.Format = "docs";
reportData.Caption = "Test";
 
var entity = UserConnection.EntitySchemaManager.GetInstanceByName("ActivityFile");
var fileEntity = entity.CreateEntity(UserConnection);
fileEntity.SetDefColumnValues();
fileEntity.SetColumnValue("ActivityId", Get&lt;Guid&gt;("EmailActivityId") ); //AddActivityUserTask.RecordId);
fileEntity.SetColumnValue("TypeId", new Guid("529BC2F8-0EE0-DF11-971B-001D60E938C6"));//, AttachmentTypeId);
fileEntity.SetColumnValue("Name", Get&lt;string&gt;("PrintableTitle") ); //FileName.ToString());
fileEntity.SetColumnValue("Data", reportBytes);
fileEntity.Save();
 
return true;

The compilation works, but when I run it from another process who is on Accounts, because the report is from Accounts get this error.

 

What could be wrong?

System.AggregateException: One or more errors occurred. ---&gt; System.AggregateException: One or more errors occurred. ---&gt; System.ArgumentNullException: Value cannot be null.
Parameter name: g
   at System.Guid..ctor(String g)
   at Terrasoft.Configuration.AprFastReportDataSourceDataProvider.GetData(UserConnection userConnection, IReadOnlyDictionary`2 parameters)
   at Terrasoft.Configuration.Reporting.FastReportEngine.Custom.CustomDataProvider.&lt;GetDataSourceData&gt;d__4.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.Configuration.Reporting.FastReportEngine.Custom.CustomDataProvider.&lt;GetData&gt;d__5.MoveNext()
   --- End of inner exception stack trace ---
   at System.Threading.Tasks.Task`1.GetResultCore(Boolean waitCompletionNotification)
   at Terrasoft.Reporting.FastReport.Connection.ReportDataSourceConnection.FillTableData(DataTable table, String selectCommand, CommandParameterCollection parameters)
   at FastReport.Data.DataConnectionBase.FillTable(TableDataSource source)
   at FastReport.Data.TableDataSource.LoadData(ArrayList rows)
   at FastReport.Data.DataSourceBase.Init(Relation relation, String filter, SortCollection sort, Boolean useAllParentRows)
   at FastReport.Data.DataSourceBase.get_Item(Column column)
   at FastReport.Report.GetColumnValue(String complexName, Boolean convertNull)
   at FastReport.PictureObject.GetData()
   at FastReport.BandBase.GetData()
   at FastReport.Engine.ReportEngine.PrepareBand(BandBase band, Boolean getData)
   at FastReport.Engine.ReportEngine.ShowBandToPreparedPages(BandBase band, Boolean getData)
   at FastReport.Engine.ReportEngine.ShowBand(BandBase band, Boolean getData)
   at FastReport.Engine.ReportEngine.ShowBand(BandBase band)
   at FastReport.Engine.ReportEngine.StartFirstPage()
   at FastReport.Engine.ReportEngine.RunReportPage(ReportPage page)
   at FastReport.Engine.ReportEngine.RunReportPages()
   at FastReport.Engine.ReportEngine.RunReportPages(ReportPage page)
   at FastReport.Engine.ReportEngine.Run(Boolean runDialogs, Boolean append, Boolean resetDataState, ReportPage page)
   at FastReport.Report.Prepare(Boolean append)
   at Terrasoft.Reporting.FastReport.ReportGenerator.&lt;Generate&gt;d__6.MoveNext()
   --- End of inner exception stack trace ---
   at System.Threading.Tasks.Task`1.GetResultCore(Boolean waitCompletionNotification)
   at Terrasoft.Core.Process.UsrEnviarReporteEjecutivo_3052417MethodsWrapper.AttachPrintableExecute(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)
---&gt; (Inner Exception #0) System.AggregateException: One or more errors occurred. ---&gt; System.ArgumentNullException: Value cannot be null.
Parameter name: g
   at System.Guid..ctor(String g)
   at Terrasoft.Configuration.AprFastReportDataSourceDataProvider.GetData(UserConnection userConnection, IReadOnlyDictionary`2 parameters)
   at Terrasoft.Configuration.Reporting.FastReportEngine.Custom.CustomDataProvider.&lt;GetDataSourceData&gt;d__4.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.Configuration.Reporting.FastReportEngine.Custom.CustomDataProvider.&lt;GetData&gt;d__5.MoveNext()
   --- End of inner exception stack trace ---
   at System.Threading.Tasks.Task`1.GetResultCore(Boolean waitCompletionNotification)
   at Terrasoft.Reporting.FastReport.Connection.ReportDataSourceConnection.FillTableData(DataTable table, String selectCommand, CommandParameterCollection parameters)
   at FastReport.Data.DataConnectionBase.FillTable(TableDataSource source)
   at FastReport.Data.TableDataSource.LoadData(ArrayList rows)
   at FastReport.Data.DataSourceBase.Init(Relation relation, String filter, SortCollection sort, Boolean useAllParentRows)
   at FastReport.Data.DataSourceBase.get_Item(Column column)
   at FastReport.Report.GetColumnValue(String complexName, Boolean convertNull)
   at FastReport.PictureObject.GetData()
   at FastReport.BandBase.GetData()
   at FastReport.Engine.ReportEngine.PrepareBand(BandBase band, Boolean getData)
   at FastReport.Engine.ReportEngine.ShowBandToPreparedPages(BandBase band, Boolean getData)
   at FastReport.Engine.ReportEngine.ShowBand(BandBase band, Boolean getData)
   at FastReport.Engine.ReportEngine.ShowBand(BandBase band)
   at FastReport.Engine.ReportEngine.StartFirstPage()
   at FastReport.Engine.ReportEngine.RunReportPage(ReportPage page)
   at FastReport.Engine.ReportEngine.RunReportPages()
   at FastReport.Engine.ReportEngine.RunReportPages(ReportPage page)
   at FastReport.Engine.ReportEngine.Run(Boolean runDialogs, Boolean append, Boolean resetDataState, ReportPage page)
   at FastReport.Report.Prepare(Boolean append)
   at Terrasoft.Reporting.FastReport.ReportGenerator.&lt;Generate&gt;d__6.MoveNext()
---&gt; (Inner Exception #0) System.ArgumentNullException: Value cannot be null.
Parameter name: g
   at System.Guid..ctor(String g)
   at Terrasoft.Configuration.AprFastReportDataSourceDataProvider.GetData(UserConnection userConnection, IReadOnlyDictionary`2 parameters)
   at Terrasoft.Configuration.Reporting.FastReportEngine.Custom.CustomDataProvider.&lt;GetDataSourceData&gt;d__4.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.Configuration.Reporting.FastReportEngine.Custom.CustomDataProvider.&lt;GetData&gt;d__5.MoveNext()&lt;---
&lt;---

 

Oleg Drobina
16:52 Feb 25, 2021

Julio.Falcon_Nodos,

Hello,

 

Thank you for sharing the code! I've used it when performing tests on my side and the email with the attachment was generated correctly:

The error message "Value cannot be null. Parameter name: g" usually occurs in case there is a problem with access rights to some object with which the process interacts. In our case these objects are "ActivityFile", "FastReportTemplate", "Account" and "Activity". Please double-check that your user who runs the process has rigths to read data from "Accounts" and "FastReportTemplate", operation permissions to add data to "ActivityFile" and "Activity" and read access rights to "ActivityFile" and "Activity".

 

Best regards,

Oscar

Julio.Falcon_Nodos
19:45 Feb 25, 2021

Thanks Oscar, in this case I'm Supervisor, System Administrator

Julio.Falcon_Nodos
19:47 Feb 25, 2021

I have no this problem, becasue have permissions to everything, what else could be?

Oleg Drobina
19:53 Feb 25, 2021

Julio.Falcon_Nodos,

 

The only thing left is to compare all the settings of your process with all the settings of mine below:

The list is:

Terrasoft.Mail
Terrasoft.Mail.Sender
Terrasoft.Core.Factories
Terrasoft.Configuration
Terrasoft.Nui.ServiceModel.DataContract
Terrasoft.Reporting.Abstractions.Data
Terrasoft.Reporting.DataSource.Abstractions
Terrasoft.Reporting.FastReport
Terrasoft.Reporting.FastReport.Abstractions
Terrasoft.Web.Common
Terrasoft.Configuration.Reporting.FastReport
Terrasoft.Configuration.Reporting.FastReportEngine
Terrasoft.Configuration.ReportService

Then parameters are:

The code is absolutely similar to yours:

Terrasoft.Configuration.ReportService.ReportData report = new Terrasoft.Configuration.ReportService.ReportData(); 
string reportSchemaName = "Account";
Guid reportTemplateId = new Guid ("7D12ED1B-5807-BA49-6E22-668836CF0BD4"); //id of printable
var reportFilters = "{\"items\":{\"CustomFilters\":{\"items\":{\"customFilterAccountCategory_Account\":{\"filterType\":1,\"comparisonType\":3,\"isEnabled\":true,\"trimDateTimeParameterToDate\":false,\"leftExpression\":{\"expressionType\":0,\"columnPath\":\"AccountCategory\"},\"rightExpression\":{\"expressionType\":2,\"parameter\":{\"dataValueType\":10,\"value\":\"37ea507c-55e6-df11-971b-001d60e938c6\"}}}},\"logicalOperation\":0,\"isEnabled\":true,\"filterType\":6}},\"logicalOperation\":0,\"isEnabled\":true,\"filterType\":6}";
//"{"items":{"CustomFilters":{"items":{"customFilterAccountCategory_Account":{"filterType":1,"comparisonType":3,"isEnabled":true,"trimDateTimeParameterToDate":false,"leftExpression":{"expressionType":0,"columnPath":"AccountCategory"},"rightExpression":{"expressionType":2,"parameter":{"dataValueType":10,"value":"37ea507c-55e6-df11-971b-001d60e938c6"}}}},"logicalOperation":0,"isEnabled":true,"filterType":6}},"logicalOperation":0,"isEnabled":true,"filterType":6}";
               //"{\"items\":{\"e4e66f27-83af-4d2f-90fe-4bef3c91d07d\":{\"filterType\":4,\"comparisonType\":3,\"isEnabled\":true,\"trimDateTimeParameterToDate\":false,\"leftExpression\":{\"expressionType\":0,\"columnPath\":\"Id\"},\"rightExpressions\":[{\"expressionType\":2,\"parameter\":{\"dataValueType\":1,\"value\":\"c4ed336c-3e9b-40fe-8b82-5632476472b4\"}}]}},\"logicalOperation\":0,\"isEnabled\":true,\"filterType\":6}";
 
var reportParameters = new Dictionary&lt;string, object&gt; {
                    ["EsqFilters"] = new Dictionary&lt;string, Filters&gt; {
                    [reportSchemaName] = JsonConvert.DeserializeObject&lt;Filters&gt;(reportFilters)
                    }
                };
IReportTemplateProvider reportTemplateProvider = new FastReportTemplateProvider(UserConnection);
IDataSourceBuilderResolver dataSourceBuilderResolver = new FastReportDataSourceBuilderResolver(UserConnection);
var CustomCreateReportGenerator = new ReportGenerator(reportTemplateProvider, dataSourceBuilderResolver);
 
var reportGenerator = CustomCreateReportGenerator;
var task = reportGenerator.Generate(reportTemplateId, reportParameters, ReportFormat.Pdf);
 
var reportBytes = task.Result;
 
var reportData = new ReportData(); 
 
reportData.Data = reportBytes; 
reportData.Format = "docs";
reportData.Caption = "Test";
 
var entity = UserConnection.EntitySchemaManager.GetInstanceByName("ActivityFile");
var fileEntity = entity.CreateEntity(UserConnection);
fileEntity.SetDefColumnValues();
fileEntity.SetColumnValue("ActivityId", Get&lt;Guid&gt;("EmailActivityId") ); //AddActivityUserTask.RecordId);
fileEntity.SetColumnValue("TypeId", new Guid("529BC2F8-0EE0-DF11-971B-001D60E938C6"));//, AttachmentTypeId);
fileEntity.SetColumnValue("Name", Get&lt;string&gt;("PrintableTitle") ); //FileName.ToString());
fileEntity.SetColumnValue("Data", reportBytes);
fileEntity.Save();
 
return true;

And the data source code for the accounts fast report:

namespace Terrasoft.Configuration
{
    using System;
    using System.Collections.Generic;
    using System.Collections.ObjectModel;
    using System.Linq;
    using System.Threading.Tasks;
    using Terrasoft.Common;
    using Terrasoft.Configuration.Reporting.FastReport;
    using Terrasoft.Core;
    using Terrasoft.Core.Entities;
    using Terrasoft.Core.Factories;
    using Terrasoft.Nui.ServiceModel.Extensions;
    using EntitySchema = Terrasoft.Core.Entities.EntitySchema;
    using EntitySchemaColumn = Terrasoft.Core.Entities.EntitySchemaColumn;
 
 
    [DefaultBinding(typeof(IFastReportDataSourceDataProvider), Name = "AccountDataProvider")]
    public class AccountDataProvider : IFastReportDataSourceDataProvider
    {
 
        private Guid _entitySchemaUId = new Guid("25D7C1AB-1DE0-4501-B402-02E0E5A72D6E");
 
        private readonly string _resourceManagerName = "UsrAccountDataSource";
        private readonly string[] _localizableStringNames = new[] {
            "ReportTitle",
            "NameLabel",
            "TypeLabel"
        };
 
 
        private IEnumerable&lt;IReadOnlyDictionary&lt;string, object&gt;&gt; GetAccountData(
            UserConnection userConnection,
            Guid entitySchemaUId,
            IEntitySchemaQueryFilterItem filter) {
 
                var entitySchema = userConnection.EntitySchemaManager.GetInstanceByUId(entitySchemaUId);
                EntitySchemaQuery query = new EntitySchemaQuery(entitySchema);
                query.AddColumn("Name");
                query.AddColumn("Type");
                query.Filters.Add(filter);
 
                var accounts = query.GetEntityCollection(userConnection);
                var accountsCollection = new Collection&lt;Dictionary&lt;string, object&gt;&gt;();
 
                foreach (var entity in accounts)
                {
                    accountsCollection.Add(new Dictionary&lt;string, object&gt; {
                        ["Name"] = entity.GetTypedColumnValue&lt;string&gt;("Name"),
                        ["Type"] = entity.GetTypedColumnValue&lt;string&gt;("Type")
                    });
                }
                return accountsCollection;
        }
 
        private IEnumerable&lt;IReadOnlyDictionary&lt;string, object&gt;&gt; GetLocalizableStrings(UserConnection userConnection) {
            var localizableStrings = _localizableStringNames.ToDictionary(
                x =&gt; x,
                x =&gt; (object)(new LocalizableString(userConnection.ResourceStorage, _resourceManagerName, $"LocalizableStrings.{x}.Value")).Value);
            return new[] { localizableStrings };
        }
 
        private IEntitySchemaQueryFilterItem ExtractFilterFromParameters(UserConnection userConnection, Guid entitySchemaUId,
                IReadOnlyDictionary&lt;string, object&gt; parameters) {
            var managerItem = userConnection.EntitySchemaManager.GetItemByUId(entitySchemaUId);
            return parameters.ExtractEsqFilterFromReportParameters(userConnection, managerItem.Name) ?? throw new Exception();
        } 
 
        public Task&lt;ReportDataDictionary&gt; GetData(UserConnection userConnection, IReadOnlyDictionary&lt;string, object&gt; parameters) {
            var filter = ExtractFilterFromParameters(userConnection, _entitySchemaUId, parameters);
            var result = new ReportDataDictionary {
                ["AccountData"] = GetAccountData(userConnection, _entitySchemaUId, filter),
                ["LocalizableStrings"] = GetLocalizableStrings(userConnection)
            };
            return Task.FromResult(result);
        }
    }
}

Please compare it to the settings of your business process as well.

 

Best regards,

Oscar

Julio.Falcon_Nodos
19:53 Feb 25, 2021

Oscar, here you can see what I'm doing, check permissions and how get the error executing the code above, please help me https://share.vidyard.com/watch/zbDdhn2PAtTDyGcgrvR1vq?

Julio.Falcon_Nodos
20:17 Feb 25, 2021

In the Usings I have the same, except also have System.IO

 

Julio.Falcon_Nodos
20:21 Feb 25, 2021

The code of ScripTask is the same except the Guid for reportTemplateId and reportFilters

Julio.Falcon_Nodos
20:34 Feb 25, 2021

and regarding the data source code for the accounts fast report, I'm using https://marketplace.terrasoft.ru/app/no-code-reports-creatio

Julio.Falcon_Nodos
16:19 Mar 02, 2021

Oscar Dylan,

Hi @Oscar, please could you help me?

 

Thanks in advance

Oleg Drobina
16:23 Mar 02, 2021

Julio.Falcon_Nodos,

 

Hello,

 

Since you are using the marketplace app you need to contact a partner who is responsible for the app (the email is support@crm-bpm.ru). Please ask them to take a look at the problem with generating a fast report in the system.

 

Best regards,

Oscar

Julio.Falcon_Nodos
15:47 Mar 03, 2021

Oscar Dylan,

Oscar, the generation of the report is working, what i need to do is could download it to share with customers by mail, in my case it doesn't works also with the Creatio Standard FastReports

Oleg Drobina
15:51 Mar 03, 2021

Julio.Falcon_Nodos,

 

Then you need to double-check the business process settings and compare them to the business process settings of my business process that is working in my local app and generates a printable and add it as an attachment to an email. Also you need to try generating the source code for all items and compiling all items in the system.

 

Best regards,

Oscar

Julio.Falcon_Nodos
04:33 Mar 12, 2021

Hi Oscar

 

It doesn't works, sure it must be some vey simple, but I don's see where, so I enabled debug the process & Creatio and in Chrome there no any error...

 

I simplified the process, so it's: 

 

In fact I just need id of KB Article to attach the file and:

  • reportTemplateId
  • reportFilters

And the code to attach the FastReport File is

Terrasoft.Configuration.ReportService.ReportData report = new Terrasoft.Configuration.ReportService.ReportData(); 
string reportSchemaName = "Account";
 
// id of printable
Guid reportTemplateId = new Guid("b7abe9a9-bd14-4c7e-857b-0138c9b82462");
 
// reportFilters of Printable
var reportFilters = "{\"items\":{\"23009387-7361-424b-a9af-0c29ec890696\":{\"filterType\":4,\"comparisonType\":3,\"isEnabled\":true,\"trimDateTimeParameterToDate\":false,\"leftExpression\":{\"expressionType\":0,\"columnPath\":\"Id\"},\"rightExpressions\":[{\"expressionType\":2,\"parameter\":{\"dataValueType\":1,\"value\":\"7bf558b3-1fd0-4cef-8df5-8e8816b12b54\"}}]}},\"logicalOperation\":0,\"isEnabled\":true,\"filterType\":6}";
 
var reportParameters = new Dictionary&lt;string, object&gt; {
                    ["EsqFilters"] = new Dictionary&lt;string, Filters&gt; {
                    [reportSchemaName] = JsonConvert.DeserializeObject&lt;Filters&gt;(reportFilters)
                    }
                };
 
IReportTemplateProvider reportTemplateProvider = new FastReportTemplateProvider(UserConnection);
IDataSourceBuilderResolver dataSourceBuilderResolver = new FastReportDataSourceBuilderResolver(UserConnection);
var CustomCreateReportGenerator = new ReportGenerator(reportTemplateProvider, dataSourceBuilderResolver);
 
var reportGenerator = CustomCreateReportGenerator;
var task = reportGenerator.Generate( reportTemplateId, reportParameters, ReportFormat.Pdf );
 
var reportBytes = task.Result;
 
var reportData = new ReportData(); 
 
reportData.Data = reportBytes; 
reportData.Format = "docs"; 
reportData.Caption = "Test";
 
// Se conecta al KnowledgeBase
var entity = UserConnection.EntitySchemaManager.GetInstanceByName("KnowledgeBaseFile");
 
// Crea nuevo registro
var fileEntity = entity.CreateEntity(UserConnection);
fileEntity.SetDefColumnValues();
fileEntity.SetColumnValue( "KnowledgeBaseId", Get&lt;Guid&gt;("NewKnowledgeBaseId") ); 	
fileEntity.SetColumnValue( "TypeId", new Guid("529bc2f8-0ee0-df11-971b-001d60e938c6"));
fileEntity.SetColumnValue( "Name", "Informe Ejecutivo Clientes VIP" ); 				
fileEntity.SetColumnValue( "Data", reportBytes );
fileEntity.Save();
 
return true;

and get exactly the same error I get on the most complex process:

System.AggregateException: One or more errors occurred. ---&gt; System.AggregateException: One or more errors occurred. ---&gt; System.ArgumentNullException: Value cannot be null.
Parameter name: g
   at System.Guid..ctor(String g)
   at Terrasoft.Configuration.AprFastReportDataSourceDataProvider.GetData(UserConnection userConnection, IReadOnlyDictionary`2 parameters)
   at Terrasoft.Configuration.Reporting.FastReportEngine.Custom.CustomDataProvider.&lt;GetDataSourceData&gt;d__4.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.Configuration.Reporting.FastReportEngine.Custom.CustomDataProvider.&lt;GetData&gt;d__5.MoveNext()
   --- End of inner exception stack trace ---
   at System.Threading.Tasks.Task`1.GetResultCore(Boolean waitCompletionNotification)
   at Terrasoft.Reporting.FastReport.Connection.ReportDataSourceConnection.FillTableData(DataTable table, String selectCommand, CommandParameterCollection parameters)
   at FastReport.Data.DataConnectionBase.FillTable(TableDataSource source)
   at FastReport.Data.TableDataSource.LoadData(ArrayList rows)
   at FastReport.Data.DataSourceBase.Init(Relation relation, String filter, SortCollection sort, Boolean useAllParentRows)
   at FastReport.Data.DataSourceBase.get_Item(Column column)
   at FastReport.Report.GetColumnValue(String complexName, Boolean convertNull)
   at FastReport.PictureObject.GetData()
   at FastReport.BandBase.GetData()
   at FastReport.Engine.ReportEngine.PrepareBand(BandBase band, Boolean getData)
   at FastReport.Engine.ReportEngine.ShowBandToPreparedPages(BandBase band, Boolean getData)
   at FastReport.Engine.ReportEngine.ShowBand(BandBase band, Boolean getData)
   at FastReport.Engine.ReportEngine.ShowBand(BandBase band)
   at FastReport.Engine.ReportEngine.StartFirstPage()
   at FastReport.Engine.ReportEngine.RunReportPage(ReportPage page)
   at FastReport.Engine.ReportEngine.RunReportPages()
   at FastReport.Engine.ReportEngine.RunReportPages(ReportPage page)
   at FastReport.Engine.ReportEngine.Run(Boolean runDialogs, Boolean append, Boolean resetDataState, ReportPage page)
   at FastReport.Report.Prepare(Boolean append)
   at Terrasoft.Reporting.FastReport.ReportGenerator.&lt;Generate&gt;d__6.MoveNext()
   --- End of inner exception stack trace ---
   at System.Threading.Tasks.Task`1.GetResultCore(Boolean waitCompletionNotification)
   at Terrasoft.Core.Process.UsrEnviarReporteEjecutivo_Simplified_636e5cfMethodsWrapper.ScriptTask1Execute(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)
---&gt; (Inner Exception #0) System.AggregateException: One or more errors occurred. ---&gt; System.ArgumentNullException: Value cannot be null.
Parameter name: g
   at System.Guid..ctor(String g)
   at Terrasoft.Configuration.AprFastReportDataSourceDataProvider.GetData(UserConnection userConnection, IReadOnlyDictionary`2 parameters)
   at Terrasoft.Configuration.Reporting.FastReportEngine.Custom.CustomDataProvider.&lt;GetDataSourceData&gt;d__4.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.Configuration.Reporting.FastReportEngine.Custom.CustomDataProvider.&lt;GetData&gt;d__5.MoveNext()
   --- End of inner exception stack trace ---
   at System.Threading.Tasks.Task`1.GetResultCore(Boolean waitCompletionNotification)
   at Terrasoft.Reporting.FastReport.Connection.ReportDataSourceConnection.FillTableData(DataTable table, String selectCommand, CommandParameterCollection parameters)
   at FastReport.Data.DataConnectionBase.FillTable(TableDataSource source)
   at FastReport.Data.TableDataSource.LoadData(ArrayList rows)
   at FastReport.Data.DataSourceBase.Init(Relation relation, String filter, SortCollection sort, Boolean useAllParentRows)
   at FastReport.Data.DataSourceBase.get_Item(Column column)
   at FastReport.Report.GetColumnValue(String complexName, Boolean convertNull)
   at FastReport.PictureObject.GetData()
   at FastReport.BandBase.GetData()
   at FastReport.Engine.ReportEngine.PrepareBand(BandBase band, Boolean getData)
   at FastReport.Engine.ReportEngine.ShowBandToPreparedPages(BandBase band, Boolean getData)
   at FastReport.Engine.ReportEngine.ShowBand(BandBase band, Boolean getData)
   at FastReport.Engine.ReportEngine.ShowBand(BandBase band)
   at FastReport.Engine.ReportEngine.StartFirstPage()
   at FastReport.Engine.ReportEngine.RunReportPage(ReportPage page)
   at FastReport.Engine.ReportEngine.RunReportPages()
   at FastReport.Engine.ReportEngine.RunReportPages(ReportPage page)
   at FastReport.Engine.ReportEngine.Run(Boolean runDialogs, Boolean append, Boolean resetDataState, ReportPage page)
   at FastReport.Report.Prepare(Boolean append)
   at Terrasoft.Reporting.FastReport.ReportGenerator.&lt;Generate&gt;d__6.MoveNext()
---&gt; (Inner Exception #0) System.ArgumentNullException: Value cannot be null.
Parameter name: g
   at System.Guid..ctor(String g)
   at Terrasoft.Configuration.AprFastReportDataSourceDataProvider.GetData(UserConnection userConnection, IReadOnlyDictionary`2 parameters)
   at Terrasoft.Configuration.Reporting.FastReportEngine.Custom.CustomDataProvider.&lt;GetDataSourceData&gt;d__4.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.Configuration.Reporting.FastReportEngine.Custom.CustomDataProvider.&lt;GetData&gt;d__5.MoveNext()&lt;---
&lt;---

To test I start the process manually and use any account filtering by account name, here is the exported process to, please try yourself or anybody can help me. the exported process is on

 https://1drv.ms/u/s!ApFItzjX7t0uhLog1J00MTBmVljgwg?e=J6gApR

 

Thanks in advance

Julio.Falcon_Nodos
04:44 Mar 12, 2021

If somebody wants to try the code to generate the FastReport and attach to some section files just copy the code above and decode it pasting on  https://emn178.github.io/online-tools/html_decode.html or other site, there are a lot, just wait to found where this code fails. I'm sure it is so simple, because Oscar indicates use this code and works, but mus there some insignificant difference like the typical "0 vs O" :-(

Julio.Falcon_Nodos
05:01 Mar 12, 2021

I compare the code byte by byte and are the same code, just the differences are:

  • id of object where it must attach the file
  • reportTemplateId
  • reportFilters

??? :-(

Julio.Falcon_Nodos
13:57 Mar 12, 2021

Hi Oscar, if you want, I have this on a demo site, I can provide access to you ?

Oleg Drobina
11:35 Mar 15, 2021

Julio.Falcon_Nodos,

 

Hi Julio,

 

Yes please share the demo app and access to it and we will check the printable generation on our side.

 

Best regards,

Oscar

Julio.Falcon_Nodos
13:54 Mar 15, 2021

Oscar Dylan,

Good morning Oscar, I post you an internal message with details, please confirm me if you receive it or send by Email.

 

Thanks

Oleg Drobina
18:09 Mar 15, 2021

Julio.Falcon_Nodos,

Hi Julio,

 

Yes, I received it thank you! And I am now looking into the report settings to see what happens.

 

Best regards,

Oscar

Oleg Drobina
19:30 Mar 15, 2021

Julio.Falcon_Nodos,

 

I've reviewed the demo app and there is something really wrong with the report you are using in the script task. First of all it cannot be found in the UI (I've searched the Id from the script task of your process (Guid reportTemplateId = new Guid("b7abe9a9-bd14-4c7e-857b-0138c9b82462");))

while it can be accessed via a direct link - 

https://paste_your_app_link_here/0/ClientApp/#/Printables/8def0f6d-b075-41dd-bcad-ca660c29f2e2/be729e12-67e7-4e12-9397-4a50010ba5fb

 

Also if you execute this query:

 

select * from "FastReportTemplate"
where "Id" = 'b7abe9a9-bd14-4c7e-857b-0138c9b82462'

You will see that the "Data" column is empty, while it should contain the data of the template:

These are two main "problematic" places that could generate the error. Can you please create a new fast report record, generate a new template for it and use it in the process instead? This should help in generating an attachment in the email.

 

Best regards,

Oscar

Julio.Falcon_Nodos
19:50 Mar 15, 2021

Oscar Dylan,

Hi Oscar if I go to Account section, click on Banco Santander, for example and click on PRINT select the report and review, on the debug console, the Network folder, the execution returns as you can see the report ID is correct and also the filter

{"reportTemplateId":"b7abe9a9-bd14-4c7e-857b-0138c9b82462","reportCaption":"Informe Ejecutivo 01 cuentas VIP","reportSchemaName":"Account","reportFilters":"{\"items\":{\"179f3e78-3e7e-4294-b6d0-c81ee3b8010e\":{\"filterType\":4,\"comparisonType\":3,\"isEnabled\":true,\"trimDateTimeParameterToDate\":false,\"leftExpression\":{\"expressionType\":0,\"columnPath\":\"Id\"},\"rightExpressions\":[{\"expressionType\":2,\"parameter\":{\"dataValueType\":1,\"value\":\"7bf558b3-1fd0-4cef-8df5-8e8816b12b54\"}}]}},\"logicalOperation\":0,\"isEnabled\":true,\"filterType\":6}"}

 

Julio.Falcon_Nodos
19:51 Mar 15, 2021

my mistake, don't consider this

Julio.Falcon_Nodos
19:55 Mar 15, 2021

not applicable

Julio.Falcon_Nodos
20:04 Mar 15, 2021

@Oscar, could be the problem is the report is created using https://marketplace.creatio.com/app/no-code-reports-creatio, but I understand it works like an standard Fastreport

Oleg Drobina
21:22 Mar 15, 2021

Julio.Falcon_Nodos,

 

Yes, I also saw that the report is present on the account edit page, but it cannot be found in the UI of the report setup and this already tells us that there is something wrong with it. Also the "Data" column value for the template is empty that shouldn't happen in case the template contains some data.

 

Julio, can you please recreate the report completely? Also have you reported the problem to support@crm-bpm.ru? 

 

Best regards,

Oscar

Julio.Falcon_Nodos
21:25 Mar 15, 2021

Oscar Dylan,

Thanks Oscar I'm already open a ticket with them, it's 

#SR00000549 

Julio.Falcon_Nodos
21:28 Mar 15, 2021

Oscar Dylan,

Also recreate the report completely using the Marketplace App? The reports created using this app doesn't list on Creatio standard FastReports, in the case of my demo site is there on Studio workplace a Report Section called "Reports setup"

Julio.Falcon_Nodos
21:29 Mar 15, 2021

Julio.Falcon_Nodos,

but the fact is the report is generated manually as usual :-( 

Oleg Drobina
21:35 Mar 15, 2021

Julio.Falcon_Nodos,

 

Yes, the report is generated manually, but the fact that it's not present in the UI and also doesn't have the template data in the database already gives us two questions that the partner needs to take a look at. Also as you said I am more than sure that this issue doesn't occur with regular reports that can be accessed from the fast reports section, am I right?

 

Best regards,

Oscar

Julio.Falcon_Nodos
21:52 Mar 15, 2021

Oscar Dylan,

 

Thanks Oscar, I didn't try with standard reports yet, because tomorrow is the demo of the POC with the customer and I have no time to code the standard way to provide the data.

 

But after the POC I will try, but sure we will need a solution for the guys of Automated Process, because this customer in case we win, need a lot of custom and complicated reports, and we cannot use a lot of hours writing code to create reports in Creatio, the Low code platform... Is in the backlog of Creatio a Low code tool to this?

 

Thanks again

Oleg Drobina
22:50 Mar 15, 2021

Julio.Falcon_Nodos,

 

I agree with you that FastReports are not easy to design and require time to be created and unfortunately I haven't found the problem related to FastReport low-code re-design. Thus I've created one for the product owner who is responsible for custom reports and printables so the FastReports logic could be re-designed in the nearest future (it will be definitely re-designed since the low-code approach becomes the main idea for the Creatio app solutions development). The only working and tested approach that we have for custom reports is Word printables, but they are not as flexible as FastReport templates and logic.

 

Please also let me know once you test a new FastReport and the business process execution with it.

 

Best regards,

Oscar

Julio.Falcon_Nodos
23:01 Mar 15, 2021

Oscar Dylan,

Thanks Oscar,

 

Have a nice week

Show all comments
SDK
support
cases
Add a button on EditPage
Tatiana Rogova
02:32 Sep 06, 2018

Case description:

You need to add a button to the Opportunity edit page.

Algorithm of realization:

  1. Create replacing client schema for your page.
  2. Create localizable string which will contain caption of the button.







    Figure 1. Adding a localizable string

     

  3. Source code of the "OpportunityPageV2" :

    define("OpportunityPageV2", [], function() {
    return {
        entitySchemaName: "Opportunity",
        messages: {
            "SetNewQuoteButtonVisibility": {
                mode: this.Terrasoft.MessageMode.PTP,
                direction: this.Terrasoft.MessageDirectionType.PUBLISH
            }
        },
        methods: {
            onNewQuoteClick: function() {
                //TODO: implement your logic here
                this.showInformationDialog("Hello");
            },
            getNewQuoteButtonVisible: function() {
                var newMode = this.isNewMode();
                var result = !newMode; //TODO: implement your logic for visibility here
                this.sandbox.publish("SetNewQuoteButtonVisibility", result, [this.sandbox.id]);
                return result;
            }
        },
        diff: /**SCHEMA_DIFF*/[
            {
                "operation": "insert",
                "name": "NewQuoteButton",
                "parentName": "LeftContainer",
                "propertyName": "items",
                "values": {
                    "itemType": Terrasoft.ViewItemType.BUTTON,
                    "style": Terrasoft.controls.ButtonEnums.style.DEFAULT,
                    "caption": {"bindTo": "Resources.Strings.NewQuoteBtn"},
                    "click": {"bindTo": "onNewQuoteClick"},
                    "visible": {"bindTo": "getNewQuoteButtonVisible"},
                    "classes": {
                        "textClass": ["actions-button-margin-right"]
                    }
                }
            }
        ]/**SCHEMA_DIFF*/
    };
});

     

  4. Create replacing client schema for the section.

  5. Create section's localizable string for a button caption.

    define("OpportunitySectionV2", [], function() {
    return {
        attributes: {
            "IsNewQuoteButtonVisible": {
                dataValueType: this.Terrasoft.DataValueType.BOOLEAN,
                value: false
            }
        },
        messages: {
            "SetNewQuoteButtonVisibility": {
                mode: this.Terrasoft.MessageMode.PTP,
                direction: this.Terrasoft.MessageDirectionType.SUBSCRIBE
            }
        },
        methods: {
            subscribeSandboxEvents: function() {
                this.callParent(arguments);
                this.sandbox.subscribe("SetNewQuoteButtonVisibility", function(result) {
                    this.set("IsNewQuoteButtonVisible", result);
                }, this, [this.getCardModuleSandboxId()]);
            }
        },
        diff: /**SCHEMA_DIFF*/[
            {
                "operation": "insert",
                "name": "NewQuoteButton",
                "parentName": "CombinedModeActionButtonsCardLeftContainer",
                "propertyName": "items",
                "values": {
                    "itemType": Terrasoft.ViewItemType.BUTTON,
                    "style": Terrasoft.controls.ButtonEnums.style.DEFAULT,
                    "caption": {"bindTo": "Resources.Strings.NewQuoteBtn"},
                    "visible": { "bindTo": "IsNewQuoteButtonVisible" },
                    "click": {"bindTo": "onCardAction"},
                    "tag": "onNewQuoteClick",
                    "classes": {
                        "textClass": ["actions-button-margin-right"]
                    }
                }
            }
        ]/**SCHEMA_DIFF*/
    };
});

     

The result would be:

Like 1

Like

Share

0 comments
Show all comments
SDK
support
cases
Hiding print button for different opportunity stages
Tatiana Rogova
02:31 Sep 05, 2018

Case:

We want to hide print button for some opportunity stages

Algorithm of realization:

  1. You should create replacing client schema for OpportunityPageV2  and OpportunitySectionV2.

  2. Create attributes on both pages:

    attributes: {
    "isPrintButtonVisible": {
        "dataValueType": Terrasoft.DataValueType.BOOLEAN
    }
}

    in addition add on Opportunity page:

    "Stage": {
    "onChange": "onStageChanged"
}

     

  3. Create message which will send stage from OpportunityPage  to OpportunitySection when we work in combined mode.

    Add following code to OpportunitySection:

    messages: {
    "PrintButtonVisibleMessage": {
        mode: Terrasoft.MessageMode.PTP,
        direction: Terrasoft.MessageDirectionType.SUBSCRIBE
    }
},

    And to OpportunityPage:

    messages: {
    "PrintButtonVisibleMessage": {
        mode: Terrasoft.MessageMode.PTP,
        direction: Terrasoft.MessageDirectionType.PUBLISH
    }
},

     

  4. Create methods which will set button visibility and publish message about it on OpportunityPage:

    printButtonVisiblePublishMessage: function() {
    return this.sandbox.publish("PrintButtonVisibleMessage", this.get("isPrintButtonVisible"), ["key"]);
},
onStageChanged: function() {
    this.setPrintButtonVisibility();
    this.printButtonVisiblePublishMessage();
},
setPrintButtonVisibility: function() {
    var stage = this.get("Stage");
 
    if (stage.value === "423774cb-5ae6-df11-971b-001d60e938c6") {
        this.set("isPrintButtonVisible", true);
    } else {
        this.set("isPrintButtonVisible", false);
    }
}

     

  5. Create methods which will handle stage changing on OpportunitySection if we work in combined mode

    init: function() {
    this.callParent(arguments);
    this.sandbox.subscribe("PrintButtonVisibleMessage", this.onPrintButtonVisibleMessage, this, ["key"]);
},
onPrintButtonVisibleMessage: function(isButtonVisible) {
    this.set("isPrintButtonVisible", isButtonVisible);
}

     

  6. Bind button visibility to isPrintButtonVisible attribute

    1. OpportunityPage

      {
    "operation": "merge",
    "name": "PrintButton",
    "values": {
        "visible": {
            "bindTo": "isPrintButtonVisible"
        }
    }
},

       

    2. OpportunitySection

      {
    "operation": "merge",
    "name": "CombinedModePrintButton",
    "values": {
        "visible": {
            "bindTo": "isPrintButtonVisible"
        }
    }
}

       

Like 0

Like

Share

0 comments
Show all comments
SDK
mobile
support
Mobile app sync error. System.ArgumentException: An item with the same key has already been added
Kirill Potapkin
15:23 Aug 31, 2018

Symptoms

Mobile application simulator does not work. System.ArgumentException: An item with the same key has already been added

Cause

This error is not caused by incorrect changes in the application configuration.

It islikely that localized strings were added to the mobile application's manifest, which duplicates the lines from MobileApplicationManifestMobile.

Solution

Update the application to the latest version (7.5.0) or change the localized strings in the custom schema (for example, "UsrMobileApplicationManifestCustom2Schema").

For example, add the "Custom" prefix in the name of localized lines.

Necessary conditions and possible restrictions

System administrator rights

Like 0

Like

Share

0 comments
Show all comments
SDK
support
cases
Add a custom FixedFilter
Tatiana Rogova
02:45 Aug 30, 2018

Case description:

You need to add a custom fixed filter by column Type to the Contact section.

Algorithm of realization:

  1. Create replacing client schema for your section.
  2. Create localizable strings which will contain captions of the filter and menu item.
  3. Create image which will contain image of the filter.

  4. Source code of the "ContactSectionV2" :

define("ContactSectionV2", [], function() {
    return {
        entitySchemaName: "Contact",
        methods: {
            initFixedFiltersConfig: function () {
                var fixedFilterConfig = {
                    entitySchema: "ContactType",
                    filters: [
                        {
                            name: "TypeFilter",
                            columnName: "Type",
                            caption: this.get("Resources.Strings.ContactTypeFilterCaption"),
                            dataValueType: this.Terrasoft.DataValueType.LOOKUP,
                            appendCurrentContactMenuItem: false,
                            addNewFilterCaption: this.get("Resources.Strings.SelectContactTypeCaption"),
                            hint: this.get("Resources.Strings.SelectContactTypeCaption"),
                            buttonImageConfig: this.get("Resources.Images.ContactTypeFilterImage")
                        }
                    ]
                };
                this.set("FixedFilterConfig", fixedFilterConfig);
            }
        }
    };
});

The result would be:

Like 0

Like

Share

0 comments
Show all comments
SDK
support
cases
How to add completeness bar into custom section
Tatiana Rogova
02:36 Aug 29, 2018

Case description:

Add record completeness into custom section.

How to do it:

  1. Add Completeness field into your section object. This one should be an integer.

  2. Add record about your section into Completeness table. You can do it with following SQL script:

    INSERT INTO Completeness (Name, EntitySchemaName, ResultColumnName, Scale)
    VALUES ('Quotes', 'VistQuotes', 'VistCompleteness', '{"sectorsBounds":{"min":0,"middleFrom":50,"middleTo":80,"max":100}}')

    You should specify Name, EntitySchemaName, ResultColumnName and Scale columns.

  3. Create replacing client module for your page (for example VistQuotes1Page in my case).
  4. Add dependencies on following schemas: "CompletenessIndicator", "CompletenessMixin", "css!CompletenessCSSV2", "TooltipUtilities".

  5. Add two attributes into "attributes" area:

    CompletenessValue: {
    dataValueType: Terrasoft.DataValueType.INTEGER,
    value: 0
},
MissingParametersCollection: {
    dataValueType: Terrasoft.DataValueType.COLLECTION
}

     

  6. Add two mixins (CompletenessMixin, TooltipUtilitiesMixin) into your schema.

    mixins: {
    CompletenessMixin: "Terrasoft.CompletenessMixin",
    TooltipUtilitiesMixin: "Terrasoft.TooltipUtilities"
},

     

  7. Add the following methods:

    methods: {
    init: function() {
        this.set("MissingParametersCollection", this.Ext.create("Terrasoft.BaseViewModelCollection"));
        this.callParent(arguments);
    },
    onDetailChanged: function() {
        this.callParent(arguments);
        this.calculateCompleteness();
    },
    onEntityInitialized: function() {
        this.callParent(arguments);
        if (this.isEditMode()) {
            var collection = this.get("MissingParametersCollection");
            collection.clear();
            this.set("CompletenessValue", 0);
            this.calculateCompleteness();
        }
    },
    onSaved: function() {
        var callParentOnSaved = this.get("CallParentOnSaved");
        this.callParent(arguments);
        if (!callParentOnSaved && !this.isNewMode() && !this.get("IsProcessMode")) {
            this.calculateCompleteness();
        }
    },
    calculateCompleteness: function() {
        var config = {
            recordId: this.get("Id"),
            schemaName: this.entitySchemaName
        };
        this.mixins.CompletenessMixin.getCompleteness.call(this, config, this.calculateCompletenessResponce, this);
    },
    calculateCompletenessResponce: function(completenessResponce) {
        if (this.Ext.isEmpty(completenessResponce)) {
            return;
        }
        var missingParametersCollection = completenessResponce.missingParametersCollection;
        var completeness = completenessResponce.completenessValue;
        var scale = completenessResponce.scale;
        if (!this.Ext.isEmpty(missingParametersCollection)) {
            var collection = this.get("MissingParametersCollection");
            collection.clear();
            collection.loadAll(missingParametersCollection);
        }
        if (this.Ext.isObject(scale) && this.Ext.isArray(scale.sectorsBounds)) {
            this.set("CompletenessSectorsBounds", scale.sectorsBounds);
        }
        if (this.Ext.isNumber(completeness)) {
            this.set("CompletenessValue", completeness);
        }
    }
},

     

  8. Insert completeness bar into your page with code like following:

    diff: /**SCHEMA_DIFF*/[
    {
        "operation": "insert",
        "parentName": "MetricsContainer",
        "propertyName": "items",
        "name": "CompletenessContainer",
        "values": {
            "itemType": Terrasoft.ViewItemType.CONTAINER,
            "items": []
        }
    },
    {
        "operation": "insert",
        "parentName": "CompletenessContainer",
        "propertyName": "items",
        "name": "CompletenessValue",
        "values": {
            "generator": "ConfigurationRectProgressBarGenerator.generateProgressBar",
            "controlConfig": {
                "value": {
                    "bindTo": "CompletenessValue"
                },
                "menu": {
                    "items": {
                        "bindTo": "MissingParametersCollection"
                    }
                },
                "sectorsBounds": {
                    "bindTo": "CompletenessSectorsBounds"
                }
            },
            "tips": [],
            "layout": {
                "column": 0,
                "row": 0,
                "rowSpan": 1,
                "colSpan": 1
            }
        }
    },
    {
        "operation": "insert",
        "parentName": "CompletenessValue",
        "propertyName": "tips",
        "name": "CompletenessTip",
        "values": {
            "content": {"bindTo": "Resources.Strings.CompletenessHint"}
        }
    }
]/**SCHEMA_DIFF*/

    Full example code you can find below:

define("VistQuotes1Page", ["CompletenessIndicator", "CompletenessMixin", "css!CompletenessCSSV2", "TooltipUtilities"],
    function() {
    return {
        entitySchemaName: "VistQuotes",
        attributes: {
            CompletenessValue: {
                dataValueType: Terrasoft.DataValueType.INTEGER,
                value: 0
            },
            MissingParametersCollection: {
                dataValueType: Terrasoft.DataValueType.COLLECTION
            }
        },
        modules: /**SCHEMA_MODULES*/{}/**SCHEMA_MODULES*/,
        details: /**SCHEMA_DETAILS*/{}/**SCHEMA_DETAILS*/,
        businessRules: /**SCHEMA_BUSINESS_RULES*/{}/**SCHEMA_BUSINESS_RULES*/,
        methods: {
            init: function() {
                this.set("MissingParametersCollection", this.Ext.create("Terrasoft.BaseViewModelCollection"));
                this.callParent(arguments);
            },
            onDetailChanged: function() {
                this.callParent(arguments);
                this.calculateCompleteness();
            },
            onEntityInitialized: function() {
                this.callParent(arguments);
                if (this.isEditMode()) {
                    var collection = this.get("MissingParametersCollection");
                    collection.clear();
                    this.set("CompletenessValue", 0);
                    this.calculateCompleteness();
                }
            },
            onSaved: function() {
                var callParentOnSaved = this.get("CallParentOnSaved");
                this.callParent(arguments);
                if (!callParentOnSaved && !this.isNewMode() && !this.get("IsProcessMode")) {
                    this.calculateCompleteness();
                }
            },
            calculateCompleteness: function() {
                var config = {
                    recordId: this.get("Id"),
                    schemaName: this.entitySchemaName
                };
                this.mixins.CompletenessMixin.getCompleteness.call(this, config, this.calculateCompletenessResponce, this);
            },
            calculateCompletenessResponce: function(completenessResponce) {
                if (this.Ext.isEmpty(completenessResponce)) {
                    return;
                }
                var missingParametersCollection = completenessResponce.missingParametersCollection;
                var completeness = completenessResponce.completenessValue;
                var scale = completenessResponce.scale;
                if (!this.Ext.isEmpty(missingParametersCollection)) {
                    var collection = this.get("MissingParametersCollection");
                    collection.clear();
                    collection.loadAll(missingParametersCollection);
                }
                if (this.Ext.isObject(scale) && this.Ext.isArray(scale.sectorsBounds)) {
                    this.set("CompletenessSectorsBounds", scale.sectorsBounds);
                }
                if (this.Ext.isNumber(completeness)) {
                    this.set("CompletenessValue", completeness);
                }
            }
        },
        mixins: {
            CompletenessMixin: "Terrasoft.CompletenessMixin",
            TooltipUtilitiesMixin: "Terrasoft.TooltipUtilities"
        },
        dataModels: /**SCHEMA_DATA_MODELS*/{}/**SCHEMA_DATA_MODELS*/,
        diff: /**SCHEMA_DIFF*/[
            {
                "operation": "insert",
                "parentName": "MetricsContainer",
                "propertyName": "items",
                "name": "CompletenessContainer",
                "values": {
                    "itemType": Terrasoft.ViewItemType.CONTAINER,
                    "items": []
                }
            },
            {
                "operation": "insert",
                "parentName": "CompletenessContainer",
                "propertyName": "items",
                "name": "CompletenessValue",
                "values": {
                    "generator": "ConfigurationRectProgressBarGenerator.generateProgressBar",
                    "controlConfig": {
                        "value": {
                            "bindTo": "CompletenessValue"
                        },
                        "menu": {
                            "items": {
                                "bindTo": "MissingParametersCollection"
                            }
                        },
                        "sectorsBounds": {
                            "bindTo": "CompletenessSectorsBounds"
                        }
                    },
                    "tips": [],
                    "layout": {
                        "column": 0,
                        "row": 0,
                        "rowSpan": 1,
                        "colSpan": 1
                    }
                }
            },
            {
                "operation": "insert",
                "parentName": "CompletenessValue",
                "propertyName": "tips",
                "name": "CompletenessTip",
                "values": {
                    "content": {"bindTo": "Resources.Strings.CompletenessHint"}
                }
            },
            {
                "operation": "insert",
                "name": "VistStatusa33f682a-dd58-4739-919d-cb84b9d2fc70",
                "values": {
                    "layout": {
                        "colSpan": 12,
                        "rowSpan": 1,
                        "column": 12,
                        "row": 10,
                        "layoutName": "Header"
                    },
                    "bindTo": "VistStatus",
                    "enabled": true
                },
                "parentName": "Header",
                "propertyName": "items",
                "index": 46
            }
        ]/**SCHEMA_DIFF*/
    };
});

 

Like 0

Like

Share

2 comments
vinh.nx
05:55 Feb 23, 2021

Hi when i login by Sale role it not calculate the completeness in custom section.

Oleg Drobina
13:23 Feb 23, 2021

vinh.nx,

 

Hello, 

 

The functionality of completeness doesn't take column or record permissions into account and even you have column permissions enabled for any of the columns that is used for completeness calculation the completeness indicator will be updated anyway.

 

Please double-check all the steps from the instruction since something is missing in your configuration.

 

Best regards,

Oscar

Show all comments
Q&A
support
mobile
SDK
Mobile app sync error
Kirill Potapkin
18:17 Aug 27, 2018

Symptoms

  1. There are several identical positions for the distribution of rights for operations
  2. The current user does not have permission to access the MobileData object

Cause

Access rights to mobile application objects are not distributed and organizational structure is not updated.

Solution

  1. Distribute access rights to mobile application objects
  2. Update the organizational structure

Necessary conditions and possible restrictions

Admin rights.

 

 

 

Like 0

Like

Share

0 comments
Show all comments
SDK
mobile
support
Mobile bug - different users connecting at once
Kirill Potapkin
18:23 Aug 24, 2018

Symptoms

Type: Terrasoft.SqlProxyException%0D%0A

Message: An exception occurred SQL%0D%0A%0D%0AТип: Terrasoft.SqlException%0D%0AСообщение: undefined: Cannot call method 'setRecord' of undefined%0D%0A%0D%0A

Cause

This message indicates that the device has been connected to by different users. This sometimes occurs when switching the database.

Solution

Clear the database cache and re-synchronize.



Important - all unsynchronized will be deleted from the mobile device when you clear the cache.

Like 0

Like

Share

0 comments
Show all comments
Subscribe to SDK