News & Activity Feed

Monday, October 22, 2018 5:46 AM | Flo Kr
Which minimal prerequisite installations do I need to run the CoT web application generator? We are thinking about setting up CoT in an enterprise environment with multiple developers and a managed IT infrastructure. Which software installations do I need to run CoT without being prompted? I know about Microsoft Report Viewer 2016 Runtime and Microsoft System CLR Types for Microsoft SQL Server 2016. Anything else? Is there a list of specific versions for the preinstallations that are required at a minimum?
Monday, October 22, 2018 2:59 AM | Beyta
I post this question under "ask a question", but ignore by COT team.. so i repost as a problem..

I create custom Report.. How to supply filter for date range..

Current setting inside Data text field..

Friday, October 19, 2018 2:07 PM | Pet Loki
If I'm using row-level security and I'm configuring the Virtualization section (as described in the COT's tutorial document):

1) Changing Virtual View ID to grid1.
2) Typying “Context.User.IsInRole(“Sales”)” in the OverrideWhen field


If I have this project running in Visual Studio 2017 : How can add a debug point at that very precise stage.

I want to be able to see in Visual Studio all those underlying values behind the scenes. I want to check out what "Context" has inside of it because I want to make comparisons and running some C# code so I can make further customization of the project on my own.
Friday, October 19, 2018 7:23 AM | Pet Loki
is that possible doing this with "no hard-coded" code but instead displaying a TextBox control and passing the customer's data entered as the parameter for displaying the following view containing the filtered grid?

what sense does it make having the values hard-coded inside a form? This is a feature supposed to be changing and dynamic depending on user's choice. Isn't it?
neither this also hard-coded
Friday, October 19, 2018 6:37 AM | Pet Loki
Has been ever considered having .Net Core Framework included as part of CodeOnTime or will it be kept in the 4.6 framework even after releasing and later developments?
Friday, October 19, 2018 4:52 AM | Peter
Please consider this bug:

in the new version without using of CloudOnTime.

A solution to this error for the old version, i.e. without paying for an update, would be correct.

Thanks, Peter.
Thursday, October 18, 2018 7:40 PM | Bernard
I deployed a massive project and only experienced one minor bug that was resolved temporarily without losing any functionality... (Great job COT dev team on your product!!) however... please don't forget to check that this minor bug is fixed in your new release ...

When expanding the filter at the top of the grid (the hour glass) to allow advanced filtering on a specific field ... (the problem is only when a "model" filter exists) an error comes up. (had this in both 8680+8740)

Detail..- when filtering on a chosen field in the expanded filter area.. (not when clicking directly on a grid column and using "text filters" this works fine)... However whenever the users use the advanced filter and whenever the controller contains a filter **from the Model area (not a grid filter)**, the SQL "and" clause that should be appended at the end of the where clause just before this Model filter is omitted causing the SQL select to fail.

To overcome this we've simply asked the users not to use the advanced filter for those controllers containing a filter(in the model) and have asked the users to simply use the advanced text filter directly off the grid column.

Thursday, October 18, 2018 5:37 PM | RREYES3
Wanted to display grid headers slanted/vertically as in image below. How can this be achieve for a specific grid?

Thursday, October 18, 2018 2:28 PM | Pet Loki
It seems to me that, regardless of knowing that this post will be rapidly erased and maybe I will be suspended from participating any longer in this community, but it is quite true and unmistakably a valid assertion and also a valid concern that

COT hasn't released and update during 124 DAYS until today

That is really concerning. Isn't it?
Thursday, October 18, 2018 10:32 AM | Beyta
I create custom Report.. How to supply filter for date range..

Current setting inside Data text field..



i want the report show => "dateCeased between DateFrom and DateTo.."
Tuesday, October 16, 2018 7:13 PM | Jonesy
Here's another shout out to COT's consultation service!

In 1 hour Serge saved me many days of work.
I've never had a consultation yet that didn't give me exceptional value.

The only downside was the terrible new Cisco conferencing application (nothing to do with COT).
I could not give control of the screen, which I believe is essential.
Serge sent me a link to the recording but even after using Cisco's help desk I could not download it.
After doing a lot of web conferences lately using Zoom I think Cisco is a poor substitute. Again nothing to do with COT & Serge!


Tuesday, October 16, 2018 7:37 AM | Kurt Crossman

I need to populate a dropdown dynamically. However, the data source will not be from a sql, but from a RESTful service call. How would one achieve this?

Monday, October 15, 2018 8:12 PM | Brandy Riggs
I added a refresh interval on the page, but it won't auto-refresh the page.
I also added 60 second refresh intervals on each view page
Monday, October 15, 2018 12:06 PM | scdev

Touch UI does not offer user-friendly filtering options for timespans (neither for DateTime field or TimeSpan (time(0)) fields...

For instance when using a DateTime field in the database for storing timings, the user is presented with a nice timing table which behaves well when exported to Excel, but...

Filtering is not an easy option, because you have to enter "1/1/1900 HH:mm:ss" to set a valid "timefilter". The choice list only displays 00:00:00, etc...

See below:

Using timespan as a COT UI Type and time(0) as a SQL backend format does not solve the problem either because the Touch UI filter treats this as a number and does not allow entering filter numbers formatted as HH:mm:ss timespan.

Is there any way to customize the actual format of the filter data in a 'before' phase.

Like adding the prefix "1/1/1900 " automatically for instance?

Monday, October 15, 2018 4:43 AM | Kedar
Hello Team,
I have a query to call Business Rule using action.
I have created business rule for sending email on update action. When I update a record from controller, email rule executes properly.

Then I created SQL action for approval of that record. after that I want to execute the same email business rule again.
How can I do that?
Monday, October 15, 2018 12:56 AM | Pet Loki
Anyone has experience developing a Point-of-Sale using COT ?
(willing to share its knowledge on how to do it in real life)

Can't figure out how to customize (prettily) a beautiful form (inside COT project) in which I could manipulate the cashier input of the scanner bar-code reading going to the products catalog and doing the search of the data and then displaying the product's: name, price, taxation, discount, brand and also having (this is quite important) the boxes and buttons required to authorize a change-of-price in the case of an item improperly labeled its price (operational store error), adjusting price to competitors-price and so on which requires having a mean of an authorized person but the cashier in order to allow continuing the sale to the customer

like for instance:

Monday, October 15, 2018 12:21 AM | Pet Loki
Can they work together somehow?
Monday, October 15, 2018 12:20 AM | Pet Loki
Is possible making a call to an external exe program from inside a COT project?

I want to execute a read task of gathering some info stored in a license file of my own which I don't want to disclose as a sql server SP or as a .Net program
Saturday, October 13, 2018 8:37 PM | altVader
COT does many to many relationships nicely with the ability to build a checkbox list that shows all the selections in the child table related to the master table.

It also does dependent lookups nicely where you can filter items in a lookup control. The examples are one to many only though. So, filtering shipping addresses based on the selected person is easy to do.

I need to go one step further. My master table has two many to many relationships. The first lookup functions like the standard one to many examples. I want to filter the second lookup based on the selections in the first lookup.

So if your master table is Cars and you have a many to many relationship with Parts and there are 3 parts selected, I want the next lookup (PartManufacturers) to be filtered to only show manufacturers for the 3 selected parts.

Anyone know how to do this? .
Saturday, October 13, 2018 7:50 AM | Emerson


May i know, how can i do this in touch-ui default login form?

Thank you.
See All Posts