Hi,

Is it possible to specify a binding redirect in web.config for a specific version of an external assembly, if another version of the same assembly is already being used internally by BPM'Online?

I am building an external assembly which has a dependency on a different version of an already existing assembly that is being used by BPM'Online. It would be great to know if there is a way to redirect logic to the right assembly at runtime. Will the "LoadOnAppStart" column of the [SysPackageReferenceAssembly] table help in anyway?

Any help in this regard will be much appreciated. Thanks in advance!

Hello,

I set up a stardard filter on Account page, lets say I want to filter all accounts starting with "A". 

Is there any way that I can read/access this filter from a business process, so I can know which accounts were selected by that filter?

Thank you,

Cristian Galatan.

Dear all,

 We have requirement to create dispatch plans for the contract orders.  Created a table call UsrDispatchPlan... In this table, I need auto increment number for UsrNumber field.

We are trying to create auto numbering for the 

We followed the below steps

1. Create system settings for UsrDispatchPlanCodeMask, UsrDispatchPlanLastNumber

2. I did not created a replacing module, since i am doing it for new requirement(table)

3. Created a process before saving with the below steps

        ->message start with message: UsrDispatchSaving

        ->ScriptTask "SetNumberGenerationParameter" with code:

              GenerateNumberUserTask.EntitySchema = Entity.Schema;

              return true;

        -> a user task "GenerateNumberUserTask", task type "Generate ordinal number ( Base )"

        -> as Script task "SetGeneratedNumber" with code :

                 Entity.SetColumnValue("UsrNumber", GenerateNumberUserTask.ResultCode);

                 return true;

4. Saved and published the process and object as well.

 But the code is not generated in the field. 

Same i did from client side.. It worked!!!! But I need to implement from server side.,.. Because Add option is given with the mini page, where i was not able to process the auto increment.

Even i tried to implement the auto increment with reference to the link.

https://community.bpmonline.com/questions/question-about-auto-numbering…

But did not work!!!. So i am trying to do it with server side.

Please help!!!!

Hi everyone. I'm starting with bpm'online and I have a question related to reminders. I know that in an activity we can send reminders to author and to the owner, but here where I work arise the need of remind everybody in the same department of the owner, I mean, imagine the owner is someone that works in commercial department, so everybody in commercial department should be notified. Do you guys know how can I do it?

Thanks a lot.

I'm running into some trouble when trying to populate a lookup column from a script task.  I invariably get the error "System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'UsrVMProductCode'."

This is the column in question:

And here is the relevant part of the script task:

var esq = new EntitySchemaQuery(UserConnection.EntitySchemaManager, "UsrWaterplayVMProductCode");
 
var ColId = esq.AddColumn("Id");
var ColName = esq.AddColumn("Name");
 
var entities = esq.GetEntityCollection(UserConnection);
var productCodes = new Dictionary<string,string>();
foreach (var entity in entities) {
	productCodes[entity.GetColumnValue(ColName.Name).ToString()] = entity.GetColumnValue(ColId.Name).ToString();
}
 
foreach (var pd in resultObj.UpdatedParts) {
	if (pd.PartId != "") {
		var code = "";
		if (pd.VMProductCode != "") {
			code = productCodes[pd.VMProductCode];
		}
		var update = new Update(UserConnection, "Product")
			.Set("Name", Column.Parameter(pd.Description))
			.Set("Price", Column.Parameter(pd.Price))
			.Set("UsrProductionCost", Column.Parameter(pd.Cost))
			.Set("IsArchive", Column.Parameter(pd.Inactive));
		if (code != "") {
			update.Set("UsrVMProductCode", Column.Parameter(code));
		}
		update.Where("Code").IsEqual(Column.Parameter(pd.PartId));
		if (update.Execute() > 0) {
			resultUpdate += "Product " + pd.PartId + " updated.\\r\\n";
		}
	}
}

I have confirmed through debug logging that the code variable contains a GUID.  The script also worked fine before I tried to set UsrVMProductCode, while attempting to set another lookup column in this way (Currency) gave a similar error.  Is there something special I need to do to set a lookup value with the Insert/Update objects?

Hi,

I am given with the requirement to hide Orders section in account Mobile app, if the Account is inactive.

I have added a field in Account Called usrAccountInactive . The order section should be visible only if this field is false. 

I tried with the below module. But dependentColumnNames : here i will have to give only columnname. But not object name. Please help to reslove this.

Terrasoft.sdk.Model.addBusinessRule("Account",{

    ruleType: Terrasoft.RuleTypes.Visibility, 

    events:[Terrasoft.BusinessRuleEvents.Load],

    conditionalColumns: [ 

        {name: "UsrAccountInactive" , value: false } 

    ], 

    triggeredByColumns: [ "UsrAccountInactive" ] , 

    dependentColumnNames: [ "Order" ]  

});

Thanks in Advance

Hello

I downloaded the multi selection ad-on from market place:

https://marketplace.bpmonline.com/app/multiple-choice-field-module

added the object to a schema according to the instrucions supplied with the add on: 

https://marketplace.bpmonline.com/sites/marketplace/files/app-guide/MultiSelectField_implementation_guide.pdf

The object works fine but I don't know how to locate it in a gruop field. it always appear on the top of the head of the page as shown here:

The code I used in the SCHEMA_DIFF is this:

{

                "operation": "insert",

                "name": "MultiChoiceFieldGroup",

                "values": {

                    "itemType": 15,

                    "caption": {

                        "bindTo": "Resources.Strings.Tabf4d38f16TabLabelTabCaption"

                    },

                    "items": [],

                    "tools": [],

                    "controlConfig": {

                        "collapsed": false

                    }

                },

                "index": 0

            },

            {

                "operation": "insert",

                "name": "MultiChoiceFieldGroupContainer",

                "values": {

                    "itemType": 7,

                    "items": []

                },

                "parentName": "MultiChoiceFieldGroup",

                "propertyName": "items",

                "index": 0

            },

            {

                "operation": "insert",

                "name": "MultichoiceModule",

                "values": {

                    "itemType": 4

                },

                "parentName": "MultiChoiceFieldGroupContainer",

                "propertyName": "items",

                "index": 0

            },

How can I control it's possition ?

Thanks in advance to anyone who will help!

Hi ,

Am facing difficulty in implementing default value for Lookup section filters(Status filter in Order screen). Please help me out to resolve this. The code snippet in OrderSectionV2 is given below :

 {

                            name: "Status",

                            columnName: "Status",

                            caption: this.get("Resources.Strings.StatusFilterCaption"),

                            appendCurrentContactMenuItem: false,

                            dataValueType: this.Terrasoft.DataValueType.LOOKUP,

                            defValue : "1f3ad326-effd-4ac3-a3e2-957e7def3684",

                            addNewFilterCaption: this.get("Resources.Strings.SelectStatusCaption"),

                            hint: this.get("Resources.Strings.SelectStatusCaption"),

                            buttonImageConfig: this.get("Resources.Images.StatusFilterImage"),

                        }

Hello,

I imported an old version of an entity schema into my environment, replacing the current one, and then published/updated the database. It says there's no issue after publishing, but records cannot be saved now because the sql table still has columns from before the import that aren't recognized by the insert queries. 

I can revert to a repository, but I'm curious if there's a faster or known fix.

We have recently run some stats on our onsite production instance and found the following tables to have collectively occupied around 13 GB of database space and millions of rows in each table. We would like to know if we can remove the old records without any impact on the out of the box functionality. 

The tables in question are SysProcessLog and SysProcessElementLog.

Thank you