Resetting records.
Hello. Trying to find out if there is a run process out there that resets a record. Now, I know that the command PERFORM-ACTION-APPLY simply commits a record to the database, but wondering if there is a similar command that reverts a record to its original state. Kind of like pressing F5 to refresh a record. The client wants a function to revert the record to its previous state or to load updated information from the form. Thanks. __ Connect with friends from any web browser - no download required. Try the new Yahoo! Canada Messenger for the Web BETA at http://ca.messenger.yahoo.com/webmessengerpromo.php ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Difference in APP-Management and APP-Support for ITSM 6.3 and 7.0
Hello. Can anyone tell me the difference between APP-Management and APP-Support? In 6.3, the APP-Management permission would give you access to the Remedy Management Console, whereas APP-Support would only have the Support Console. (And what is the difference between these two consoles anyway) And I think that these permissions are outdated in 7.0 but not sure, can anyone elaborate? Sorry for the dumb questions but my mind has just been stalled (must be the weather) and would like a quick answer. Thanks. __ Looking for the perfect gift? Give the gift of Flickr! http://www.flickr.com/gift/ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Complicated Crystal Report
To all Crystal Report Developers out there. I have been tasked to create what appears to be a very complicated report for a client using 7.0. They want to display a crystal report of a single Change Record. However, the problem is that they want this report to display the following: 1) information of the assets of the attached to the change (not just the info on the association record, they are looking for the product categorization of these assets) 2) all of the worklogs attached to the change 3) all of the approvers attached to this change 4) all of the tasks attached to this change. I know that there are join forms between Change-Association, Change-Worklog, and Change-Approver. I haven't been able to find the one for Change-Task but I think its there. Initially, I was thinking of combining the four joins into one join form containing a few fields from each of the other 4. But this poses a problem trying to group the entries. I know that Change ID will likely have to be the main group, but how to split all the association, worklog, approver, and task data into their own subgroups? Does anyone else have an alternate approach rather than the superjoin? As for trying to add information regarding Asset Categorization, I figure adding the categorization fields to the CHG:Association form and having workflow populate may do the trick, then bringing those fields into the Change-Association Join, unless anyone has a better idea on how to do this. __ Make your browsing faster, safer, and easier with the new Internet Explorer® 8. Optimized for Yahoo! Get it Now for Free! at http://downloads.yahoo.com/ca/internetexplorer/ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Date To Text
Hello. What is the best way to convert Date to Text? I'm trying to save timestamps on character fields for processing later. I know that Date is stored as an integer but is there a function in which I could save the text form of the date? Thanks __ Yahoo! Canada Toolbar: Search from anywhere on the web, and bookmark your favourite sites. Download it now http://ca.toolbar.yahoo.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Crystal Reports compatibility for AR 6.3
I am trying to create some reports on an AR 6.3 server. From what I have been told, you need Crystal Reports 9 for this to work. We are in the process of trying to obtain Crystal Reports 9 but I have been told that it will take some time. One option is that we would be looking for a 6.3 evaluation version for us to use in the short term until we can obtain an actual copy of version 9. Does anyone know where to get this? The Business Objects website only has the newest versions of Crystal reports. This brings me to my next question: I was wondering if newer versions of Crystal will work with 6.3, and what is the availability of those versions? I'm not sure if just going with Crystal 2008 is the right way to go. Thanks. Alex. __ Looking for the perfect gift? Give the gift of Flickr! http://www.flickr.com/gift/ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Real to Integer Comparisons
Hi. The client has a set up where they have a field called SequenceNumber. This field is a decimal number set to a precision of 2. The reason for this is because they have subsequence numbers, that is it goes like 1, 2, 3, 3.1, 3.2, 3.3, 4. The entries are being grouped by whole number, that is 3, 3.1, 3.2, 3.3 would belong to one group. But how to check for such numbers? One idea that I floated was to use the TRUNC function to get the numbers to round down. Then compare the sequence numbers against the truncated number, if they are between the truncated number and the number + 1, then that is a record that you're looking for. The problem that I have is that such a comparison is likely to trigger a type mismatch error. Comparing a real to an integer is not supported in any ARS, is it (I'm using 6.3)? Anybody got any ideas on how to do this? __ Looking for the perfect gift? Give the gift of Flickr! http://www.flickr.com/gift/ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Field 112 and ARS 6.3, how does it work?
Is there any way to include multiple groups on field 112 to restrict access to entries on a system with ARS 6.3? I know 7.0 allowed you to put multiple groups in but I have tried with 6.3 without much success. Thanks. __ Looking for the perfect gift? Give the gift of Flickr! http://www.flickr.com/gift/ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are