AppFrame

Build 5 - Update 7


Release date: 14.03.2011


Prerequisites:

Build 5 - Update 6

Client:

Build 5 - Update 7 Client

This update contains:

AppFrame Web4.

Please read this article for more info.

Changes to WinClient Projects:


  • Sys.Database.Objects
  • Sys.Import.DataImport
  • Sys.Mail.DocumentTemplates
  • Sys.QA.ExcludedObjects
  • Sys.QA.Issues
  • Sys.QA.Overview
  • Sys.QA.Products
  • Sys.Reporting.ReportBuilder
  • Sys.Security.ManageCalendars
  • Sys.Security.ManageDomains
  • Sys.Security.ManageGroups
  • Sys.Security.ManageMasterGroups
  • Sys.Security.ManageUsers
  • Sys.Security.NavigationAdmin
  • Sys.WinClient.Assemblies
  • Sys.WinClient.ClientRuntime
  • Sys.WinClient.CR3Projects
  • Sys.WinClient.Main
  • Sys.WinClient.Profiler
  • Sys.WinClient.Reports
  • Sys.WinClient.ReportsAR

New WinClient Projects:


  • Sys.WebClient.WebsiteCMSAppDesigner
  • Sys.WebClient.WebsiteCMSGraphs
  • Sys.WebClient.WebsiteCMSTweets
  • Sys.WinClient.DomainWizard

Renamed WinClient Projects:


  • Sys.WebClient.WebSiteCMSArticles (Sys.Admin.WebsiteArticles)
  • Sys.WebClient.WebSiteCMSSetup (Sys.Admin.WebsiteCMS2)
  • Sys.QA.IssueTracker(Sys.QA.SupportCentre)

Changes to database objects:

There has been a change in dbo.stbl_Navigation_ItemsPermissions, this change require you to update all records in the table. Use this script

After you have run this script you need to use Redgate SQL Compare and compare your database with R3CurrentBuild(Can be downloaded from the bottom of this site).

Database permissions

Please read the Database permissions section in this Article.


Resolved Issues:

DescriptionIssue ID
System Forms: R3 Upgrader: Should support the new permission handling in Navigation (Menu) doesnt work4820
afGrid: Applying a filter in AutoFilterRow refreshes datasource twice... 4760
afGrid: Delete filter row If you click the delete button when you have selected the filter row, you are prompted if you want to delete the row. If you answer OK, it will delete the first row in the grid.4737
System Forms: Groups\MasterGroups forms, Permissions tab, right grid should be scrollable horisontally Now the grid is not usable at low resolutions.4704
afGrid: Cancel adding new row Error: Object variable or With block variable not set. Steps to reproduce: 1. initiate new record; 2. press ESC4703
System Forms: Pressing Open on a CR3Assembly checks out the project too It should just open! BTW: there are bugs with deleting the existing files when openning the assembly too...4672
Other: Create mailbox action does not use the result of the dialog. How to reproduce issue: Open the manage users form. Pick a user with no email address. Select the other tasks, create mailbox option. Enter an email address. Press ok. Nothing happens. The code does not use what is entered into the dialog. If you enter a blank email it skips out of the function on the email != "" check and does not inform the user that the action failed. I don't know what the business logic for this should be but I have a few suggestions. If it is not valid to enter a user with out an email address, disable the create mailbox option. Don't let the user enter a blank email, disable the ok button until they enter a valid address or press cancel. Don't do null operations and not tell the user, currently it just ignores what you enter as an email address. If you enter a blank email it does nothing at all.4644
afDataNavigator: Datanavigator filter is not cleared when you apply a filter in NavGrid 4641
System Objects: Delete permissions on groupsmembers Why do we need delete permissions on groups to delete groupsmembers IF EXISTS (SELECT * FROM sviw_System_MyPermissions MyP INNER JOIN stbl_System_Groups T1 ON ISNULL(MyP.Domain, '') = ISNULL(T1.Domain, '') INNER JOIN Deleted ON T1.PrimKey = Deleted.GroupRef WHERE MyP.TableID='stbl_System_Groups' AND ISNULL(T1.Domain, '') LIKE ISNULL(MyP.Criteria1, '') AND MyP.PGrant LIKE '%D%') GOTO ContinueTransaction 4626
System Forms: Manage Navigation Item Updated stored procedures: [sstp_Navigation_GroupsSave] ( Added new parameter @ModuleID ) [sstp_Navigation_GroupsDelete] (Changed parameters to @ModuleID, @GroupID) Update Navigation Items accordingly4609
System Forms: Submitting issue with file in MM Seems like you need to have select permission to the files table when submitting an issue with attachment.4604
System Objects: Open Dialog, recent items Should only list recent forms for current domain. the user might not have access to the forms in other domains.4594
System Objects: Manage Navigation, error when deleting a group Group deletion is made by GroupID, should be done by ModuleID, GroupID It tries to delete all groups with the same ID, should check for moduleID.4593
System Forms: NavBar: RecordInfo; Esc close dialog When clicking Info in NavBar and the dialog appears it should close on Esc button (KeyPressed)4585
System Forms: Manage Permissions dialog in "Manage Navigation Items" form, sort by domain In the Manage Navigation Items, when I want to add some more domains to a item, a "Manage Permissions" dialog appears. This should be sorted by domain! we have over 1000 domains and now they are not sorted. 4558
System Forms: Add Manage Domains to the Manage menu on top in Main client We use this form alot and should have a natural place on the Manage menu.4557
System Objects: Copy permissions in navigation does not copy revoke permissions Copy permissions in navigation does not copy revoke permissions4555
System Objects: CheckObjectUsage procedures do not search in CR3 Assemblies sstp_QA_CheckCR3ObjectUsage and sstp_QA_CheckDBObjectUsage4548
afGridLookup: afGridLookup refresh button next to search It would look better if it didn't have a border around the button ( todays refresh button ) see attached image4539
System Forms: SQL Profiler: Clear Log: Log is not cleared It only clears what's shown on the screen.4496
System Objects: stbl_Calendar_ namespace Should have FK's with cascade delete A pain in the .. to remove users with calendars.4484
System Forms: R3 Upgrader: Compare CR3 Items does not include Help URL When I compare CR3 Projects (or menu) it doesnt include/check for updated HelpURL (in CR3Projects). This must be transferred aswell.4455
afGrid: Pressing ESc twice should cancel new row. Pressing ESc key twice in a new line should cancel that row.4413
afFileHandler: Multiple files upload Cancelling one of the uploading file: - grid is not refreshed - temp record is not deleted - AllFilesUploaded event is not executed (there is no way to find out when upload is completed)4320
afFileHandler: Deleting a DataObject assigned to a FileHandler crashes the dev.environment. Getting several messages about "DataBound", then also databinded (this is a gramatical mistake by the way!) properties and then "Object reference not set to an instance of an object".4268
afDataNavigator: Critical bug - Updates get lost Make a change in a form, go the navgrid and filter -> Your change will be saved before /as the search is executed. But: Same changes and then search using the "SearchColumn" Search in the navigator -> Your changes does not get saved !!!4235
afGridLookupEdit: Clear content in a afGridLookupEdit field To clear content in a afGridLookupEdit field, we need to set AlowNullInput = True and TextEditStyle = Standard. In addition we have to ctrl+delete in order to perform an actual delete.4221
System Objects: Mail Subject length sstp_Mail_MessageSave takes subject as nvarchar(500) and tries to insert into a nvarchar(255) subject field in stbl_Mail_Messages causing the stored proc to throw a "String in binary data would be truncated" error. sstp_Mail_MessageSave should only take nvarchar(255)4208
Reporting: Report Parameters Report parameters list in report designer shows up empty even if the report has parameters. Change records source for parameters grid from stbv_WinClient_ReportsParameters to sviw_WinClient_ReportsParameters to solve this issue 4172
System Forms: Open Dialog disapears on using grids Column Chooser or Filter functionality Open "Open Dialog" right click on the grids header and choose Column Chooser or Filter Editor... When the column chooser is used the Open Dialog is hiden and when you are opening it again the Column Chooser window is there and when you try to close it the form disappears again. 4153
System Forms: No check if a node is inserted with spaces at the end There is no test if a node is is inserted with a space after last digit. Eg in 'Manage Navigation Items' the node 'Analysis' under 'Project Control Basis' there was inserted with a space after....4142
System Forms: Issues: Verify issue When clicking Verify Issue it should trigger an EndEdit first. If I enter Fixed in Release and click Verify Issue I need to click save first4113
General: CR3.OpenProject CR3.OpenProject("....", AssemblyLoader.OpenMode.Dialog) Does not open the dialog box on top of the CR3 application. It should send parameter Me when triggering the OpenDialog() --> OpenDialog(Me)4112
System Forms: Issues: Datasheet View, missing many columns In Issues I'm missing alot of columns in datasheet view. All columns should be available from column chooser + scrolling should be enabled. It would be very nice to have a batch update functionality as we have in PIMS CMS as well.4110
Reporting: UI Culture Name Reports uses the PC's regional settings for formatting of months and numbers instead of using the UI Culture Name/Culture Name settings in manage users.4099
System Forms: Manage Domains - Copy report logo does not update row/picture 4094
System Forms: Manage Domains - new Row not focused on after creating new domain 4093
System Objects: Manage navigation, "Select all" (domains) does not work You have to manually check each domain that should have permissions. "Select all" does not work. EDIT: Found out that you have added a field "MGDomains". The populateshortcuts procedure does not check it.4091
System Forms: Filter By section below NavGrid Once clicking the Options in the NavGrid it should set status bar "Loading xxxx" + it should indicate that its loading the data... If there is a big amount of data loaded it freeze a while...4064
afGrid: Filter by selection does not work on Integer column an exception is thrown when trying to append to a filter with filter by selection from an integer column4030
System Objects: sstp_System_Authenticate bug Procedure: sstp_System_Authenticate current: CASE WHEN IS_MEMBER('db_owner')<>0 AND IS_MEMBER('db_accessadmin')<>0 AND IS_MEMBER('db_securityadmin')<>0 THEN 1 WHEN IS_SRVROLEMEMBER('sysadmin')<>0 THEN 1 ELSE 0 END AS BIT) AS IsSecurityAdmin This actually require you to be db_owner + db_accessadmin + db_securityadmin OR sysadmin. This is a bit too much to require. 3999
System Forms: Manage Users: Create Mailbox Create mailbox and mailaddress is not working correctly. See attached image.3998
afGrid: In afGrid deleting using context menu does not always work (second time last or first) Steps to reproduce: 1. Right-click on the last row and choose Delete, confirm, row is deleted. 2. Right click on the last row (auto focused for you), choose Delete, confirm, row is not deleted! Same happens for first row or any other row if you delete the one that is auto focused after delete of previous! This does not happen if you use the delete key. Or if you switch focused rows back and forth it works fine again.3974
System Forms: Issues: Product dropdown under Issues, the dropdown for Product can't be cleared. There should be an option to clear this to have all items listed.3971
System Forms: ManageUsers CopyFromUser dialog does not return a user after filtering. After filtering users in CopyFromUser dialog and clicking OK, the focused row is the filter row and the error is raised in Copy Fav Groups / Copy Group Memberships from Existing User.3970
System Forms: CR3 Import Trying to run compare on WebsiteCMS projects is not working. Says "loading data" for several hours.3968
System Forms: Sys.WinClient.Main - Preferences "Mor than one group..." => "More"3948
System Forms: IssueTracker; File Attachments File attachments in CR3 is not possible when adding new issue3909
afGrid: Strange behavior in bit fields Clicking on bit field requires 2 click if you are inside the same record. If you change record it works fine with only 1 click !3848
System Objects: Not possible to rename reports (reportid) in report builder 3846
System Forms: There is no place to specify the description field of the views used in the reportbuilder 3845
System Objects: Reportbuilder Not possible to create new reports, the trigger tries to insert in permissions table, but the insert trigger in this table checks if you already have permissions and fails. new trigger: IF EXISTS (SELECT * FROM Inserted ins INNER JOIN stbl_ReportBuilder_ReportsPermissions perm WITH(NOLOCK) ON perm.ReportId = ins.ReportId INNER JOIN stbl_System_GroupsMembers GM WITH(NOLOCK) ON perm.GroupRef = GM.GroupRef WHERE perm.AccessLevel = 'Manager' AND gm.Login = SUSER_SNAME()) OR ((SELECT COUNT(*) FROM stbl_ReportBuilder_ReportsPermissions AS P INNER JOIN Inserted AS I ON I.ReportID = P.ReportID WHERE P.PrimKey <> I.PrimKey)=0) BEGIN3844
System Forms: Removing icons from Navigation Not able to remove an icon from module and groups3837
Reporting: When trying to import a repx file, the dialog doesn't list the files with repx extension 3836
System Forms: Dataimport does not work properly Says No Data, background worker fails to update/finish3834
afGrid: Pasting into child without the master ref included in RecordSource If I paste into a child grid where the master key field is not included in the child recordsource the pasting fails. 3812
System Forms: Main Client: UseDatabaseChecker Fails The check in Main.vb in the login project is checking against My.Settings.DatabaseServer and not the service list SQL Server. This means that when having a service list with several servers you never know wheter it should use remoting or not automatically. The check should be done when changing service in the dropdown. Not only on login.3800
System Forms: CR3 Import - missing connection name When I try to save a new connection but have left a name on the connection, I get a message and the dialog closes down. 3774
System Objects: Errors in system database objects in Appframe Build 5 Update 6 database There are errors in Build 5.6 Appframe Database, which is available for download from appframe.com Error updating : -sviw_System_GroupsAll - (doesn't exist in AppframeR2) -sviw_System_GroupsNotPersonal (Column HasMaster can not be specified twice. In AppframeR2 database it doesn't exist in stbl_System_Groups) -sstp_WebsiteCMS_Datasources (Invalid column name 'FieldName')3771
System Forms: Sys.QA.Overview - resizable panels Panels in the first tab should be resizable. If there are many findings, I want to be able seeing them all, without a need to scroll.3770
afLookupEdit: afLookupEdit throws exception on CTRL+Delete When I open afLookupEdit, select some value by using up and down keys and then press CTRL+Delete - "Object reference not set to an instance of an object." error message is thrown. Shouldn't show up.3762
System Forms: "Recreate all Views" - Views failed window When "Recreate All Views" operation is completed the "Views failed" dialog appears. If not closed at once and some operations with another windows are performed, the dialog gets hidden under the main client window which is "read-only" until the dialog is not closed. The only way to activate the dialog back again is through ALT+TAB. The dialog should also be resizable.3754
afGrid: Grid: Save record -> jumps to new record When clicking on the dirty indicator to save a record in the grid, it jumps to a new record. Expected behaviour: Should stay at same record3747
afDataNavigator: DataNavigator > Object Reference Error In a form w/datanavigator add a new record , input the same unique ID as an already existing id ( so that you get a FK error when trying to save ) .. instead of trying to click Save button click the New Record button in DataNavigator again... Click cancel in the message box "Do you want to cancel?"... this throws Object Reference Error (reproduced in Marketmaker on JanCB's machine)3742
System Forms: Error deleting user - Missing Table Cleanup There are alot of tables that should be included in the delete user procedure. Calendars + attached error is some of the tables sometime blocking me from deleting users.3741
System Objects: Manage Users bug (Menu Option is not showing up when user permissions are set correctly) The Manage Users menu option in PIM_R3_Dev and the new demo PIMS_R3_4 is not showing up even if my user has security admin permissions. I talked to Johnny about this issue and it seems like there is code that makes that menu option invisible after CR3 loads fully, because I can see the option Manage Users for a few seconds while the CR3 application is still loading and then it disappears.3740
System Forms: Manage navigation - Object ref when removing text in all groups (need to close the form to get it to work again) - The labels on top of the list boxes should be the same as in the WebSiteCMS permissions. Also the select all should have the same behaviour (not sometimes you see me sometimes you don't) - Support for adding permissions to mutiple items3736
afGrid: CellEdit mode when moving with arrow keys in Row Select enabled General issue with Row Select mode and Cell Edit / Select mode, we saw that when using arrow key’s when navigate it jumps from Cell Edit mode to Row select mode. For Example, it happen when you go through a cell that is Read Only, to fix this we need to set Allow Edit = True on Column – OptionsColumn. Can you do some testing and see what other settings on the Grid that can help use when using the arrow key’s. If possible, it would be nice if it was possible to never have Cell Select, but always Cell Edit Select. ?? If we find a solution in the grid properties to avoid Cell Select, lots of copy / past issues will also go away I think. Also when you select the row, and starting using arrow keys, it should start directly to Cell Edit mode and not Cell Select Ref: JanCB3735
System Forms: CR3 Projects form. Using Me.Name.Text in code is not appropriate. When you filter for a project in the navgrid there is the following issue: Despite you have records in Navgrid and the fields seem to be filled in, the Me.Name.Text string is "" and can lead to some troubles since it is used over the functions. For check out gets 2 'Object reference not set to the instance of an objects' errors after checknig out the project after filtering.3730
afGrid: Esc buttons hould not exit activeEditor. Esc button ? Is this something we can handle? If so, if you are in Cell Edit mode and do something, but click Esc you go into Cell Select and then its also Row Selected, should stay in cell edit mode and not go over to Cell select. Because then if you continue with arrow key you are focked with a new copy etc…. 3726
afGrid: Row paste check Before past, is it possible to check if it’s a hole Row that you got on your Clipboard, if so paste a new row in the grid and do not try to paste the row inside a cell. This happen if you use the arrow keys and do Cell Select + copy, then its copy the hole Row because when you have Cell Select, the row is also selected. This is probably Grid behavior so if we could check if the Clipboard has a hole Row, just paste as a new row. That’s better then the error msg we got today. Ref. : JanCB3723
afFilterBuilder: Optional Header - Not linked to the filters? If one of the filters have an optional header, this will "stick" if you select another filter. 3718
afGrid: Unable to cast object of type 'System.Data.DataTable' to type 'Appframe3.Win.Data.afDataObject'. I get this error when i try to select a row in the grid in App.CRM.Assets form, Depreciation tab3716
Reporting: Report Templates: Insert Table, Padding inside cells in table Omega's standard is too big. We get complaints that the default padding is too much. Competitive systems can squeeze twice as much data onto the reports compared to us... contact me if any questions3713
System Forms: Upload and Publish Sys.WinClient.ClientRuntime Pr now you get an error. Make it possible to upload and publish this project without error. Upload only Dll files, need to skip checking if Proj file etc is there.3712
afGrid: Replace/Update a row in grid doesn't work on paste (Row Select) I try to update/replace a row in grid. But paste tryes to store all the row in the first cell. Or the cells get mixed up (when there is read only field)3667
System Forms: Record Info doesn't work in the Manage Domains form Pressing Record Info in the Manage Domains form gives the following information on any record: Created: LabelControl5 Created By: LabelControl6 Updated: LabelControl7 Updated By: LabelControl8 PrimKey: AfTextEdit1 Record Info works in other forms.3655
System Forms: Sys.Import.DataImport When trying to import the attached file, which is produced in SAP, column 21 (U) fails. Error says: Input string was not in a correct format. Couldn't store < > in Column21 Column. Expected type is Double. It is the 3rd row that fails. If I go into the cell and type something and then delete, making the cell empty again, then it works. The code fails in Function GetData() on code line 88. The table that it is trying to insert to has NVARHCAR(20) for this column.3650
afAccesslayer: Help: SQL Profiler: Clean log does not clear the log 3592
afGrid: Paste into cell in grid -> Cursor ends up at the very start of the content 1) Pasting into a cell, either replacing the entire content or pasting after some other text, inserts the text correctly but the cursor ends up at the very start of the field/content. URGENT !!! 2) Possible a related issue: Pasting a percentage value => Error startIndex cannot be larger than length of string. Parameter name: startIndex3500
System Objects: Delete of domains delete Navigation Items permissions When deleting domains using sstp_System_Domain_Delete it removes the permissions for all menu items. This has happen many times now @ several clients...3497
System Forms: "SQL Profiler" is missing ActiproSoftware.SyntaxEditor.Net20 dlls PIMS_R3_DEV service: tried to run SQL Profile from CR3. Got error: --------------------- Application Error Could not load one of required libraries for Sys.WinClient.Profiler. Either required library version has not been added to CR3 Assemblies or use Specific Version has not been set on a reference. Details: Could not load file or assembly 'ActiproSoftware.SyntaxEditor.Net20, Version=4.0.284.0, Culture=neutral, PublicKeyToken=21a821480e210563' or one of its dependencies. The system cannot find the file specified. -------------------- Downloaded "Actipro" dlls, from CR3 Assemblies, started working.3491
System Forms: Application Styling problem (Summer 2008) Summer 2008 theme/styling Dropdowns in grids disappear. Can be seen ex in the Orders Form under Order Items. The Unit column has a dropdown box...3471
System Objects: [dbo].[sstp_System_AddNewUser] should be removed Putting this in one more time as it still exist. this procedure should be deleted as it doesnt work (Throws error when upgrading)3467
System Objects: Modify sstp_System_Domain_Delete to do batch deletes Today, when running sstp_System_Domain_Delete on big domains (large amount of data in tables) the table is locked. changing to use bulk delete instead does not affect performance that much. SET @SQL = 'WHILE EXISTS(SELECT * FROM [' + @Tablename + '] (NOLOCK) WHERE Domain = ''' + @DomainToDelete + ''') BEGIN DELETE TOP (1000) FROM [' + @Tablename + '] WHERE Domain = ''' + @DomainToDelete + '''; IF @@ERROR <> 0 BREAK; END'3197
System Forms: Upgrader: ValuelistRecordsource of database_Fields ValueListRecordSource's should be upgraded on the database fields table. this way we can populate the recordsources on our dev server and spread it out to all other servers. Today this process needs to be done manually on all server, and in most cases is forgotten on customers databases.3088
System Objects: sstp_QA_CheckDBObjectUsage - Should check for object usage in check constraints sstp_QA_CheckDBObjectUsage do not check for object usage in check constraints Also include jobs3071
System Objects: Missing clustered indexes Det er 176(!) tabeller uten clustered index på AppframeR2. Bryr meg ikke nevneverdig om atbl-ene, men eneste stbl-ene som ikke "bør" ha clustered er ActivityLog og DataLog. At Domains, MasterGroups osv ikke har er jo en skikkelig glipp som jeg/vi burde sett for leeenge siden SELECT OBJECT_NAME(id) FROM sys.sysindexes WHERE indid = 0 AND OBJECT_NAME(ID) LIKE '[as]tbl%' ORDER BY OBJECT_NAME(id) 2397


New Features/Changes:

DescriptionIssue ID
afGridLookup: Refresh button in lookup-does not refilter The new Refresh button on drop -down list could refresh all list in the table (before that I have filtered information). Now, If I would like to refresh/update information in drop down table, I have to press Enter. Even if the Search column is empty, after clicking Refresh, nothing happens, just after you press Enter information is changing.4693
afGrid: Copy in Pivot Investiage the possibility to use the same approach as in grid for copy data from pivot. Now there are issues with formatting.4612
Reporting: When loading Sys.Reporting.ReportBuilder one select is executed several times Loading two times when starting: SELECT TOP 1000 ReportID, FieldName, FormatType, FormatString, Alignment, FixedWidth, ColumnWidth, UnboundType, UnboundExpression, PivotLocation, SummaryType FROM sviw_ReportBuilder_ReportsColumns WHERE ReportID='Test001' 4581
System Forms: When loading Sys.Security.ManageDomains one select is executed several times Loading 3 times when starting: SELECT TOP 1000 Domain, DomainName, IsTeamMember FROM aviw_ProjectSetup_Persons_AllDomains WHERE [PersonID] = '1' ORDER BY Domain4550
System Objects: Support for must change password in sstp_Security_Users_CreateDBUser When creating and resetting user passwords we need to be able to set MUST_CHANGE keyword on the statement. This will force the user to change password on first login.4510
System Forms: Manage Domains - Create Domain The "Create Domain" function should also copy report logo4092
Other: Issue Tracker in marketmaker/cr3 client, possibility to paste in screenshot when you make a new issue ! Issue Tracker in marketmaker/cr3 client, possibility to paste in screenshot when you make a new issue !3994
System Forms: Open dialog in CR3 In the Open dialog form it is not possible to adjust the width of the different fields. Think this should be allowed.3975
System Forms: R3 Import (Upgrader): Upgrade Report We should have a report that shows each object that is updated + version change/description since last update. This way we can provide the client a log on whats been updated.3895
System Forms: CR3 - Projects -- Multibuild and checkins If you do not have all the projects checked out and then do a "check in and publish" in the multibuild, you'll get "do you want to check out.." question for each project. If its checked out by someone else, the question is valid, but if its not checked out it should be implied. Could also have a generic publish-comment so i don't have to type in a comment for each project.3838
afGridLookup: afGridLookup: New button next to Search textbox field In afGridLookup and afGridLookupEdit it would be nice to have a small refresh button at the very right side of the Search textbox at the top. This will force a refresh of the lookups data. (by user)3813
Reporting: Unable to see who made version changes to a report The report designer shows the current version number of the report, and if you click on it you get a drop down list that shows the history and comments for each version. However it does not show who made the changes. I can see what changes were made to the report I'm working on, but not who made them. This is a problem because the currently highest version of the report is not published to production, and I do not know it it is safe to do so or not. Since it doesn't show who made the changes I also do now know who to ask if it is safe to publish.3777
System Forms: R3 Upgrader (Import) There should be horizontal scrolling Date formats are not correct. Force Short ID Upgrade what does this do ? (Since its a global variable) Select by Filter ? (At the toolbar) Groups can be hidden as its not implemented 3751
System Forms: Manage Navigation Items: Re-Design See attached files for suggestion on new design in Manage Navigation Items.3737
System Objects: Look for an object in Jobs when executing sstp_QA_CheckDbObjectUsage Executing [sstp_QA_CheckDbObjectUsage] stored procedure I would expect Object to be also searched in Jobs scripts.3722
System Forms: Manage Users: New Domain Wizard In addition to the Manage Users there should be a toolbaritem inside Manage Users to launch a Wizard to create a new user. This wizard will guide you through the steps 1: Create userid/name 2: Grant group memberships 3: set domain 4: set password 5: set startup forms If this is created it will make the level for creating new users lower (clients always tend to forget either setting domain or startup forms)3678
System Forms: WebSite CMS Apps into CR3 Imports We need to get support for importing Web apps from WebSite CMS namespace.3663
System Forms: Manage Users: Grant DBO/SecurityAdmin/afDeveloper It should be possible to grant other logins with DBO and Security Admin so that we can manage everything from Manage Users. Not having to go into SSMS to modify the super users accounts.3612
System Forms: Create New Domain Wizard In PIMS CMS I've just created a new Domain Wizard where we set up which tables that should be copied etc dynamically. Would this be an idea to implement into the framework as there are no good ways for regular users to create new domains today. For example see attached movie.3541
System Forms: Automatic set specific version true CR3 Project should have a check if all dll's have been set to specific version true. If not, an error message should be displayed.3436
System Forms: Issue Tracker - Not possible to attach files ? "Support Center - Issue Tracker" I can not attach a file using this one. It whould be interesting to have our users accompany their issue report with attachments. They are used to doing this today when they report bugs via email etc.3404
System Objects: Procedure refreshing views (sstp_Database_Maintenance_RefreshAllViews) should be updated sstp_Database_Maintenance_RefreshAllViews object might be updated a bit to become more useful. First of all - we don't always need to refresh ALL the views in the DB - job should be done for it. Normally we use the procedure when we need to refresh one view, or several views in some module. So there might be an option to run procedure for one view or one module. CR3 functionality should be updated accordingly. Another thing - we usually face the aviws having something like "SELECT V1.* FROM atbv.. AS V1". Say you've added another field to atbv used in aviw - your aviw will show wrong data. In this case, to refresh the aviw, you have to run the refreshing procedure twice - to update atbv first and then aviw itself. It even more deeper if there is an arpt, using an aviw, which has "SELECT *" inside. So this should be done automagically inside the procedure. 2717
General: Updated TeamDocs and EMails loaded too often I understand that these are loaded every 30 secs now. The Current Domain, I can see. Getting out of sync with this is dangerous. But TD and EMails are a very big distraction that we should at least be able to reduce. We need to be able to set this sync frequncy pr User. I would like for noone in my team to have less than 10-15 minutes between each poll. 1881


Downloads: