News & Activity Feed

New Video: Forcing Users to Act »
Learn how to force the app users to perform a specific action, such as signing of End User License Agreement. We will present the user with the EULA and allow access to the app only upon acceptance of the agreement. Client-side script will invoke the server-side custom business rule to allow signing of the agreement.
Sunday, September 15, 2019 9:40 AM | Christian
I need to create an action that allows the user to set a field value of all selected (or visible) rows in the grid. For example "Set the field "payed" to true on each selected row".
Any suggestion?

Thanks!
Sunday, September 15, 2019 12:21 AM | Ossama
Hi,
I have recreated certain tables and copied businesses from the old tables and adjusted them for the new controllers. When it came time to remove the old tables/controllers, newly created business rules disappear.
I tested several times to confirm that there is a direct connection between deleting the old controller with the disappearance of the business rules in the new controller.

How can I break this dependency? not sure why it is happening or where to look.

Thank you
Saturday, September 14, 2019 4:52 PM | Marc Van Gestel
Hello COT,

we are using a pivot with area chart, where the value fields are marked with tag 'pivot1-val1-sum' and the second one has tag 'pivot1-val2-sum'. The x-axis is a month (1-12) tagged as 'pivot1-row1'

The fieldnames are used in the legend, and not the 'Label' info. And the fieldnames are created by the SQL-query.

Debugging of this problem brings me to 'Viewpage.cs' in the following code :

public virtual FieldInfo GetValueField(int index, DataField field)
{
FieldInfo info = null;
if (ValueFields.ContainsKey(index))
{
info = ValueFields[index];
if (info.Field.Name != field.Name && ((info.ValueField == null) || info.ValueField.Name != field.Name))
throw new Exception("Duplicate value field declared in pivot.");
}
else
{
info = new FieldInfo(field);
ValueFields.Add(index, info);
}
return info;
}
}

When the second ValueField is added (ValueFieds.Add(index, info), the data in the page.pivot[0].Data[0] changes and contains the Field.Name.

I trying to locate the problem so I can solve it, but I have to give up. Hopefully this is interesting for you.

Thanks,

Marc
Saturday, September 14, 2019 5:10 AM | Carlos Flores
help, I need to create a report pivot and I have developed it in Sql server, then I made a controller and I put the stored procedure, the problem is that my report is dynamic and the controller is not updated di change my SP, some idea so that my controller is updated or how can I generate pivot report in codeontime
Friday, September 13, 2019 9:24 PM | Christopher Fox
I am a member of a homeowner's association board of directors. Sometimes we would like to let members vote on a proposed action, but we only meet every 60 days. I would like to provide a way for persons to cast votes via the COT website. Has anyone done this?
Friday, September 13, 2019 7:11 PM | bp app
Hi,

I have the following that filters if the user is not the owner.

if (!UserIsInRole("Owners"))
RegisterAccessControlRule("CreatorID", AccessPermission.Allow, UserId);

My question

How do I add "AssignedToID"?

because "CratorID" is being treated as a string, I cannot use OR

Thanks!
Friday, September 13, 2019 1:34 PM | Francesco Letari
Hi all,
we need to have infinite scroll directly in grid of details view.
I tried to set "page size" to 200 in DataView but it keeps on showing always few records.
How can i manage it?
Franco
thx
Friday, September 13, 2019 1:13 PM | Jeffrey White
What is the best process to backup COT projects? I want to archive project files and database to cloud storage like DropBox, Box or other.
Thursday, September 12, 2019 1:45 PM | bp app
I have used geocomplete in most of my projects.
I have used it to generate 'Companies' data quick, and users love it!

But in COT I have serious problem on tackling it, has anyone been able to accomplish that?

Would you be interested in sharing with our community?

Please

https://github.com/ubilabs/geocomplet...
Thursday, September 12, 2019 10:02 AM | boonchoo chatsrinopkun
where can i use the original business objects, the "Data.Objects" on the server side coding?

reference --> https://codeontime.com/blog/2009/04/u...

does it has any successor, where i can easily manipulate the created controller objects?
Wednesday, September 11, 2019 9:35 PM | Ola
COT,

Is there any reason why navigate action will not function in a SPA app with URL hashing?

I have tried both navigate action and Result_URL sql function, the app simply would not navigate in response.

Is there something I may be doing wrong?
Wednesday, September 11, 2019 4:55 PM | Oscar
COT 8.7.13.0 Premiun

I have a Touch UI web site, How can I add a recovery password to a standalone login? the setting is activated
Wednesday, September 11, 2019 1:21 PM | Emerson
Hi,

May i know, how can i get the selected data from grid1 if i call the controller from client side?

$app.touch.show({
controller: 'MyCountroller',
startCommand: 'Select',
startArgument: 'grid1'
});
Wednesday, September 11, 2019 6:07 AM | Ganiyu Kamoli
To activate my code on time unlimited version is becoming challenges, I used the product very well until I receive upgrade from Microsoft on my windows 10 from build 1803 to 1903, now code on time app refuse to launch, this is a standalone system, not systems on the corporate network. can anyone assist me. does the license expire. is this a scam, I bought it October 15 2018 meaning my 1year anniversary is still active, I have engage support and seems no one is ready to help...I am not happy with this development but asking in this forum if anyone can help.
Wednesday, September 11, 2019 4:20 AM | Emerson
Hi COT,

I've try the example provided in below link
https://codeontime.com/learn/user-con...

Sample work just fine in Desktop Version. But not in touch ui version.

Here is my code:-
Client Side:
<!--
<div id="uc_CustomPage" data-app-role="page" data-activator="Button|uc_CustomPage">
<asp:UpdatePanel ID="UpdatePanel1" runat="server">
<ContentTemplate>
<div style="margin-bottom:4px">
<h2 style="margin-bottom:4px; margin-top:6px;">Select a filter:</h2>
<asp:Button ID="Custom1" runat="server" OnClick="Custom1_Click" Text="Shipped" />
<asp:Button ID="Custom2" runat="server" OnClick="Custom2_Click" Text="Not Shipped" />
<asp:Button ID="Custom3" runat="server" OnClick="Custom3_Click" Text="High Freight" />
<asp:Button ID="Custom4" runat="server" OnClick="Custom4_Click" Text="Reset" />
</div>
</ContentTemplate>
</asp:UpdatePanel>
</div>"
-->

Server Side:
protected void Custom1_Click(object sender, EventArgs e)
{

}
// filter ShippedDate to null
protected void Custom2_Click(object sender, EventArgs e)
{

}
// filter Freight to >30
protected void Custom3_Click(object sender, EventArgs e)
{

}
// reset filter when Reset button clicked
protected void Custom4_Click(object sender, EventArgs e)
{

}

How can i solve this in Touch UI?

Thank you.
Wednesday, September 11, 2019 4:14 AM | Paul
I have a Model/Controller that I want to delete and start again, how can this be done?

Thanks
Paul.
Wednesday, September 11, 2019 1:46 AM | bhiggs
So I have done extensive testing of this and have come to the conclusion that COT does not like SQL While Statements and breaks them every time.

Why do I say this because I know for a fact my SQL code works perfectly fine in MSSMS but does not work when in my business rules.

Example Code:
This is the code I am running on MSSMS

-- This will tigger and send the email to all the Managers
DECLARE @ManagerEmail NVARCHAR(40)
DECLARE cursor_EmailList CURSOR
FOR SELECT EmailWork FROM Employees WHERE JobRoleID = 1
OPEN cursor_EmailList
FETCH NEXT FROM cursor_EmailList INTO @ManagerEmail
WHILE @@Fetch_Status = 0
BEGIN
PRINT 'Manager Email: ' + @ManagerEmail
FETCH NEXT FROM cursor_EmailList INTO @ManagerEmail
END
CLOSE cursor_EmailList
DEALLOCATE cursor_EmailList


The above code will return two values and print them to the output.

The following Code is what I have in my Business Rule


-- This will tigger and send the email to all the Managers

set @BusinessRules_Whitelist = 'Nothing'
BEGIN
DECLARE cursor_EmailList CURSOR
FOR SELECT EmailWork FROM Employees WHERE JobRoleID = 1
OPEN cursor_EmailList
FETCH NEXT FROM cursor_EmailList INTO @ManagerEmail
WHILE @@Fetch_Status = 0
BEGIN
set @BusinessRules_Whitelist = 'NewTimeOffRequest_NotifyEmail'
set @Result_ShowMessage = 'Sending Email' + @ManagerEmail
FETCH NEXT FROM cursor_EmailList INTO @ManagerEmail
END
set @Result_Continue = 1
CLOSE cursor_EmailList
DEALLOCATE cursor_EmailList
END

The above code will only send a single email only to the second record in the list and ignores the first entry.

As you can see there are only slight differences between the two snippets of code.

I am at a loss to why I get all the results from the first but on get one from the second?

Any ideas would be great if there is an
Tuesday, September 10, 2019 9:42 PM | Lon W
version 8.7.14.0, trial.

on start up it looks like this error flashes by.

On selecting any option I get the same jQuery error.

Unusable to test if it doesn't let me do anything.

Tuesday, September 10, 2019 7:46 PM | Oscar
I want to execute a business rules after that user click edit button.

i did the rule but i cant make #
Tuesday, September 10, 2019 3:34 PM | Scott Freeland
As the title says. I have a COT app that renders fine with IIS Express. When I publish the app to the web server and configure IIS the application just loads up with a blank page and the javascript console is riddled with errors. I've re-compiled and re-published a couple times on a couple different machines.

The script from “http://localhost:8081/pages/home?Retu... was loaded even though its MIME type (“text/html”) is not a valid JavaScript MIME type.
home

The script from “http://localhost:8081/pages/home?Retu... was loaded even though its MIME type (“text/html”) is not a valid JavaScript MIME type.
home

The script from “http://localhost:8081/pages/home?Retu... was loaded even though its MIME type (“text/html”) is not a valid JavaScript MIME type.
home

The script from “http://localhost:8081/pages/home?Retu... was loaded even though its MIME type (“text/html”) is not a valid JavaScript MIME type.
home

The script from “http://localhost:8081/pages/home?Retu... was loaded even though its MIME type (“text/html”) is not a valid JavaScript MIME type.
home

The script from “http://localhost:8081/pages/home?Retu... was loaded even though its MIME type (“text/html”) is not a valid JavaScript MIME type.
home

The script from “http://localhost:8081/pages/home?Retu... was loaded even though its MIME type (“text/html”) is not a valid JavaScript MIME type.
home

The script from “http://localhost:8081/pages/home?Retu... was loaded even though its MIME type (“text/html”) is not a valid JavaScript MIME type.
home

The script from “http://localhost:8081/pages/home?Retu... was loaded even though its MIME type (“text/html”) is not a valid JavaScript MIME type.
home

The script from “http://localhost:8081/pages/home?Retu... was loaded even though its MIME type (“text/html”) is not a valid JavaScript MIME type.
home

The script from “http://localhost:8081/pages/home?Retu... was loaded even though its MIME type (“text/html”) is not a valid JavaScript MIME type.
home

The script from “http://localhost:8081/pages/home?Retu... was loaded even though its MIME type (“text/html”) is not a valid JavaScript MIME type.
home

SyntaxError: expected expression, got '
unicode.min.js:1
ReferenceError: Web is not defined
home:104:613
See All Posts