Please help with this question :

Configure settings so that a user cannot save an invoice if the total amount of a customer's debt (taking into account the amount of the current invoice) exceeds $4,000.

what this mean and how to solve it?

Hi everyone,



I have query:

SELECT (
	SELECT
		count(DISTINCT(c.id))
	-- c.id, c.name
	FROM flight_detail fd
		JOIN contact c
			ON c.id = fd.contact_id
		WHERE
			-- get last year 
			(fd.departure_date >= '2016-09-01' AND fd.departure_date <= '2017-09-30')	
			AND
			-- get this year
			fd.contact_id IN (
				SELECT fd_ly.contact_id
				FROM flight_detail fd_ly
				WHERE 
					fd_ly.departure_date >= '2017-09-01' AND fd_ly.departure_date <= '2018-09-30'
			)
) AS 'Customer Last Year Who Still Buy Ticket This Year',
(
	SELECT
		count(DISTINCT(c.id))
		-- c.id, c.name
	FROM flight_detail fd
		JOIN contact c
			ON c.id = fd.contact_id
		WHERE
			-- get last year 
			(fd.departure_date >= '2016-09-01' AND fd.departure_date <= '2017-09-30')
) AS 'Customer Last Year';

How to transform query to JSON format for sending data paramater DataService.

This query for get data from bpm and I want show the result to my 3rd app.



Thanks.

Hello community,

I am trying to perform the following command from a Script Task element:

DELETE FROM [dbo].[UsrListDocuments] WHERE [Opportunity] = @P1 AND [Product] = @P2

Currently, the C# code is similar to this:

var opportunityId = Get("Read opportunity product.Opportunity");
var productId = Get("Read opportunity product.Product");
var delete = new Delete(userConnection)
        .From("UsrListDocuments")
        .Where("Opportunity").IsEqual(opportunityId)
        .Where("Product").IsEqual(productId);
        
return true;

Is this accurate? What would be the best practice in this case? The code is not working properly that´s why I am looking for your assistance.

Thanks.

Hi Community,

I am commiting changes on my package to SVN repository and I got this error "ROOT CAUSE INCONSISTENT LINE ENDING STYLE" (please see image below), how can I fix this error? Thanks

Hello Community!

I have a query with aggregation SUM in products. But need SUMa field depend of the category.

How can make a subquery to sum based a condition 

Regards,

				esq.addAggregationSchemaColumn("[Product:OrderProduct:Order].UsrCost",
						this.Terrasoft.AggregationType.SUM, "ProductCost");
				esq.addAggregationSchemaColumn("[Product:OrderProduct:Order].UsrProfit",
						this.Terrasoft.AggregationType.SUM, "ProductProfit");
 
//Only if category of product is xxxxx sum the price
				esq.addAggregationSchemaColumn("[Product:OrderProduct:Order].UsrPrice",
						this.Terrasoft.AggregationType.SUM, "ProductProfit");

Hi Community,

Good Day

I have tried this one

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

Using C# console application project we can insert data to BPM online,

My question is, how about adding multiple records? or do I need to re initialize all of this and trigger POST method in every record that I will insert.

Thanks

Hi Everyone.



I have 2 section, section Contact and Flight Detail (FD). Both are connected (FD is detail of Contact).

I want to display just apart of data of the detail were have conditions below:

Contact.Email == FD.Email AND Contact.Full Name == FD.Full Name

For example, I open data Contact with Full Name = “ALI BABA” and when I saw detail FD, the detail automatically only display data as the conditions above.

the picture below display all data of detail, while I want to display is data in the red circle.

How to implement that? any solution or trick ?



Thanks



*SOLVED

I found posting with same question https://community.bpmonline.com/questions/system-filter-detail-list.

Hi,

I've got some weird problems with ProcessEngineService.svc. I'm trying to run a process with parameter sent via POST. In most cases it works fine, but sometimes the process starts with blank parameter (despite proper HTTP response code 200 "Ok"). There are no differences with request data. It is totally random whether it works or not. On new installation my process starts but also without values in parameter. Response code is 200 (Ok). I'm using the same code, the same version of software etc.

My client and process are based on this thread: https://community.terrasoft.ru/questions/processengineservicesvc-i-meto…



What could be the cause of the problem ? Thanks in advance for comments and advice.

I normally get UserConnection from HttpContext and then use it to access the database. Now, when dealing with a business process that starts after a signal, HttpContext.Current is empty. Is there some default UserConnection that I can access?

Hi Community,

I want to open a look up which by default has already selected records, please see image below. Lets say, I have look up "Main Activity". I want record "Main Activity A" by default was checked upon opening the look up window. 

Thanks