Thursday, July 18, 2019 11:27 PM | Paul
Actions being deleted by COT without any warning, which has happened twice now in the last 2 weeks. I checked in my changes to GIT, and in the afternoon, action stopped working. I compared the Source to local and can see the actions has been deleted from the XML.
What I think has caused this is that I generated a new DB from the Scripts I generated from the current DB and point COT to the new DB. I think this caused the issue, though the tables are the same. Not sure why COT would delete Actions though.
The same problem lies with I originally created Controller from DB (via the Modal designer) and then converted this to a Custom SQL. A week later, I deleted the View that I originally used and then the Controller also got deleted.
Is there a document/process that I need to follow to ensure these don't keep happening?
Thursday, July 18, 2019 3:27 PM | Ivan Borges
Hi.
I have an Integer field which is set as a Drop Down List item style. Basically, it will have values 0, 1 and 2, so I added 3 items to it, with their respective Texts, like "value0", "value1" and "value2", for example.
I use this field as a Status field and then I have set its Controller Status Bar to it, working perfectly.
Now, I have set a Chart to this Status too, something like this: pivot1-row1-column. And in the value field to sum for each status, pivot1-val1-sum.
The Chart shows fine, however, the columns are named after the Status integer value, like 0, 1 or 2, and not the Drop Down List of texts assigned to each of the values expected.
Would anyone know how I could show the Drop Down List texts in the chart for this case?
Thanks in advance.
Ivan
(COT 8.7.13.0, Unlimited, TouchUI, SPA)
Thursday, July 18, 2019 12:05 PM | Ahmz Beydoun
I have recently downloaded thee FREE trial of codeontime. I am wanting to test this for a few months - i.e. create my web app - export it and run it in IIS - Will the IIS exported code expire at all?
Wednesday, July 17, 2019 5:13 PM | bhiggs
I have written a stored procedure that works beautifully and inserts the rows I need as I expect it to do so with the pass values.
This procedure inserts a bunch of rows into another table based off the primary key of the new record (@ScheduleWeekID)
I have added the following to my web.config through the tags manager in COT
AppendChild: /configuration/appSettings
<add key="SqlCommandTimeOut" value="300"/>
SetAttribute: /configuration/system.web/httpRuntime
executionTimeout:300
Here is the SQL code for the business rule
DECLARE @MyReturn INT
EXEC AutoPopulateWeeklyScheduleItems @ScheduleWeekID,@outputReturn = @MyReturn
IF @MyReturn <> 0
BEGIN
set @Result_ShowMessage = 'OOPS, Something is borken'
set @Result_Continue = 1
END
ELSE
BEGIN
set @Result_ShowMessage = 'Auto populate complete!'
set @Result_Continue = 1
END
The New Record is inserted into the table
The AutoPopulateWeeklyScheduleItems executes and completes (as there are values inserted)
I am getting the following warning/error
Wednesday, July 17, 2019 12:32 PM | ben aaa
Hi COT
I would like to bring in extra icons from Glyphicon into a COT application. Could you talk me through the process to get these icons from Glyphicon (paid version) into my COT project?
Thanks
baa
Wednesday, July 17, 2019 4:13 AM | Paul
I need to access the Query string from a Business Login. The business is executed via command Upload / External Document so that I can populate the user field (as the current viewer is not logged in). Currently cannot access any query string, filter, or field value.
We need to allow users to upload a document without being logged in . We picked up the Userid via a param. I got around this by using a Session variable when the page loads, however the session times out and back to square one!
Thanks
Paul.
Wednesday, July 17, 2019 2:07 AM | Scott Folley
I was debugging some code and came across the following. The value of a field was 104, but then it has a very strange new value and value , values. See picture. I ran the project on another computer, and it works fine. Could this be an issue with my computer? It's a few weeks old, I had just restarted it, but I have noticed some unusual behavior.
Scott
Tuesday, July 16, 2019 6:33 PM | Scott Folley
Can the name in the picture attached be changed without changing the name of teh controller?
Thanks
Scott
Tuesday, July 16, 2019 5:51 PM | bhiggs
Okay so having a lovely error since I did an update to Windows 1903.
I have done the following.
Uninstalled and Reinstalled COT
Tuesday, July 16, 2019 3:25 AM | Edd
Re COT quote
"Our next goal is to release Offline Data Processor and Offline Sync in update 8.9.0.0 due out by the end of June 2019. We are skipping 8.8.0.0 release numbering since both features are being released together. Cloud On Time for Android will be out in July 2019. The new roadmap has been prepared and will be unveiled soon!"
Some of us purchased our licenses based upon the roadmap and the features promised well over a year ago, and still awaiting delivery.
What I am asking is for a leniency on the expiration of licenses until version 9 is stable. As a customer I feel cheated if I paid for something on the promise of delivery and then found that, I acted in good faith, yet have not received what I paid for. This has hurt me financially with these delays - I would just like to be considered in this situation.
Monday, July 15, 2019 3:37 PM | developer guatemala
I have an identity in the database but due to integrity issues it will change its name it is possible to regenerate the name at the controller level or I have to change all the names that are related to this model
Monday, July 15, 2019 7:03 AM | Dhirendra Kumar Nayak
Dear All,
I wanna hide action buttons ("Edit" and "Delete") based on passing multiple condition, when I am passing like as below it's not working.
NodeSet().SelectActions("Edit" , "Delete").WhenClientScript("[RequestStatus] != 'D' || [RequestStatus] != 'R'");
It's working only in one condition.
NodeSet().SelectActions("Edit", "Delete").WhenClientScript("[RequestStatus] != 'D'");
Please suggest me for both (header and details) what need to change for above condition satisfied.
Thank you.
Regards,
Dhirendra Kumar Nayak.
Monday, July 15, 2019 3:13 AM | Steven Wright
COT Unlimited, latest version and VB. This is what I would like to achieve and hopefully someone can point me in the right direction. In my previous software (Ironspeed) I would just insert an image field onto the form through its toolbox but this is all new to me in COT.
I would like to have a small image displaying below a drop down selection list that changes depending on what value I select from the list. As an example let’s say I have three values in my drop down list: Red, Amber and Green. Each of these three values in my table also have an identifier for the image it needs to display e.g. Identifier for Red = 1, Identifier for Amber = 2 and Identifier for Green = 3
If nothing is selected then no image would appear below the drop down/selection list.
If the user selects a value then a lookup occurs to get the image identifier for the selected value e.g. for Red the lookup would return a value of 1. There would then need to be some sort of statement that returns the path to the image e.g. If the image identifier = 1 then set path to image for display on the create form to ../image/red.jpg which would then display a small red in colour circle shaped image below the drop down list.
In conjunction with the above is it possible to actually create an area/place holder below a drop down list or any other field on a create form for the image to exist and if so how is this done in COT?
Steve
Saturday, July 13, 2019 8:54 AM | Ahmz Beydoun
i am new to code on time. I have created a new table in sql. Added this as a controller - able to view in web as a grid - but no option to add or edit a row. How do i make these options appear?
Friday, July 12, 2019 8:53 PM | Ivan Borges
Hi.
I have a Lookup control which points to a controller that has Security set to Administrators only, so a normal User should not be able to add New records to it.
In this Controller Actions, I have set all of them to Roles: Administrators.
When a normal User edits the content of the Lookup control, a Create New option appears to them, as shown on picture bellow. If the user hits Create New, the controller page opens for the record to be added, but no Save or Cancel or anything is shown in the bottom, which is good, but not really the way it should be:
So, would anyone know if there is something else that should be set in order for a User without the proper Roles assigned to them not be able to see the Create New on the Lookup control?
Thanks in advance.
Ivan
(COT 8.7.13.0, Unlimited, TouchUI, SPA)
Friday, July 12, 2019 5:33 PM | Ola
I'm experiencing a rather strange behaviour with calendar view.
I've got a page set up with calendar view, this renders ok at development, but doesn't come out well when I published the project.
Attached are shots of the page during development and also when published.
Is there something I'm doing wrong?
Friday, July 12, 2019 9:21 AM | Ch Ch
Friday, July 12, 2019 2:42 AM | Steven Wright
I am running COT Unlimited on my work computer (Windows 7) but the left hand side of the application displays in what seems to be plain text and not the nice interface I am used to on my home computer. I was wondering if anyone can shed some light on this? Am I missing a file on my work computer or is the COT interface dependent on something in order to display it correctly? Have added a screenshot
When I select a model....
The above only happens when I select Design otherwise it renders correctly like below
Thursday, July 11, 2019 5:44 PM | Tom Graham
Does COT support barcode scanning/reading?
Thursday, July 11, 2019 12:14 PM | Ivan Borges
Hi.
Following the "Page Header and Copyright" Features page, I have used HTML tags to format our App Name / Page Header like below:
However, it seems this App Name is used as plain text in dialogs like the Login page and the results look ugly:
Would anyone know of a proper way to deal with this issue in a COT way, besides, of course, of not using the HTML tags at all? :-)
Thanks in advance.
Ivan
(COT 8.7.13.0, Unlimited, TouchUI, SPA)