Dear Raghu,

In order for the functionality to start working, you need to either place an event listener, which will be listening for the column value change, or call the parent implementation of basic validator method. You can do that in two ways.

First approach is based on our basic functionality: addColumnValidator() method. I can see, that you have chosen this way, though, you need to call addColumnValidator inside the setValidationConfig method. This is due to the fact, that the parent implementation of the setValidationConfig() method must be called before calling the addColumnValidator() method to correctly initialize validators of the base page fields.

setValidationConfig: function() {
   // Calls the initialization of validators for the parent view model.
   this.callParent(arguments);
    // The dobValidator() validate method is added to the [UsrDateofbirth] column.
    this.addColumnValidator("UsrDateofbirth", this.dobValidator);
}

Second approach does not use basic validator functionality. You can write a validation method (like dobValidator()) and add change event listener to the onEntityInitialized function. In such way you indicate, that once the column value gets changed(inserted), the system will run the custom validator method. In the method block, please add the following:

onEntityInitialized: function() {
   this.callParent(arguments);
   //which [column] should trigger a validation [method]
   this.on("change:[column]", this.[method], this);
}

Regards,

Anastasia

Anastasia Botezat,

Hi Sir/Madam,

I have called addColumnValidator inside the setValidationConfig method still I'm not getting the error message

  methods: { 
 
        setValidationConfig: function() {                
                this.callParent(arguments);
                this.addColumnValidator("UsrDOB", this.dobValidator);                
        },   
 
        dobValidator: function(value) {
                var invalidMessage = "";
                var isValid = true;
                var number = value || this.get("UsrDateofbirth");
 
                var nd = number.substr(0, 2);
                var nm = number.substr(3, 2);
                var ny = number.substr(6, 2);
                var cnumber = "";
                cnumber = nm + "-" + nd + "-" + ny;
 
                var today = new Date();
                var birthDate = new Date(cnumber);
 
                //day
                var tdate = today.toString();
                var td = tdate.substr(8, 2);
                td = parseInt(td, td);
                var bd = number.substr(0, 2);
                bd = parseInt(bd, bd);
                var d = bd - td;
 
                //year
                var age = today.getFullYear() - birthDate.getFullYear();
 
                //month
                var todayMonth = today.getMonth() + 1;
                var getMonthName =  birthDate.toString();
                var monthName = getMonthName.substr(4, 3);
                var bdmonthnumber;
 
                todayMonth = parseInt(todayMonth, todayMonth);
 
                if (monthName === "Jan") {
                    bdmonthnumber = 1;
                } else if (monthName === "Feb") {
                    bdmonthnumber = 2;
                } else if (monthName === "Mar") {
                    bdmonthnumber = 3;
                } else if (monthName === "Apr") {
                    bdmonthnumber = 4;
                } else if (monthName === "May") {
                    bdmonthnumber = 5;
                } else if (monthName === "Jun") {
                    bdmonthnumber = 6;
                } else if (monthName === "Jul") {
                    bdmonthnumber = 7;
                } else if (monthName === "Aug") {
                    bdmonthnumber = 8;
                } else if (monthName === "Sep") {
                    bdmonthnumber = 9;
                } else if (monthName === "Oct") {
                    bdmonthnumber = 10;
                } else if (monthName === "Nov") {
                    bdmonthnumber = 11;
                } else if (monthName === "Dec") {
                    bdmonthnumber = 12;
                }
 
                var m = todayMonth - bdmonthnumber;
                //console.log("m"+m);
                if ((age === 18) && (m === 0) && (d === 0)) {
                    isValid = true;
                } else if ((age === 18) && (m === 0) && (d < 0)) {
                    isValid = false;
                } else if ((age === 18) && (m === 0) && (d > 0)) {
                    isValid = true;
                } else if (age < 18) {
                    isValid = false;
                } else if (age > 18) {
                    isValid = true;
                }
 
                if (!isValid) {
                    invalidMessage = this.get("Resources.Strings.InvalidDOBFormat");
                }
                // Object which properties contain validation error messages.
                // If the validation is successful, empty strings are returned to the object.
                return {
                    invalidMessage: invalidMessage
                };
        }
}

Regards

Raghu Ram

Dear Raghu,

The error message does not appear, because of the errors in the validation function. Please consider rewriting the birthDay variable, since it passes date to new Date() method in a wrong format.

Sincerely,

Anastasia Botezat

Dear Sekhar,

This green lock means that the package is locked in the SVN repository. Nobody can commit this package while it is locked except the person who locked it. But you can develop in this package and save your changes locally. After you made your changes just commit to repository and press the green lock again to unlock a package. More on topic learn here

Thanks peter

Yes, you can.

Just push the result columns to the esq, and set sorting by specifying the index of the column and the sort order

var entitySchemaQuery = Ext.create("Terrasoft.EntitySchemaQuery", {
	rootSchemaName: entitySchemaName
});
 
var modifiedOnColumn = entitySchemaQuery.addColumn("ModifiedOn", "ModifiedOn");
 
modifiedOnColumn.orderPosition = 0;
modifiedOnColumn.orderDirection = Terrasoft.OrderDirection.ASC;

Anastasia Botezat,

thanks so much anastasia. i can order that page.

Dear Tomasz,

You are right. Using Insert class doesn't fire any business processes. It connected to the fact that Insert class works directly with database not with entity. We recommend using this class only if perfomance is high priority. It much faster than EntitySchemaQuery class, because the Insert, Update, Delete classes skip all events and rights check. If you want to fire your business process, use EntitySchemaQuery:

var entitySchemaManager = UserConnection.EntitySchemaManager;

var entitySchema = entitySchemaManager.GetInstanceByName("Contact");

Entity schemeObject = entitySchema.CreateEntity(UserConnection);

schemeObject.SetDefColumnValues(); // don't forget call this method every time

schemeObject.SetColumnValue("Name", "Daniel Redkliff");

bool successfullySaved = schemeObject.Save();

Peter Vdovukhin,

 Thanks Peter

Peter Vdovukhin,

EntitySchemaQuery is also not triggering any event. I am using the update query using EntitySchemaQuery.

My code:

var entitySchemaManager = userConnection.EntitySchemaManager;
var entitySchema = entitySchemaManager.GetInstanceByName("Contact");
Entity schemeObject = entitySchema.CreateEntity(userConnection);
if (schemeObject.FetchFromDB(recordId))
{
    schemeObject.SetColumnValue("Reason", Column.Parameter(reason));
    if (status.ToLower() == "completed")
        schemeObject.SetColumnValue("CompletedOn", Column.Parameter(statusDate));
    schemeObject.Save();
}

Dear Carlos,

In case you create a printable in C object, you can create two tables from A and B to get the info connected to the entity C. Please try to create such printables. I recommend you to test it. In case the tables are not connected at all, you won't be able to get the info from B to the printable based on A.

Best regards,

Lily Johnson

Lily Johnson,

I don't think just creating a printable for C solves the problem, because there are more than one of this type of relationships between A and other entities. Let's say I have entity C with lookups to A and B and also entity Y with lookups to A and X. How can connect in a printable entities A, B, X?

Dear Carlos,

Unfortunately, you won't be able to get the info in such a way if the entities are not connected directly. 

Best regards,

Lily

Lily Johnson,

Ok, thanks for the info.

It's a good practice to post your code when you ask about the code errors. In this case it's much easier to find what's wrong with it.

http://prntscr.com/jzz7tu

As more detailed issue description you give, as more detailed answer you get ;)

Regarding the request. Bpm'online - it's an asp.net application. When you write c# code it will appear in a class. You can check the source code of the class by clicking on the "Open source code" button.

http://prntscr.com/jzz9or

Please investigate the code and find what's wrong with it. 

Please note that it's not enough to add "using" in an asp.net application. "using" should always be connected to a "reference". You can add additional libraries as references in the "External assemblies" section.

https://academy.bpmonline.com/documents/technic-sdk/7-12/configuration-…

http://prntscr.com/jzze8p

Additionally, if you're not sure if your code doesn't conflict in namespaces, then you can use full name of classes. For example

Using System.Text;

StringBuilder MyStringBuilder = new StringBuilder("Hello World!");

Is equal to

System.Text.StringBuilder MyStringBuilder = new System.Text.StringBuilder("Hello World!");

You need to create replacing modules for the case page and for the case section. Then write the code that will match your needs there. Please find the example below.

define("CaseSection", ["BaseFiltersGenerateModule", "CheckBoxFixedFilterStyle", "StorageUtilities",
			"ServiceDeskConstants", "CasePageUtilitiesV2", "css!CheckBoxFixedFilterStyle"],
		function(BaseFiltersGenerateModule, CheckBoxFixedFilterStyle, StorageUtilities, ServiceDeskConstants) {
			return {
				entitySchemaName: "Case",
				contextHelpId: "1001",
				mixins: {},
				attributes: {
					"UsrIsProcessButtonVisible": {
						dataValueType: this.Terrasoft.DataValueType.BOOLEAN,
						type: this.Terrasoft.ViewModelColumnType.VIRTUAL_COLUMN,
						value: false
					}
				},
				messages: {},
				methods: {
					init: function() {
						this.callParent(arguments);
						this.set("UsrIsProcessButtonVisible");
					}
				},
				diff: /**SCHEMA_DIFF*/[
					{
						"operation": "merge",
						"name": "ProcessButton",
						"values": {
							"visible": {"bindTo": "UsrIsProcessButtonVisible"}
						}
					},
					{
						"operation": "merge",
						"name": "DataGridRunProcessAction",
						"values": {
							"visible": {"bindTo": "UsrIsProcessButtonVisible"}
						}
					}
				]/**SCHEMA_DIFF*/
			};
		});

define("CasePage", [], function() {
	return {
		entitySchemaName: "Case",
		attributes: {
			"UsrIsProcessButtonVisible": {
				dataValueType: this.Terrasoft.DataValueType.BOOLEAN,
				type: this.Terrasoft.ViewModelColumnType.VIRTUAL_COLUMN,
				value: false
			}
		},
		modules: /**SCHEMA_MODULES*/{}/**SCHEMA_MODULES*/,
		details: /**SCHEMA_DETAILS*/{}/**SCHEMA_DETAILS*/,
		businessRules: /**SCHEMA_BUSINESS_RULES*/{}/**SCHEMA_BUSINESS_RULES*/,
		methods: {
			onEntityInitialized: function() {
				this.callParent(arguments);
				this.set("UsrIsProcessButtonVisible");
			}
		},
		dataModels: /**SCHEMA_DATA_MODELS*/{}/**SCHEMA_DATA_MODELS*/,
		diff: /**SCHEMA_DIFF*/[
			{
				"operation": "merge",
				"name": "ProcessButton",
				"values": {
					"visible": {"bindTo": "UsrIsProcessButtonVisible"}
				}
			}
		]/**SCHEMA_DIFF*/
	};
});

Thank you. And do you know if it's possible to disable or hide single context menu item? For example if I have two processes I may want to disable one but not the other.

You need to override methods from the ProcessEntryPointUtilities mixin in the CaseSection and CasePage modules. For example, for the button on a grid record you'll need to override the addRecordRunProcessMenuItems method in the CaseSection module. 

http://prntscr.com/jzm8w0

Thank you very much.

Dear Danilo,

Unfortunately, there is no place you can export all the system fields from. You can install SQL-executor from the Marketplace and execute the select queries with it to be able to view the content of the database tables and the fields that are used there.

We are planning to add the list of all the objects and field used in the system someday but there is no ETA for the task yet.  

Lisa

Thanks Lisa. I will give a try to the SQL executor

The SQL executor was enough for me

Dear Bryan,

There is no way to export the fields or columns that are in a table using SQL executor from the Marketplace. You can only view them. As for a queries, you may use basic ones that are enough to see the table content. For instance if you want to see the fields and columns in the Contact table, run 'select * from Contact', etc. As of the export option, our R&D team already accepted the idea of adding the list of all objects and fields for export, still we do not know when exactly it will be implemented. 

Best regards, 

Dean

We were able to export the feed, are you saying we can't do all of the columns?

Dear Bryan,

Thank you for the reply. I'm so sorry, I mislead you. I was using the older version of the SQL executor. Just updated to the latest one, which has the option 'Export to csv'. Using this option you can export all the records and columns from the table as well as the feed. 

Best regards,

Dean

Great! Can you provide the query to export everything at once?

Bryan Baker,

Hello,

There is no SQL-query that allows selecting all records from all tables and that's why it cannot be done. It is not something that bpm'online doesn't support. It is something that cannot be handled by SQL language itself. You need to run select queries one by one for all tables in the application (you can get a list of all system tables of the database using select * from sys.tables query) and export results for each query.

Best regards,

Oscar

This marketplace package installs a process you can run to export the entire system schema in an Excel file: 

https://marketplace.bpmonline.com/app/object-structure-export-bpmonline

Ryan

Dear Venkata,

It seems the lookup object used for field "Current Industry" was deleted. So now the field doesn't have any object to get the records from.

Please, open the field settings in section wizard and check if the object is selected. Select/create new object and try to save.

In case the issue still occurs feel free to submit a case to support@bpmonline.com.

With best regards,

Oliver Wingston

Dear Ezequiel,

The task was already discussed in another Community post here - https://community.bpmonline.com/questions/call-business-process-script-task. Feel free to check the solution provided there. 

Lisa