News & Activity Feed

Thursday, December 13, 2018 8:44 AM | xh

I tried to import around 4K rows of data into the Product table.
But import performance was really slow, took around 20 minutes to complete
I have the import-duplicate-test on barcode field and import-duplicate-accept on the cost price and sell price field.

What is the best practice here? Thanks.
Wednesday, December 12, 2018 10:53 PM | allen
I just noticed this, after upgrading to 8.7.6, the My Account link is missing from Touch UI. Users can no longer change their password. This is another deal breaker for 8.7.6.
Wednesday, December 12, 2018 10:31 PM | allen
Using 8.7.6, when I regenerate the app it deletes my ApplicationServices.Custom.cs file. This is a deal breaker for 8.7.6.
Wednesday, December 12, 2018 5:22 PM | Paul
I verified that this does not pass the value of a context field. The other end of the lookup ALWAYS evaluates to NULL.



The filter logic should NOT return anything because the context field is NOT NULL but the lookup returns ALL rows.

***Using PostgreSQL but that should not matter
Wednesday, December 12, 2018 10:16 AM | Deepak Arya
Hi,Any One Share with me latest COT with $150 ThanksDA
Wednesday, December 12, 2018 10:11 AM | Deepak Arya
Hi,Any One Share with me latest COT with $150 ThanksDA
Wednesday, December 12, 2018 7:40 AM | Nahuel Gonzalez
I happen to have a pie chart where the categories are fixed (OK, Warning, Error, etc). The colors are chosen automatically and they do not fit correctly with the labels; say, Error is shown in green and OK in orange. Is there a way to set a certain color to a category in a pie chart?
Wednesday, December 12, 2018 7:37 AM | Customer Service

Create complex multi-tenant applications with data segregation by user identity. It takes only a few lines of code placed in shared business rules.

It easy to keep track of user activities and to associate the current user with the new data their create. Learn to write a universal handler for SQL INSERT commands that were successfully completed.
Tuesday, December 11, 2018 10:15 PM | Brent Higgs
Okay I have searched the forum and online to see if I could come up with a solution to this.

I have a couple of charts that are displaying counts per month and year a variety of different data fields.

These fields charts use the standard Calendar of January to December, where for business fiscal year is December to November

I would prefer this to be a global rule across all controllers. This could also be a feature that is implemented in the COT Project Settings
Tuesday, December 11, 2018 7:52 PM | Chuck
How can you add or modify static dropdown items using a Javascript business rule?
Tuesday, December 11, 2018 4:33 PM | John Willems
I finally upgraded to v.8.7.6. When I browse my app I now get this error. Nothing changed in the app. The only difference is COT versions.


Tuesday, December 11, 2018 9:48 AM | xh
Hi COT, I have the formula below in SQL Formula, is there anyway to check if the SellPrice is zero before the calculation to prevent the divide zero error?

(Products.SellPrice - Products.CostPrice) / Products.SellPrice

Thank you.
Tuesday, December 11, 2018 9:07 AM | Peter

You can change the timeline of the calendar to 15 min. or 5 min.?

Thanks, Peter
Tuesday, December 11, 2018 7:07 AM | xh

I have a child view (PriceList) on the master view (Product). Everytime the price in the price list changed, I will run a c# business rules to update some fields.

I would like to refresh the data in the editform after the business rules executed.
Is there any way I can do that?

Thank you.
Monday, December 10, 2018 11:16 PM | Jose Manuel Ferreira Gracia

I,ve Found and reading the Topic : DEVELOPMENT / TOOLS FOR EXCEL.

It is exactly what I need in this Moment since I thing it will be very usefull to configure Roles and Data and Options acces for different users profiles and Roles.

My question is:
Is it still usable? , since I,ve downloaded it and noted that last version is from 2013.

Thanks for your soonest reply.
Monday, December 10, 2018 9:35 PM | Dave Wurtz
I'm creating a new topic here because the other was is marked as Answered, but I still can't seem to get this to work. I wasn't sure if you see the responses I had back to you regarding issue Please see my response there.

I don't know what I'm doing wrong with the virtual boolean field as I can't get it to be the 'Selection' checkbox. I have the boolean in the controller, I just can't get the checkbox to be checked/unchecked accordingly.


Thank you.
Monday, December 10, 2018 2:48 PM | Paul
I understand how easy map are generated out-of-the-box with all the list points when you have address fields but is there a way for the map to appear in EDITFORM1?
Monday, December 10, 2018 1:11 PM | John Willems
I need to send an alert type message to my users when a custom search returns no records.

The message is to remind them of the proper search criteria. I have tried several methods but none seem to work.

I have a custom search that uses one field. That filter is used as search criteria.

When no records are returned I need the alert to be sent to the user.

I have tried javascript rules without success. The best I can get is a vb message box on a afterload event from the code behind. Not very elegant and the timing is off.

Can some explain how to get a javascript rule to fire when using a custom search filter? It has no actions and displays okay and cancel buttons. I do not see those actions in the project.

Its the little things that get me. This should be simple and I am missing it.


John W
Monday, December 10, 2018 12:28 PM | xh

I wanted to import the data to the many to many table as per design

ProductID -> alias to ProductName
PriceListID -> alias to PriceListCode
Price-> decimal

How to construct the excel template to import the data? I had tried but not success, please refer to the picture below. Also, I can't find the "download import file template" as describe in this article.

Monday, December 10, 2018 9:54 AM | ben aaa
I have a content generated using COT. But cannot edit the content initial generated content.

In previous versions there used to an edit button that allows the admin user to edit the generated content at runtime. Unfortunately, I can not find this anywhere.

There is a reference document on

This is my generated page
See All Posts