Re: [URGENT] - Need to clean up all INC/CR/PBI/SR records and set the counter from xxxxxxx01
Sorry. I do NOT want to open a can of worms here, but I do this regularly (and in minutes), through the API, and to all forms including root requests, CMDB, and every aspect of Foundation data. The only SQL one would need is the resetting of the next id (which I generally don't do as I don't tend to care what request ids get assigned). These days they tend to be hidden anyhow. The root requests ids (Incident Number etc) are NOT request ids '1' and so the API can also be used there - though it's nice if the Incident Number matches the Request ID. This will not be the case for long in a production environment BTW. So, I tend to have systems with Operating Companies not starting at 1, Support Groups Ids starting at 500ish, and very few tables starting at IDs of 1. As for referential integrity (presumably you mean not leaving hanging records) you are relying on Remedy workflow. Whilst the newer versions are better, there are still a lot of hanging records left, so yes, understanding (ie analysis) of the data structures is important. I always delete in bottom up order just for the sake of performance because there is no way to inhibit delete filters through the API. A delete of say 1000 Change templates would take hours top down but minutes bottom up. Workflow still fires but with no effect. Cleansing is trivial. I expect you are way under in your Analysis estimate though :) Perhaps years rather than days. Especially given some of the convoluted ways some tables are used and the fact that very little is documented. 'Nuff said on the matter. Cheers Ben Chernys www.softwaretoolhouse.com -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of J Lander Sent: May-16-13 06:46 To: arslist@ARSLIST.ORG Subject: Re: [URGENT] - Need to clean up all INC/CR/PBI/SR records and set the counter from xxx01 What you are asking for is possible but a very large undertaking. It also relies on the person having decent SQL and Remedy ITSM skills. The suggestions from others in this post are worth considering. I have performed the data cleanse a few times in the past and it is not a pretty job. It involves performing thorough in-depth analysis of every single form using SQL (to identify test data both for main forms and their supporting ones) and documenting what exactly will be removed and what needs to stay. Forms which have a customer facing Ticket ID (e.g. Incident, Problem, Change etc) would have their counters reset to a value of 1 in the arschema table but the rest would not. You would also need to take a full backup of the database before any data is deleted (obviously). Foundation and Configuration forms should not have any data removed. Please note that even if you did perform the above, it takes days to do. The analysis itself is probably 2-3 days. The cleansing is also a further 1-2 days. Most of it also needs to be done via the User Tool/Mid-Tier. This allows for any workflow to fire that keeps referential integrity. What you should have done, and is the recommended best practise, is to backup the database when it was ready for testing, perform testing, remediate defects, test remediations, export workflow/data, restore database, apply fixes, backup database, shake test, cancel shake test tickets, backup database, move on to next testing phase. This way you would always have had a database which contain very few tickets but all config, fixes. customisation etc. It's a little cumbersome, but it prevents the issue you are facing now. Cheers, J ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years - No virus found in this message. Checked by AVG - www.avg.com Version: 2013.0.3336 / Virus Database: 3162/6325 - Release Date: 05/15/13 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years smime.p7s Description: S/MIME cryptographic signature
Re: [URGENT] - Need to clean up all INC/CR/PBI/SR records and set the counter from xxxxxxx01
What you are asking for is possible but a very large undertaking. It also relies on the person having decent SQL and Remedy ITSM skills. The suggestions from others in this post are worth considering. I have performed the data cleanse a few times in the past and it is not a pretty job. It involves performing thorough in-depth analysis of every single form using SQL (to identify test data both for main forms and their supporting ones) and documenting what exactly will be removed and what needs to stay. Forms which have a customer facing Ticket ID (e.g. Incident, Problem, Change etc) would have their counters reset to a value of “1” in the arschema table but the rest would not. You would also need to take a full backup of the database before any data is deleted (obviously). Foundation and Configuration forms should not have any data removed. Please note that even if you did perform the above, it takes days to do. The analysis itself is probably 2-3 days. The cleansing is also a further 1-2 days. Most of it also needs to be done via the User Tool/Mid-Tier. This allows for any workflow to fire that keeps referential integrity. What you should have done, and is the recommended best practise, is to backup the database when it was ready for testing, perform testing, remediate defects, test remediations, export workflow/data, restore database, apply fixes, backup database, shake test, cancel shake test tickets, backup database, move on to next testing phase. This way you would always have had a database which contain very few tickets but all config, fixes. customisation etc. It's a little cumbersome, but it prevents the issue you are facing now. Cheers, J ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
[URGENT] - Need to clean up all INC/CR/PBI/SR records and set the counter from xxxxxxx01
Hi All, We are using ITSM 7.6.04 on Linux 5.5 ARS 7.6.03 We have been using this system for development and Implementation and during this testing period many users had raised several INC/CR/PBI/SR. Now we are all set to go-live and delete/remove all the test INC/CR/PBI/SR records and set the starting number counter to 0001 . Any quick Idea will be highly appreciated. Thanks in advance. Ziyan ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: [URGENT] - Need to clean up all INC/CR/PBI/SR records and set the counter from xxxxxxx01
This is a very bad idea. If you reset the counters and you have even one record remaining, you will be unable to create records because of a unique index violation. It's not just a matter of clearing out data in the incidents/change/etc. table, but all referential information as well. It's very easy to end up with orphaned data, and it's very easy to be over-aggressive and delete more information than you need to. The fact that you are coming to the list with this question labeled urgent means that the only recommended path would be to run a database backup and then leverage the built in functionality for querying and subsequently deleting records. Do not attempt to reset the ID counters. It's much better to go live with counters starting at 23419 than to go live with counters starting at 0 and carrying a risk that would require dependency on a mailing list to resolve. --Steve On Mon, May 13, 2013 at 11:08 PM, syed Ziyan syedziya...@gmail.com wrote: ** Hi All, We are using ITSM 7.6.04 on Linux 5.5 ARS 7.6.03 We have been using this system for development and Implementation and during this testing period many users had raised several INC/CR/PBI/SR. Now we are all set to go-live and delete/remove all the test INC/CR/PBI/SR records and set the starting number counter to 0001 . Any quick Idea will be highly appreciated. Thanks in advance. Ziyan _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: [URGENT] - Need to clean up all INC/CR/PBI/SR records and set the counter from xxxxxxx01
It's possible to delete records via search and Ctl-D and have the workflow handle the dependencies (at least it was in 7.1) not sure about 7.6. We did this to clean out test data. However to stop you having problems it is best to move the NextID value to a larger number not backwards. I would recommend something like 1! Then there is no possibility of a clash. There are tables/forms that contain the next incident, change and ... numbers, these are not too hard find Stuart Schon Service Desk Systems - Manager Fujitsu Australia Limited From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Steve Kallestad Sent: Tuesday, 14 May 2013 5:04 PM To: arslist@ARSLIST.ORG Subject: Re: [URGENT] - Need to clean up all INC/CR/PBI/SR records and set the counter from xxx01 ** This is a very bad idea. If you reset the counters and you have even one record remaining, you will be unable to create records because of a unique index violation. It's not just a matter of clearing out data in the incidents/change/etc. table, but all referential information as well. It's very easy to end up with orphaned data, and it's very easy to be over-aggressive and delete more information than you need to. The fact that you are coming to the list with this question labeled urgent means that the only recommended path would be to run a database backup and then leverage the built in functionality for querying and subsequently deleting records. Do not attempt to reset the ID counters. It's much better to go live with counters starting at 23419 than to go live with counters starting at 0 and carrying a risk that would require dependency on a mailing list to resolve. --Steve On Mon, May 13, 2013 at 11:08 PM, syed Ziyan syedziya...@gmail.com wrote: ** Hi All, We are using ITSM 7.6.04 on Linux 5.5 ARS 7.6.03 We have been using this system for development and Implementation and during this testing period many users had raised several INC/CR/PBI/SR. Now we are all set to go-live and delete/remove all the test INC/CR/PBI/SR records and set the starting number counter to 0001 . Any quick Idea will be highly appreciated. Thanks in advance. Ziyan _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: [URGENT] - Need to clean up all INC/CR/PBI/SR records and set the counter from xxxxxxx01
Instead of deleting test data, modify so that it falls under a test Company Support Groups. If you change the starting number, set it ahead not behind your current IDs. Also, let your customer know that the ticket IDs will NOT be sequential because of the Next Request ID Block Size. Thank you, Sandra Hennigan Remedy Developer From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of syed Ziyan Sent: Tuesday, May 14, 2013 2:09 AM To: arslist@ARSLIST.ORG Subject: [URGENT] - Need to clean up all INC/CR/PBI/SR records and set the counter from xxx01 ** Hi All, We are using ITSM 7.6.04 on Linux 5.5 ARS 7.6.03 We have been using this system for development and Implementation and during this testing period many users had raised several INC/CR/PBI/SR. Now we are all set to go-live and delete/remove all the test INC/CR/PBI/SR records and set the starting number counter to 0001 . Any quick Idea will be highly appreciated. Thanks in advance. Ziyan _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: [URGENT] - Need to clean up all INC/CR/PBI/SR records and set the counter from xxxxxxx01
You do not have to set the next ID block size if you do not want to, or set it specifically for forms you want to and refrain from those you do not want to. Agreed its great for performance to set it, but performance may not be the biggest problem for small to mid size shops that do not use part or the whole system heavily. Also it is possible to reset to 1 if you want to, after you have customized all you want by exporting only the structures and 'meta-data' and skipping all application data, dropping the DB and recreating it by importing those structures and data, and then altering the data in the arschema appropriately. I have done it before and it works quite well. Although it is possible to do that, I like the idea of starting from XXX100 better especially if you are a small / mid-size shop. This takes less work and you're highly unlikely to reach the limit anytime too soon. Cheers Joe _ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Hennigan, Sandra Sent: Tuesday, May 14, 2013 7:44 AM To: arslist@ARSLIST.ORG Subject: Re: [URGENT] - Need to clean up all INC/CR/PBI/SR records and set the counter from xxx01 Instead of deleting test data, modify so that it falls under a test Company Support Groups. If you change the starting number, set it ahead not behind your current IDs. Also, let your customer know that the ticket IDs will NOT be sequential because of the Next Request ID Block Size. Thank you, Sandra Hennigan Remedy Developer From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of syed Ziyan Sent: Tuesday, May 14, 2013 2:09 AM To: arslist@ARSLIST.ORG Subject: [URGENT] - Need to clean up all INC/CR/PBI/SR records and set the counter from xxx01 ** Hi All, We are using ITSM 7.6.04 on Linux 5.5 ARS 7.6.03 We have been using this system for development and Implementation and during this testing period many users had raised several INC/CR/PBI/SR. Now we are all set to go-live and delete/remove all the test INC/CR/PBI/SR records and set the starting number counter to 0001 . Any quick Idea will be highly appreciated. Thanks in advance. Ziyan _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Counter
Hi, We can have solution as below to achieve this. Take a Configuration form (Regular Form) to store Form Name, View Name and View Access Count. Insert a record of each Views along with Form Name and View Access Count =0 respectively in the config form. Create a display only field (say z1d_Count) on the form for which view access count has to be calculated. Workflow- Write an Active link on Window Open Execution Option Action 1- Set field form the Configuration form (z1d_Count = 'View Access Count') Search qualification - 'Form Name' = $SCHEMA$ AND 'View Name' = $VUI$ Action 2 - Push field to configuration form (View Access Count=$z1d_Count$ + 1) qualification-- 'Form Name' = $SCHEMA$ AND 'View Name' = $VUI$ Action 3 - Set field form the Configuration form (z1d_Count = 'View Access Count') Search qualification - 'Form Name' = $SCHEMA$ AND 'View Name' = $VUI$ HTH -- Regards, ITSM Support Vyom Labs Pvt. Ltd. BSM Solutions Services || ITIL Consulting Training Email: mailto:i...@vyomlabs.com i...@vyomlabs.com || Web Site: http://www.vyomlabs.com www.vyomlabs.com Follow Vyom Labs http://twitter.com/#!/vyomlabs http://twitter.com/#!/vyomlabs || http://www.linkedin.com/company/vyom-labs http://www.linkedin.com/company/vyom-labs From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Ahmed Sauga Sent: Friday, July 20, 2012 1:32 AM To: arslist@ARSLIST.ORG Subject: Counter ** Hi Everyone. I was wondering if i could get some ideas. I thought i was on the right track but i guess not :S. Anyways, i am creating a basic counter on how many times the view of the form was visited. - I created a field called counter and made it read only. - I created an active link to set field Field = Counter Value = $Counter$ + 1 The results are: the field is blank and i can keep scrolling through the counter field on the form to 1234 Any ideas/suggestions/help would be appreciated. _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Counter
Very good one. This kind of log should be an OOTB option in ARS. I think I will do something similar and if it worth I would share it. El viernes, 20 de julio de 2012, Jason Miller escribió: ** We are venturing a bit off topic now... I have been doing what Jose describes for a while now. It started with customers politicking to have something built that they urgently need, I build it, they don't look at it for months and then come back saying what was built for them is all wrong and has never worked for them and they urgently need it changed. That has morphed in to a support and statistics tool. All most all forms are attached to one Active Link that creates a record in the tracking form. From this my team can see if a user is accessing via WUT or MT, the client version, etc. We have had instances where somebody reports that a feature/function is not working for them and when we looked they were still using the v6 WUT. We also get an idea of our busiest forms, those that can probably be retired and are able to research if people are accessing forms they shouldn't be (on a recent project I created a filter that disables the account if a form that shouldn't be access is opened). A word of caution, the form fills up fast. You'll want to make sure regular archiving is done to keep the record count reasonable. Back to the original question depending on how many forms you related to this AL and the volume of records you may or many not want to do a count from this form every time a your other form is opened. The screen print below is a mix of my original form and one I borrowed from a intelligent former coworker who happened to be doing the same thing when I join his team :) (just in case he recognizes it, I don't want to claim it all as my own) [image: Inline image 1] On Fri, Jul 20, 2012 at 12:42 AM, Jose Huerta jose.hue...@sm2baleares.esjavascript:_e({}, 'cvml', 'jose.hue...@sm2baleares.es'); wrote: ** I think that it is easier and better to create a log of use. Create a new form as Joe advised, not to store a number, but to store each time a user accesses. There is no need to add any field. Set the Created by to $USER$ and Short description to . Then your set action, would be a push action that sets the Short description to a dummy value (it could be the name of the form/view, so you can reuse the form to another views, as Joe suggested). This approach is even easier to do than the counter and provides some advantages: 1.- You can analize who and when opens the view. 2.- You can see the evolution of this number through time. Regards, Jose Huerta Jose M. Huerta Project Manager** Movil: 661 665 088 Telf.: 971 75 03 24 Fax: 971 75 07 94 http://www.sm2baleares.es/ SM2 Baleares S.A. C/Rita Levi Edificio SM2 Parc Bit 07121 Palma de Mallorca http://es-es.facebook.com/pages/SM2-Baleares/158608627954 http://twitter.com/#!/SM2Baleares http://www.linkedin.com/company/sm2-baleares La información contenida en este mensaje de correo electrónico es confidencial. La misma, es enviada con la intención de que únicamente sea leída por la persona(s) a la(s) que va dirigida. El acceso a este mensaje por otras personas no está autorizado, por lo que en tal caso, le rogamos que nos lo comunique por la misma vía, se abstenga de realizar copias del mensaje o remitirlo o entregarlo a otra persona y proceda a borrarlo de inmediato. _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ -- Jose M. Huerta Project Manager** Movil: 661 665 088 Telf.: 971 75 03 24 Fax: 971 75 07 94 http://www.sm2baleares.es/ SM2 Baleares S.A. C/Rita Levi Edificio SM2 Parc Bit 07121 Palma de Mallorca http://es-es.facebook.com/pages/SM2-Baleares/158608627954 http://twitter.com/#!/SM2Baleares http://www.linkedin.com/company/sm2-baleares La información contenida en este mensaje de correo electrónico es confidencial. La misma, es enviada con la intención de que únicamente sea leída por la persona(s) a la(s) que va dirigida. El acceso a este mensaje por otras personas no está autorizado, por lo que en tal caso, le rogamos que nos lo comunique por la misma vía, se abstenga de realizar copias del mensaje o remitirlo o entregarlo a otra persona y proceda a borrarlo de inmediato. P Por favor, no imprima este mensaje ni sus documentos adjuntos si no es necesario. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are image004.jpgimage001.jpgimage002.jpgimage003.jpg
Counter
Hi Everyone. I was wondering if i could get some ideas. I thought i was on the right track but i guess not :S. Anyways, i am creating a basic counter on how many times the view of the form was visited. - I created a field called counter and made it read only. - I created an active link to set field Field = Counter Value = $Counter$ + 1 The results are: the field is blank and i can keep scrolling through the counter field on the form to 1234 Any ideas/suggestions/help would be appreciated. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Counter
Read Only fields are OK to store fields.. Did you also make it ‘Display Only’ in your database properties as well? Display Only fields DO NOT store data.. Another note, I would not create that counter field on the same form as the current form however.. I would create a field on some other form that stores counters, and push values every time this form is opened from this to the other.. The reason being that this current form could probably be opened at the same time by 2 users.. what then? Consider that case.. Create another form for counters, have 2 fields, Schema Name and Counter, just in case you want to reuse this other form for some other forms counter.. And push both the $SCHEMA$ and retrieve its current counter value and add it and push that as well.. Cheers Joe From: Ahmed Sauga Sent: Thursday, July 19, 2012 4:01 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Counter ** Hi Everyone. I was wondering if i could get some ideas. I thought i was on the right track but i guess not :S. Anyways, i am creating a basic counter on how many times the view of the form was visited. - I created a field called counter and made it read only. - I created an active link to set field Field = Counter Value = $Counter$ + 1 The results are: the field is blank and i can keep scrolling through the counter field on the form to 1234 Any ideas/suggestions/help would be appreciated. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: need to design a counter
Hi Raj, Create 2 filters and a temporary checkbox on form 1 1 filter is linked to form 2, and it does a push to form 1, setting the temporary checkbox to 0 The other filter is linked to form 1, and it does a set action. The Run If is 'TR.Checkbox' = 0, and the Set Field is Integer field = Integer field +1, Best regards, Jean-Louis -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Raj Sent: vendredi 16 avril 2010 2:04 To: arslist@ARSLIST.ORG Subject: need to design a counter Hello all, There is an integer field on form1. need to design a counter which increments the count by one for every submit on form2. So, need to write a filter on submit of form 2 which increments the integer field on form 1 by 1 for every submit on form 2.please advise. thanks, Raj ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are This message was successfully scanned against all known virusses by McAfee Groupshield. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: need to design a counter
Hi Raj, In your example 'form1' is parent. 'form2' is child. In form2 tickets are created based on ticket created in form1. In this case on 'form2' you must have a required field that hold 'Request ID' for ticket submitted in form1. Create a display only field of type integer on form1. Define a filter that executes on 'Get Entry' on form1 with a an action 'set fields'. In the action 'set fields' run an SQL that counts how many tickets exists in form2 that reference the current ticket from form1. For reports create a join form based on form1 and form2. Best regards, Daniel -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Raj Sent: vendredi 16 avril 2010 2:04 To: arslist@ARSLIST.ORG Subject: need to design a counter Hello all, There is an integer field on form1. need to design a counter which increments the count by one for every submit on form2. So, need to write a filter on submit of form 2 which increments the integer field on form 1 by 1 for every submit on form 2.please advise. thanks, Raj ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are This message was successfully scanned against all known virusses by McAfee Groupshield. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are * This message and any attachments (the message) are confidential and intended solely for the addressees. Any unauthorised use or dissemination is prohibited. Messages are susceptible to alteration. France Telecom Group shall not be liable for the message if altered, changed or falsified. If you are not the intended addressee of this message, please cancel it immediately and inform the sender. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: need to design a counter
Thank you everyone for their replies. I really appreciate this. Somewhat did the same as mentioned by Jean 1. 1st filter, On submit of form 2, did a PUSH field action to a temp character field on form 1. 2. 2nd filter , On modify of form 1(In RUN IF qualification used the character field), did a set field action for the counter(integer=integer + 1). Thanks again to everyone. On Wed, Apr 21, 2010 at 12:33 AM, Halleux, Jean-Louis jean-louis.hall...@scarlet.biz wrote: Hi Raj, Create 2 filters and a temporary checkbox on form 1 1 filter is linked to form 2, and it does a push to form 1, setting the temporary checkbox to 0 The other filter is linked to form 1, and it does a set action. The Run If is 'TR.Checkbox' = 0, and the Set Field is Integer field = Integer field +1, Best regards, Jean-Louis -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Raj Sent: vendredi 16 avril 2010 2:04 To: arslist@ARSLIST.ORG Subject: need to design a counter Hello all, There is an integer field on form1. need to design a counter which increments the count by one for every submit on form2. So, need to write a filter on submit of form 2 which increments the integer field on form 1 by 1 for every submit on form 2.please advise. thanks, Raj ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are This message was successfully scanned against all known virusses by McAfee Groupshield. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
$LASTCOUNT$ on filters (was: need to design a counter)
Hi Misi, My understanding is that it is not recommended to use $LASTCOUNT$ on filters, only in active links, because the $LASTCOUNT$ on a filter will be set for the last filter action that executed at that point in time, which may not be the one that just preceded it. This is specially true were you have many fast and list servers, so the probability of this problem happening is even greater Again that's my understanding, so I could be wrong. So therefore anytime that I need to count for records, I prefer to use the select count(*), or even better select count(request_id) or select count(rowid) on oracle databases. I only use the $LASTCOUNT$ keyword on active links, since active links actions are always serially executed as you know. Maybe somebody at BMC (Doug or David Easter) can confirm what actually happens with $LASTCOUNT$ on a filter in an a server that has multiple fast and list servers configured and many operations are always executing, either by the system (escalations, assignment engine, approval server, etc) or by users. For more than 10 years, I have never gotten a clear answer on this issue. Plus of course the internal ARS design may have changed between ARS versions, so whatever somebody thought was true on ARS 4.0 may have been incorrect in ARS 6.0 Guillaume From: Action Request System discussion list(ARSList) [arsl...@arslist.org] on behalf of Misi Mladoniczky [...@rrr.se] Sent: Friday, April 16, 2010 5:12 AM To: arslist@ARSLIST.ORG Subject: Re: need to design a counter Hi, Why not keep away from direct-sql when it is not absolutely neccessary? FLTR ACTION SET-FIELDS from FormX ('1' 0) myResult = $1$ ACTION SET-FIELDS from CURRENT TRANSACTION myResult = $LASTCOUNT$ Best Regards - Misi, RRR AB, http://www.rrr.se Products from RRR Scandinavia: * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. Raj, What is the reason you need that counter? Just to have a total count of tickets in form 1?? Or is there another reason? If you just want a count, I wouldn't create a form. I would have a hidden field that did a select count(*) from whatever view name that table has in the underlying database.. Cheers Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of Raj Sent: Thursday, April 15, 2010 8:04 PM To: arslist@ARSLIST.ORG Subject: need to design a counter Hello all, There is an integer field on form1. need to design a counter which increments the count by one for every submit on form2. So, need to write a filter on submit of form 2 which increments the integer field on form 1 by 1 for every submit on form 2.please advise. thanks, Raj ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are -- This message was scanned by ESVA and is believed to be clean. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: $LASTCOUNT$ on filters (was: need to design a counter)
Let me try taking a shot at this.. $LASTCOUNT$ is a AR System keyword that stores the last count performed by a transaction for that particular user. So the last count is the count of records from the last table a search had been performed on by that user. Like you I have never used it on Filters, as I've always had the need for it from an AL. But I'm wondering why it should be any different on a Filter or an Escalation than it is on an Active Link. Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of Guillaume Rheault Sent: Monday, April 19, 2010 10:33 AM To: arslist@ARSLIST.ORG Subject: $LASTCOUNT$ on filters (was: need to design a counter) Hi Misi, My understanding is that it is not recommended to use $LASTCOUNT$ on filters, only in active links, because the $LASTCOUNT$ on a filter will be set for the last filter action that executed at that point in time, which may not be the one that just preceded it. This is specially true were you have many fast and list servers, so the probability of this problem happening is even greater Again that's my understanding, so I could be wrong. So therefore anytime that I need to count for records, I prefer to use the select count(*), or even better select count(request_id) or select count(rowid) on oracle databases. I only use the $LASTCOUNT$ keyword on active links, since active links actions are always serially executed as you know. Maybe somebody at BMC (Doug or David Easter) can confirm what actually happens with $LASTCOUNT$ on a filter in an a server that has multiple fast and list servers configured and many operations are always executing, either by the system (escalations, assignment engine, approval server, etc) or by users. For more than 10 years, I have never gotten a clear answer on this issue. Plus of course the internal ARS design may have changed between ARS versions, so whatever somebody thought was true on ARS 4.0 may have been incorrect in ARS 6.0 Guillaume From: Action Request System discussion list(ARSList) [arsl...@arslist.org] on behalf of Misi Mladoniczky [...@rrr.se] Sent: Friday, April 16, 2010 5:12 AM To: arslist@ARSLIST.ORG Subject: Re: need to design a counter Hi, Why not keep away from direct-sql when it is not absolutely neccessary? FLTR ACTION SET-FIELDS from FormX ('1' 0) myResult = $1$ ACTION SET-FIELDS from CURRENT TRANSACTION myResult = $LASTCOUNT$ Best Regards - Misi, RRR AB, http://www.rrr.se Products from RRR Scandinavia: * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. Raj, What is the reason you need that counter? Just to have a total count of tickets in form 1?? Or is there another reason? If you just want a count, I wouldn't create a form. I would have a hidden field that did a select count(*) from whatever view name that table has in the underlying database.. Cheers Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of Raj Sent: Thursday, April 15, 2010 8:04 PM To: arslist@ARSLIST.ORG Subject: need to design a counter Hello all, There is an integer field on form1. need to design a counter which increments the count by one for every submit on form2. So, need to write a filter on submit of form 2 which increments the integer field on form 1 by 1 for every submit on form 2.please advise. thanks, Raj ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: $LASTCOUNT$ on filters (was: need to design a counter)
hey Joe, where did you get the information about being the last count performed by a transaction for a particular user? the ARS documentation is not that specific... My understanding, and I could be wrong, is that it is the last count performed by the last transaction, regardless of the user...; I think it is similar to a global variable in a programming language. In the user tool or mid-tier/browser, it would be the last count for that user of course, but on the server, what would it be, since filters run by definition with administrative privileges (i.e. without user context) I am pretty sure too the ITSM 7.x application does not use $LASTCOUNT$ in filters, only in active links. If there is some OOTB ITSM filter out there that uses it, it could either be a left over from a previous version, or it's a new developer at BMC that didn't get the memo on not using $LASTCOUNT$ on filters :-) Guillaume From: Action Request System discussion list(ARSList) [arsl...@arslist.org] on behalf of Joe D'Souza [jdso...@shyle.net] Sent: Monday, April 19, 2010 1:33 PM To: arslist@ARSLIST.ORG Subject: Re: $LASTCOUNT$ on filters (was: need to design a counter) Let me try taking a shot at this.. $LASTCOUNT$ is a AR System keyword that stores the last count performed by a transaction for that particular user. So the last count is the count of records from the last table a search had been performed on by that user. Like you I have never used it on Filters, as I've always had the need for it from an AL. But I'm wondering why it should be any different on a Filter or an Escalation than it is on an Active Link. Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of Guillaume Rheault Sent: Monday, April 19, 2010 10:33 AM To: arslist@ARSLIST.ORG Subject: $LASTCOUNT$ on filters (was: need to design a counter) Hi Misi, My understanding is that it is not recommended to use $LASTCOUNT$ on filters, only in active links, because the $LASTCOUNT$ on a filter will be set for the last filter action that executed at that point in time, which may not be the one that just preceded it. This is specially true were you have many fast and list servers, so the probability of this problem happening is even greater Again that's my understanding, so I could be wrong. So therefore anytime that I need to count for records, I prefer to use the select count(*), or even better select count(request_id) or select count(rowid) on oracle databases. I only use the $LASTCOUNT$ keyword on active links, since active links actions are always serially executed as you know. Maybe somebody at BMC (Doug or David Easter) can confirm what actually happens with $LASTCOUNT$ on a filter in an a server that has multiple fast and list servers configured and many operations are always executing, either by the system (escalations, assignment engine, approval server, etc) or by users. For more than 10 years, I have never gotten a clear answer on this issue. Plus of course the internal ARS design may have changed between ARS versions, so whatever somebody thought was true on ARS 4.0 may have been incorrect in ARS 6.0 Guillaume From: Action Request System discussion list(ARSList) [arsl...@arslist.org] on behalf of Misi Mladoniczky [...@rrr.se] Sent: Friday, April 16, 2010 5:12 AM To: arslist@ARSLIST.ORG Subject: Re: need to design a counter Hi, Why not keep away from direct-sql when it is not absolutely neccessary? FLTR ACTION SET-FIELDS from FormX ('1' 0) myResult = $1$ ACTION SET-FIELDS from CURRENT TRANSACTION myResult = $LASTCOUNT$ Best Regards - Misi, RRR AB, http://www.rrr.se Products from RRR Scandinavia: * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. Raj, What is the reason you need that counter? Just to have a total count of tickets in form 1?? Or is there another reason? If you just want a count, I wouldn't create a form. I would have a hidden field that did a select count(*) from whatever view name that table has in the underlying database.. Cheers Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of Raj Sent: Thursday, April 15, 2010 8:04 PM To: arslist@ARSLIST.ORG Subject: need to design a counter Hello all, There is an integer field on form1. need to design a counter which increments the count by one for every submit on form2. So, need to write a filter on submit of form 2 which increments the integer field on form 1 by 1 for every submit on form 2.please advise. thanks, Raj ___ UNSUBSCRIBE or access ARSlist
Re: $LASTCOUNT$ on filters (was: need to design a counter)
Guillaume, I cannot say for certain where - it's sort of ingrained in me for years (just like muscle memory), and I lived by that knowledge. I'm not saying it is accurate, and I have never used it myself in filters or escalations, but if ever I had the need to I would have assuming that's the way it works. Personally if count(*) or as you pointed out count(column) is what I prefer to use too as that way you know for sure where that count is coming from, and plus I would think (not verified - but sounds logically right) that it escapes at least one API call, as direct SQL do not care what you pass in the statement and assume the statement to be correct and passes it directly to the database to be executed and bring back the result.. Single API call.. Most other functions that populate LASTCOUNT probably would need more than a single API call to generate that result.. Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of Guillaume Rheault Sent: Monday, April 19, 2010 1:49 PM To: arslist@ARSLIST.ORG Subject: Re: $LASTCOUNT$ on filters (was: need to design a counter) hey Joe, where did you get the information about being the last count performed by a transaction for a particular user? the ARS documentation is not that specific... My understanding, and I could be wrong, is that it is the last count performed by the last transaction, regardless of the user...; I think it is similar to a global variable in a programming language. In the user tool or mid-tier/browser, it would be the last count for that user of course, but on the server, what would it be, since filters run by definition with administrative privileges (i.e. without user context) I am pretty sure too the ITSM 7.x application does not use $LASTCOUNT$ in filters, only in active links. If there is some OOTB ITSM filter out there that uses it, it could either be a left over from a previous version, or it's a new developer at BMC that didn't get the memo on not using $LASTCOUNT$ on filters :-) Guillaume From: Action Request System discussion list(ARSList) [arsl...@arslist.org] on behalf of Joe D'Souza [jdso...@shyle.net] Sent: Monday, April 19, 2010 1:33 PM To: arslist@ARSLIST.ORG Subject: Re: $LASTCOUNT$ on filters (was: need to design a counter) Let me try taking a shot at this.. $LASTCOUNT$ is a AR System keyword that stores the last count performed by a transaction for that particular user. So the last count is the count of records from the last table a search had been performed on by that user. Like you I have never used it on Filters, as I've always had the need for it from an AL. But I'm wondering why it should be any different on a Filter or an Escalation than it is on an Active Link. Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of Guillaume Rheault Sent: Monday, April 19, 2010 10:33 AM To: arslist@ARSLIST.ORG Subject: $LASTCOUNT$ on filters (was: need to design a counter) Hi Misi, My understanding is that it is not recommended to use $LASTCOUNT$ on filters, only in active links, because the $LASTCOUNT$ on a filter will be set for the last filter action that executed at that point in time, which may not be the one that just preceded it. This is specially true were you have many fast and list servers, so the probability of this problem happening is even greater Again that's my understanding, so I could be wrong. So therefore anytime that I need to count for records, I prefer to use the select count(*), or even better select count(request_id) or select count(rowid) on oracle databases. I only use the $LASTCOUNT$ keyword on active links, since active links actions are always serially executed as you know. Maybe somebody at BMC (Doug or David Easter) can confirm what actually happens with $LASTCOUNT$ on a filter in an a server that has multiple fast and list servers configured and many operations are always executing, either by the system (escalations, assignment engine, approval server, etc) or by users. For more than 10 years, I have never gotten a clear answer on this issue. Plus of course the internal ARS design may have changed between ARS versions, so whatever somebody thought was true on ARS 4.0 may have been incorrect in ARS 6.0 Guillaume From: Action Request System discussion list(ARSList) [arsl...@arslist.org] on behalf of Misi Mladoniczky [...@rrr.se] Sent: Friday, April 16, 2010 5:12 AM To: arslist@ARSLIST.ORG Subject: Re: need to design a counter Hi, Why not keep away from direct-sql when it is not absolutely neccessary? FLTR ACTION SET-FIELDS from FormX ('1' 0) myResult = $1$ ACTION SET-FIELDS from CURRENT TRANSACTION myResult = $LASTCOUNT$ Best Regards - Misi, RRR AB, http://www.rrr.se Products from RRR Scandinavia: * RRR|License - Not enough
Re: $LASTCOUNT$ on filters (was: need to design a counter)
Hi, The $LASTCOUNT$ keyword works for that individual thread, and is very much usable in FLTRs. I know for a fact that if you do two Set-Fields FLTR actions in a row, or make sure that two filters run after each other, the $LASTCOUNT$ will refer to the first of the Set-Fields operations. At least if you do a Set-Fields that performs a search. The two versions I typically do is: Version 1: FLTR Action Set-Fields from form xxx (qual) tmp = $1$ Action Set-Fields CURRENT TRANS count = $LASTCOUNT$ Version 2: FLTR Action Set-Fields from form xxx (qual) tmp = $1$ FLTR run if ($LASTCOUNT$ = 0) Action Whatever you like In the second example, I guess you can also perform check ('tmp' = $NULL$) instead, but I usually use the $LASTCOUNT$ anyway. The $LASTCOUNT$ keyword is also set by Push-Fields actions, but this is a little tricky due to FLTR Phasing. Best Regards - Misi, RRR AB, http://www.rrr.se Products from RRR Scandinavia: * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. Guillaume, I cannot say for certain where - it's sort of ingrained in me for years (just like muscle memory), and I lived by that knowledge. I'm not saying it is accurate, and I have never used it myself in filters or escalations, but if ever I had the need to I would have assuming that's the way it works. Personally if count(*) or as you pointed out count(column) is what I prefer to use too as that way you know for sure where that count is coming from, and plus I would think (not verified - but sounds logically right) that it escapes at least one API call, as direct SQL do not care what you pass in the statement and assume the statement to be correct and passes it directly to the database to be executed and bring back the result.. Single API call.. Most other functions that populate LASTCOUNT probably would need more than a single API call to generate that result.. Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of Guillaume Rheault Sent: Monday, April 19, 2010 1:49 PM To: arslist@ARSLIST.ORG Subject: Re: $LASTCOUNT$ on filters (was: need to design a counter) hey Joe, where did you get the information about being the last count performed by a transaction for a particular user? the ARS documentation is not that specific... My understanding, and I could be wrong, is that it is the last count performed by the last transaction, regardless of the user...; I think it is similar to a global variable in a programming language. In the user tool or mid-tier/browser, it would be the last count for that user of course, but on the server, what would it be, since filters run by definition with administrative privileges (i.e. without user context) I am pretty sure too the ITSM 7.x application does not use $LASTCOUNT$ in filters, only in active links. If there is some OOTB ITSM filter out there that uses it, it could either be a left over from a previous version, or it's a new developer at BMC that didn't get the memo on not using $LASTCOUNT$ on filters :-) Guillaume From: Action Request System discussion list(ARSList) [arsl...@arslist.org] on behalf of Joe D'Souza [jdso...@shyle.net] Sent: Monday, April 19, 2010 1:33 PM To: arslist@ARSLIST.ORG Subject: Re: $LASTCOUNT$ on filters (was: need to design a counter) Let me try taking a shot at this.. $LASTCOUNT$ is a AR System keyword that stores the last count performed by a transaction for that particular user. So the last count is the count of records from the last table a search had been performed on by that user. Like you I have never used it on Filters, as I've always had the need for it from an AL. But I'm wondering why it should be any different on a Filter or an Escalation than it is on an Active Link. Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of Guillaume Rheault Sent: Monday, April 19, 2010 10:33 AM To: arslist@ARSLIST.ORG Subject: $LASTCOUNT$ on filters (was: need to design a counter) Hi Misi, My understanding is that it is not recommended to use $LASTCOUNT$ on filters, only in active links, because the $LASTCOUNT$ on a filter will be set for the last filter action that executed at that point in time, which may not be the one that just preceded it. This is specially true were you have many fast and list servers, so the probability of this problem happening is even greater Again that's my understanding, so I could be wrong. So therefore anytime that I need to count for records, I prefer to use the select count(*), or even better select count(request_id
Re: $LASTCOUNT$ on filters (was: need to design a counter)
Guillaume, So, since you asked The AR System server is a stateless server. That means that the server itself does not retain state between API calls (OK, to be perfectly honest, it does cache a bit of user info for efficiency but if that is lost, it just reloads it and there is some chunking done when passing large data sets.. but essentially, it is stateless). So, there is no ability to have any data retained/assumed across API calls in terms of LASTCOUNT. However, the LASTCOUNT data is stored in thread local storage (in other words, there is an information block per thread that stores data for that thread). So, within a single API call, across the operations, including all filters, that are performed within that call, this keyword does have a value. Note, that if the very first thing you do is have a filter report LASTCOUNT, you are getting a random, leftover value from whoever was in the thread before you. However, once you do a search -- set fields, push fields, table load -- the LASTCOUNT value will be updated with the count from this search and available as the keyword for subsequent workflow. In other words, the keyword works identically on the server within filters as it does within active links. HOWEVER, it is within an API call and the value is searches done within the API call and not any search done on the client before interaction with the server. For example, if you loaded a table on the client and then did a save, the save goes to the server but there is no value of LASTCOUNT that has the count of the entries loaded in the table on the client. If you do an operation on the server within the operation however, the LASTCOUNT value should be accurate for logic after that table load. So, the keyword is fully useable in filters as long as it is used within a single API call. NOTE: Just like in active links, this is the result of the last search. So, if there is other workflow or operations that occur before you try and use the keyword, other workflow may have done searches that alters the result. So, it is critical to use the keyword value immediately after the operation that does the search. (i.e. do a push fields filter and there is logic on the target where you push to that does searches or loads tables. By the time you return from the Push fields operation, there have been changes to LASTCOUNT so the value is no longer a reflection of what was found for the push operation itself. Just something to keep in mind.) Doug PS -- Just as I was about to hit send, I see that Misi answered the question correctly based on testing evidence. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Guillaume Rheault Sent: Monday, April 19, 2010 7:33 AM To: arslist@ARSLIST.ORG Subject: $LASTCOUNT$ on filters (was: need to design a counter) Hi Misi, My understanding is that it is not recommended to use $LASTCOUNT$ on filters, only in active links, because the $LASTCOUNT$ on a filter will be set for the last filter action that executed at that point in time, which may not be the one that just preceded it. This is specially true were you have many fast and list servers, so the probability of this problem happening is even greater Again that's my understanding, so I could be wrong. So therefore anytime that I need to count for records, I prefer to use the select count(*), or even better select count(request_id) or select count(rowid) on oracle databases. I only use the $LASTCOUNT$ keyword on active links, since active links actions are always serially executed as you know. Maybe somebody at BMC (Doug or David Easter) can confirm what actually happens with $LASTCOUNT$ on a filter in an a server that has multiple fast and list servers configured and many operations are always executing, either by the system (escalations, assignment engine, approval server, etc) or by users. For more than 10 years, I have never gotten a clear answer on this issue. Plus of course the internal ARS design may have changed between ARS versions, so whatever somebody thought was true on ARS 4.0 may have been incorrect in ARS 6.0 Guillaume From: Action Request System discussion list(ARSList) [arsl...@arslist.org] on behalf of Misi Mladoniczky [...@rrr.se] Sent: Friday, April 16, 2010 5:12 AM To: arslist@ARSLIST.ORG Subject: Re: need to design a counter Hi, Why not keep away from direct-sql when it is not absolutely neccessary? FLTR ACTION SET-FIELDS from FormX ('1' 0) myResult = $1$ ACTION SET-FIELDS from CURRENT TRANSACTION myResult = $LASTCOUNT$ Best Regards - Misi, RRR AB, http://www.rrr.se Products from RRR Scandinavia: * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. Raj
Re: $LASTCOUNT$ on filters (was: need to design a counter)
Thanks for the very detailed, and clear, answer Doug!! Your participation on the list is, as always, very greatly appreciated Guillaume From: Action Request System discussion list(ARSList) [arsl...@arslist.org] on behalf of Mueller, Doug [doug_muel...@bmc.com] Sent: Monday, April 19, 2010 4:39 PM To: arslist@ARSLIST.ORG Subject: Re: $LASTCOUNT$ on filters (was: need to design a counter) Guillaume, So, since you asked The AR System server is a stateless server. That means that the server itself does not retain state between API calls (OK, to be perfectly honest, it does cache a bit of user info for efficiency but if that is lost, it just reloads it and there is some chunking done when passing large data sets.. but essentially, it is stateless). So, there is no ability to have any data retained/assumed across API calls in terms of LASTCOUNT. However, the LASTCOUNT data is stored in thread local storage (in other words, there is an information block per thread that stores data for that thread). So, within a single API call, across the operations, including all filters, that are performed within that call, this keyword does have a value. Note, that if the very first thing you do is have a filter report LASTCOUNT, you are getting a random, leftover value from whoever was in the thread before you. However, once you do a search -- set fields, push fields, table load -- the LASTCOUNT value will be updated with the count from this search and available as the keyword for subsequent workflow. In other words, the keyword works identically on the server within filters as it does within active links. HOWEVER, it is within an API call and the value is searches done within the API call and not any search done on the client before interaction with the server. For example, if you loaded a table on the client and then did a save, the save goes to the server but there is no value of LASTCOUNT that has the count of the entries loaded in the table on the client. If you do an operation on the server within the operation however, the LASTCOUNT value should be accurate for logic after that table load. So, the keyword is fully useable in filters as long as it is used within a single API call. NOTE: Just like in active links, this is the result of the last search. So, if there is other workflow or operations that occur before you try and use the keyword, other workflow may have done searches that alters the result. So, it is critical to use the keyword value immediately after the operation that does the search. (i.e. do a push fields filter and there is logic on the target where you push to that does searches or loads tables. By the time you return from the Push fields operation, there have been changes to LASTCOUNT so the value is no longer a reflection of what was found for the push operation itself. Just something to keep in mind.) Doug PS -- Just as I was about to hit send, I see that Misi answered the question correctly based on testing evidence. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Guillaume Rheault Sent: Monday, April 19, 2010 7:33 AM To: arslist@ARSLIST.ORG Subject: $LASTCOUNT$ on filters (was: need to design a counter) Hi Misi, My understanding is that it is not recommended to use $LASTCOUNT$ on filters, only in active links, because the $LASTCOUNT$ on a filter will be set for the last filter action that executed at that point in time, which may not be the one that just preceded it. This is specially true were you have many fast and list servers, so the probability of this problem happening is even greater Again that's my understanding, so I could be wrong. So therefore anytime that I need to count for records, I prefer to use the select count(*), or even better select count(request_id) or select count(rowid) on oracle databases. I only use the $LASTCOUNT$ keyword on active links, since active links actions are always serially executed as you know. Maybe somebody at BMC (Doug or David Easter) can confirm what actually happens with $LASTCOUNT$ on a filter in an a server that has multiple fast and list servers configured and many operations are always executing, either by the system (escalations, assignment engine, approval server, etc) or by users. For more than 10 years, I have never gotten a clear answer on this issue. Plus of course the internal ARS design may have changed between ARS versions, so whatever somebody thought was true on ARS 4.0 may have been incorrect in ARS 6.0 Guillaume From: Action Request System discussion list(ARSList) [arsl...@arslist.org] on behalf of Misi Mladoniczky [...@rrr.se] Sent: Friday, April 16, 2010 5:12 AM To: arslist@ARSLIST.ORG Subject: Re: need to design a counter Hi, Why not keep away from direct-sql when it is not absolutely neccessary? FLTR ACTION SET
Re: need to design a counter
Hi, Why not keep away from direct-sql when it is not absolutely neccessary? FLTR ACTION SET-FIELDS from FormX ('1' 0) myResult = $1$ ACTION SET-FIELDS from CURRENT TRANSACTION myResult = $LASTCOUNT$ Best Regards - Misi, RRR AB, http://www.rrr.se Products from RRR Scandinavia: * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. Raj, What is the reason you need that counter? Just to have a total count of tickets in form 1?? Or is there another reason? If you just want a count, I wouldn't create a form. I would have a hidden field that did a select count(*) from whatever view name that table has in the underlying database.. Cheers Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of Raj Sent: Thursday, April 15, 2010 8:04 PM To: arslist@ARSLIST.ORG Subject: need to design a counter Hello all, There is an integer field on form1. need to design a counter which increments the count by one for every submit on form2. So, need to write a filter on submit of form 2 which increments the integer field on form 1 by 1 for every submit on form 2.please advise. thanks, Raj ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are -- This message was scanned by ESVA and is believed to be clean. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: {Remedy ARS} Re: need to design a counter
I don't understand why you want to store that information when you can do a lookup at any point of time and get the latest count using a select count(*) using whatever conditions you may want to, to count the work log entries that have that specific value that you want to run a count on.. Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of Ravi Sent: Thursday, April 15, 2010 9:55 PM To: arslist@ARSLIST.ORG Subject: Re: {Remedy ARS} Re: need to design a counter ** Joe, This should happen only On Submit on HPD:WorkLog and the integer field to be incremented is on HPD:HelpDesk form. So how can this be done with a filter and an active link, please elaborate. Appreciate your help. Thanks, Raj On Thu, Apr 15, 2010 at 6:07 PM, Joe D'Souza jdso...@shyle.net wrote: Raj, The same can be done using the sql count as suggested earlier.. select count(*) from HPD_Worklog where comment = 'particular value' If that particular value is embedded in the text in the comment field, then you might want to use a like search select count(*) from HPD_Worklog where comment like '%particular value%' Run this in a Set field using an SQL and return the $1$ to that field whenever you want lets say window open, using a active link, and set the count to your integer field. Cheers Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of Raj Sent: Thursday, April 15, 2010 8:59 PM To: arslist@ARSLIST.ORG Subject: Re: {Remedy ARS} Re: need to design a counter Hi Joe, Thank you for the reply. Form 1: HPD:HelpDesk, Integer Field on HPD:HelpDesk form. Form2: HPD:Worklog So, whenever there is a submit to HPD:Worklog through webservice, comments are added to the HPD:Worklog, so only for a particular comment , which would be my RUN IF( 'Comment'=Particular Value) qualification for designing the filter on submit on HPD:Worklog, I need to increment the count through that integer field (which would be a hidden integer field), which is on HPD:HelpDesk form. Thanks, Raj On Apr 15, 5:14 pm, Joe D'Souza jdso...@shyle.net wrote: Raj, What is the reason you need that counter? Just to have a total count of tickets in form 1?? Or is there another reason? If you just want a count, I wouldn't create a form. I would have a hidden field that did a select count(*) from whatever view name that table has in the underlying database.. Cheers Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of Raj Sent: Thursday, April 15, 2010 8:04 PM To: arsl...@arslist.org Subject: need to design a counter Hello all, There is an integer field on form1. need to design a counter which increments the count by one for every submit on form2. So, need to write a filter on submit of form 2 which increments the integer field on form 1 by 1 for every submit on form 2.please advise. thanks, Raj ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: need to design a counter
I've done this. On the form that has the counter, put a display only radio button. Whenever a ticket is submitted in form two, push a value to the radio button. Next, put a filter on the form with the counter that runs when the radio button != $NULL$. The If actions is Integer = Integer + 1. This will give you your counter. Need: Filter on Form 2 that runs on submit and pushes value of 1 to read/only radio button field on Form 1 Filter on Form 1 that will set Integer = Integer + 1 on Modify when Radio Button ! $NULL$. Make sure the radio button is read only or this will not work. Thanks, Gary Opela, Jr. Sr. Remedy Engineer Avaya Phone Admin RSP Cert, Sec+ COMM: 405 582 4272 -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Raj Sent: Thursday, April 15, 2010 7:04 PM To: arslist@ARSLIST.ORG Subject: need to design a counter Hello all, There is an integer field on form1. need to design a counter which increments the count by one for every submit on form2. So, need to write a filter on submit of form 2 which increments the integer field on form 1 by 1 for every submit on form 2.please advise. thanks, Raj ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
need to design a counter
Hello all, There is an integer field on form1. need to design a counter which increments the count by one for every submit on form2. So, need to write a filter on submit of form 2 which increments the integer field on form 1 by 1 for every submit on form 2.please advise. thanks, Raj ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: need to design a counter
Raj, What is the reason you need that counter? Just to have a total count of tickets in form 1?? Or is there another reason? If you just want a count, I wouldn't create a form. I would have a hidden field that did a select count(*) from whatever view name that table has in the underlying database.. Cheers Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of Raj Sent: Thursday, April 15, 2010 8:04 PM To: arslist@ARSLIST.ORG Subject: need to design a counter Hello all, There is an integer field on form1. need to design a counter which increments the count by one for every submit on form2. So, need to write a filter on submit of form 2 which increments the integer field on form 1 by 1 for every submit on form 2.please advise. thanks, Raj ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: {Remedy ARS} Re: need to design a counter
Hi Joe, Thank you for the reply. Form 1: HPD:HelpDesk, Integer Field on HPD:HelpDesk form. Form2: HPD:Worklog So, whenever there is a submit to HPD:Worklog through webservice, comments are added to the HPD:Worklog, so only for a particular comment , which would be my RUN IF( 'Comment'=Particular Value) qualification for designing the filter on submit on HPD:Worklog, I need to increment the count through that integer field (which would be a hidden integer field), which is on HPD:HelpDesk form. Thanks, Raj On Apr 15, 5:14 pm, Joe D'Souza jdso...@shyle.net wrote: Raj, What is the reason you need that counter? Just to have a total count of tickets in form 1?? Or is there another reason? If you just want a count, I wouldn't create a form. I would have a hidden field that did a select count(*) from whatever view name that table has in the underlying database.. Cheers Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of Raj Sent: Thursday, April 15, 2010 8:04 PM To: arsl...@arslist.org Subject: need to design a counter Hello all, There is an integer field on form1. need to design a counter which increments the count by one for every submit on form2. So, need to write a filter on submit of form 2 which increments the integer field on form 1 by 1 for every submit on form 2.please advise. thanks, Raj ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org attend wwrug10www.wwrug.comARSlist: Where the Answers Are -- You received this message because you are subscribed to the Google Groups Remedy ARS group. To post to this group, send email to arsl...@googlegroups.com. To unsubscribe from this group, send email to arslist+unsubscr...@googlegroups.com. For more options, visit this group athttp://groups.google.com/group/arslist?hl=en. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: {Remedy ARS} Re: need to design a counter
Raj, The same can be done using the sql count as suggested earlier.. select count(*) from HPD_Worklog where comment = 'particular value' If that particular value is embedded in the text in the comment field, then you might want to use a like search select count(*) from HPD_Worklog where comment like '%particular value%' Run this in a Set field using an SQL and return the $1$ to that field whenever you want lets say window open, using a active link, and set the count to your integer field. Cheers Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of Raj Sent: Thursday, April 15, 2010 8:59 PM To: arslist@ARSLIST.ORG Subject: Re: {Remedy ARS} Re: need to design a counter Hi Joe, Thank you for the reply. Form 1: HPD:HelpDesk, Integer Field on HPD:HelpDesk form. Form2: HPD:Worklog So, whenever there is a submit to HPD:Worklog through webservice, comments are added to the HPD:Worklog, so only for a particular comment , which would be my RUN IF( 'Comment'=Particular Value) qualification for designing the filter on submit on HPD:Worklog, I need to increment the count through that integer field (which would be a hidden integer field), which is on HPD:HelpDesk form. Thanks, Raj On Apr 15, 5:14 pm, Joe D'Souza jdso...@shyle.net wrote: Raj, What is the reason you need that counter? Just to have a total count of tickets in form 1?? Or is there another reason? If you just want a count, I wouldn't create a form. I would have a hidden field that did a select count(*) from whatever view name that table has in the underlying database.. Cheers Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of Raj Sent: Thursday, April 15, 2010 8:04 PM To: arsl...@arslist.org Subject: need to design a counter Hello all, There is an integer field on form1. need to design a counter which increments the count by one for every submit on form2. So, need to write a filter on submit of form 2 which increments the integer field on form 1 by 1 for every submit on form 2.please advise. thanks, Raj ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: {Remedy ARS} Re: need to design a counter
Joe, This should happen only On Submit on HPD:WorkLog and the integer field to be incremented is on HPD:HelpDesk form. So how can this be done with a filter and an active link, please elaborate. Appreciate your help. Thanks, Raj On Thu, Apr 15, 2010 at 6:07 PM, Joe D'Souza jdso...@shyle.net wrote: Raj, The same can be done using the sql count as suggested earlier.. select count(*) from HPD_Worklog where comment = 'particular value' If that particular value is embedded in the text in the comment field, then you might want to use a like search select count(*) from HPD_Worklog where comment like '%particular value%' Run this in a Set field using an SQL and return the $1$ to that field whenever you want lets say window open, using a active link, and set the count to your integer field. Cheers Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of Raj Sent: Thursday, April 15, 2010 8:59 PM To: arslist@ARSLIST.ORG Subject: Re: {Remedy ARS} Re: need to design a counter Hi Joe, Thank you for the reply. Form 1: HPD:HelpDesk, Integer Field on HPD:HelpDesk form. Form2: HPD:Worklog So, whenever there is a submit to HPD:Worklog through webservice, comments are added to the HPD:Worklog, so only for a particular comment , which would be my RUN IF( 'Comment'=Particular Value) qualification for designing the filter on submit on HPD:Worklog, I need to increment the count through that integer field (which would be a hidden integer field), which is on HPD:HelpDesk form. Thanks, Raj On Apr 15, 5:14 pm, Joe D'Souza jdso...@shyle.net wrote: Raj, What is the reason you need that counter? Just to have a total count of tickets in form 1?? Or is there another reason? If you just want a count, I wouldn't create a form. I would have a hidden field that did a select count(*) from whatever view name that table has in the underlying database.. Cheers Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of Raj Sent: Thursday, April 15, 2010 8:04 PM To: arsl...@arslist.org Subject: need to design a counter Hello all, There is an integer field on form1. need to design a counter which increments the count by one for every submit on form2. So, need to write a filter on submit of form 2 which increments the integer field on form 1 by 1 for every submit on form 2.please advise. thanks, Raj ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
FW: Character Counter
Hello Its been a while since I looked through my ARS emails so maybe you've had an answer to this by now. But in case you haven't, maybe this might be an option for you. It stops the user from entering more characters than the field can accept (on mid-tier that is) and looks a bit similar to the code that the knowledgebase gave you for the active link. Add the following to the Source tab of the fixed view: SCRIPT document.FormFields.F536870919.maxLength=69; document.FormFields.F536870926.maxLength=50; /SCRIPT This goes just before: /BODY/HTML The number after FormFields.F is the field ID of the field, the length of which you want to restrict. You can put in lots of different fields, separated by semicolons. I used this some time ago with version 5.1.2 (on a windows web server) and it worked on all fields, with the one exception of a field which was 3000 characters long. Hope that helps Isabel -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Bruce Scott Sent: 30 March 2007 17:02 To: [EMAIL PROTECTED] Subject: Re: Character Counter ** I'm not sure if this went out on to the list, so I am reposting. I look forward to any assistance or advice as the BMC/Remedy Help Desk isn't very enthusiastic about working on a problem to a version that is no longer supported. Thanks, Bruce _ After searching for clues on javascript on the Remedy KB site, I've found a possible easy solution for my version of mid-tier, however, it doesn't seem to work. Am I doing something wrong? Their solution: Add an active link, firing on Window Loaded, which performs a single run-process action: javascript:document.FormFields.FFID.maxLength=value ..where FID is the database fieldId of the related character field, and value is the maximum length of text allowed to be typed in the field. My version of this is: javascript:document.FormFields.F8.maxLength=254; When I put this in place on my dev environment, there is no hard stop. Am I missing something? ARS 5.1.2 p 1313 MidTier 5.1.2 p 1388 Thanks, Bruce _ The information contained in this electronic mail message, including attachments, if any, is PetSmart confidential information. It is intended only for the use of the person(s) named above. If the reader of this message is not the intended recipient, or has received this message in error, you are hereby notified that any review, dissemination, distribution or copying of this communication is strictly prohibited. If you are not the intended recipient or have received this message in error, please notify the sender via e-mail and promptly delete the original message. _ __20060125___This posting was submitted with HTML in it___ Support Scotland's Bid to host the 2014 Commonwealth Games in Glasgow - visit www.glasgow2014.com Disclaimer: This message is intended only for use of the addressee. If this message was sent to you in error, please notify the sender and delete this message. Glasgow City Council cannot accept responsibility for viruses, so please scan attachments. Views expressed in this message do not necessarily reflect those of the Council who will not necessarily be bound by its contents. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Character Counter
Isabel, Thank you for your input, I really appreciate it. For whatever reason this doesn't work. At this point I am resigning myself to waiting until I upgrade to a newer version of ARS Thanks, Bruce _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Ross, Isabel Sent: Friday, April 13, 2007 7:34 AM To: [EMAIL PROTECTED] Subject: FW: Character Counter ** Hello Its been a while since I looked through my ARS emails so maybe you've had an answer to this by now. But in case you haven't, maybe this might be an option for you. It stops the user from entering more characters than the field can accept (on mid-tier that is) and looks a bit similar to the code that the knowledgebase gave you for the active link. Add the following to the Source tab of the fixed view: SCRIPT document.FormFields.F536870919.maxLength=69; document.FormFields.F536870926.maxLength=50; /SCRIPT This goes just before: /BODY/HTML The number after FormFields.F is the field ID of the field, the length of which you want to restrict. You can put in lots of different fields, separated by semicolons. I used this some time ago with version 5.1.2 (on a windows web server) and it worked on all fields, with the one exception of a field which was 3000 characters long. Hope that helps Isabel -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Bruce Scott Sent: 30 March 2007 17:02 To: [EMAIL PROTECTED] Subject: Re: Character Counter ** I'm not sure if this went out on to the list, so I am reposting. I look forward to any assistance or advice as the BMC/Remedy Help Desk isn't very enthusiastic about working on a problem to a version that is no longer supported. Thanks, Bruce _ After searching for clues on javascript on the Remedy KB site, I've found a possible easy solution for my version of mid-tier, however, it doesn't seem to work. Am I doing something wrong? Their solution: Add an active link, firing on Window Loaded, which performs a single run-process action: javascript:document.FormFields.FFID.maxLength=value ..where FID is the database fieldId of the related character field, and value is the maximum length of text allowed to be typed in the field. My version of this is: javascript:document.FormFields.F8.maxLength=254; When I put this in place on my dev environment, there is no hard stop. Am I missing something? ARS 5.1.2 p 1313 MidTier 5.1.2 p 1388 Thanks, Bruce _ The information contained in this electronic mail message, including attachments, if any, is PetSmart confidential information. It is intended only for the use of the person(s) named above. If the reader of this message is not the intended recipient, or has received this message in error, you are hereby notified that any review, dissemination, distribution or copying of this communication is strictly prohibited. If you are not the intended recipient or have received this message in error, please notify the sender via e-mail and promptly delete the original message. _ __20060125___This posting was submitted with HTML in it___ Support Scotland's Bid to host the 2014 Commonwealth Games in Glasgow - visit www.glasgow2014.com Disclaimer: This message is intended only for use of the addressee. If this message was sent to you in error, please notify the sender and delete this message. Glasgow City Council cannot accept responsibility for viruses, so please scan attachments. Views expressed in this message do not necessarily reflect those of the Council who will not necessarily be bound by its contents. __20060125___This posting was submitted with HTML in it___ # The information contained in this electronic mail message, including attachments, if any, is PetSmart confidential information. It is intended only for the use of the person(s) named above. If the reader of this message is not the intended recipient, or has received this message in error, you are hereby notified that any review, dissemination, distribution or copying of this communication is strictly prohibited. If you are not the intended recipient or have received this message in error, please notify the sender via e-mail and promptly delete the original message. # ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Character Counter
I'm not sure if this went out on to the list, so I am reposting. I look forward to any assistance or advice as the BMC/Remedy Help Desk isn't very enthusiastic about working on a problem to a version that is no longer supported. Thanks, Bruce _ After searching for clues on javascript on the Remedy KB site, I've found a possible easy solution for my version of mid-tier, however, it doesn't seem to work. Am I doing something wrong? Their solution: Add an active link, firing on Window Loaded, which performs a single run-process action: javascript:document.FormFields.FFID.maxLength=value ..where FID is the database fieldId of the related character field, and value is the maximum length of text allowed to be typed in the field. My version of this is: javascript:document.FormFields.F8.maxLength=254; When I put this in place on my dev environment, there is no hard stop. Am I missing something? ARS 5.1.2 p 1313 MidTier 5.1.2 p 1388 Thanks, Bruce # The information contained in this electronic mail message, including attachments, if any, is PetSmart confidential information. It is intended only for the use of the person(s) named above. If the reader of this message is not the intended recipient, or has received this message in error, you are hereby notified that any review, dissemination, distribution or copying of this communication is strictly prohibited. If you are not the intended recipient or have received this message in error, please notify the sender via e-mail and promptly delete the original message. # ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Character Counter
Shawn, I've never done this before with version 5.1.2. I'm guessing that I would add the script directly to the web form via the Insert Script tool in the Admin Tool. How do you reference fields within the form to the script? DB Name or Number? Here is what I'm trying to do (I think this script will work). script http://december.com/html/4/element/script.html language=javascript1.2 type=text/javascript !-- var maxChars = 254; function charsleft() { theInputBox = document.getElementById('Sht_Description'); theCountBox = document.getElementById('numCount'); var currentChars = theInputBox.value.length; theCountBox.value = Math.max((maxChars - currentChars),0); if(currentChars maxChars) { theInputBox.value = theInputBox.value.substring(0,maxChars); } } -- /script The field references Sht_Description and numCount are the DB Names for the short description field (which I am counting remaining spaces down from 254) and the count result field which displays the remaining number of spaces in the short description field. Any advice is greatly appreciated. Thanks, Bruce _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Pierson, Shawn Sent: Tuesday, March 27, 2007 2:04 PM To: arslist@ARSLIST.ORG Subject: Re: Character Counter ** If you're doing this on the mid tier, you may want to look at embedding some Javascript onto the web view of your form instead. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Bruce Scott Sent: Tuesday, March 27, 2007 3:40 PM To: arslist@ARSLIST.ORG Subject: Character Counter ** List, Late in January, there was a discussion regarding using Interval on an Active Link, for example in a counter to indicate the number of spaces remaining in a field the user was typing in. I have cut an excerpt from that discussion around which my question revolves. Has anyone made this work on mid-tier? If so, what version? Thank your for any help you can provide. Bruce Scott Application Developer - Remedy SSG, PetSMART, Inc. Office: 623.587.2340 eMail: [EMAIL PROTECTED] -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Doug Blair Sent: Wednesday, January 31, 2007 4:08 PM To: arslist@ARSLIST.ORG Subject: Re: Workflow All, Funny that this subject would come up like this, but just Monday I got a request to build the three second interval counter to show characters remaining. Works. I was concerned about performance too, so my test form has one active link that calculates the remaining space in 16 character fields (set fields X = 255 - LENGTH($field$) every three seconds (one set field action, 16 fields). The integer fields have no label, disabled change flag, and is displayed as text adjacent to each character field. If you watch closely Aruser's CPU was up by a (one) percent when this window is open, but you're only typing in one field at a time. No human-discernable pause, but the workflow log gets pretty large... There's no client-server traffic in this, networking's not an issue. Doug _ The information contained in this electronic mail message, including attachments, if any, is PetSmart confidential information. It is intended only for the use of the person(s) named above. If the reader of this message is not the intended recipient, or has received this message in error, you are hereby notified that any review, dissemination, distribution or copying of this communication is strictly prohibited. If you are not the intended recipient or have received this message in error, please notify the sender via e-mail and promptly delete the original message. _ __20060125___This posting was submitted with HTML in it___ The information in this e-mail, and any files transmitted with it, is intended for the exclusive use of the recipient(s) to which it is addressed and may contain confidential, proprietary or privileged information. If you are not an intended recipient, you have received this transmission in error and any use, review, dissemination, distribution, printing or copying of this information is strictly prohibited. If you have received this e-mail in error, please notify the sender immediately of the erroneous transmission by reply e-mail, immediately delete this e-mail and all electronic copies of it from your system and destroy any hard copies of it that you may have made. Thank you
Re: Character Counter
After searching for clues on javascript on the Remedy KB site, I've found a possible easy solution for my version of mid-tier, however, it doesn't seem to work. Am I doing something wrong? Their solution: Add an active link, firing on Window Loaded, which performs a single run-process action: javascript:document.FormFields.FFID.maxLength=value ..where FID is the database fieldId of the related character field, and value is the maximum length of text allowed to be typed in the field. My version of this is: javascript:document.FormFields.F8.maxLength=254 When I put this in place on my dev environment, there is no hard stop. Am I missing something? ARS 5.1.2 p 1313 MidTier 5.1.2 p 1388 Thanks, Bruce = Shawn, I've never done this before with version 5.1.2. I'm guessing that I would add the script directly to the web form via the Insert Script tool in the Admin Tool. How do you reference fields within the form to the script? DB Name or Number? Here is what I'm trying to do (I think this script will work). script http://december.com/html/4/element/script.html language=javascript1.2 type=text/javascript !-- var maxChars = 254; function charsleft() { theInputBox = document.getElementById('Sht_Description'); theCountBox = document.getElementById('numCount'); var currentChars = theInputBox.value.length; theCountBox.value = Math.max((maxChars - currentChars),0); if(currentChars maxChars) { theInputBox.value = theInputBox.value.substring(0,maxChars); } } -- /script The field references Sht_Description and numCount are the DB Names for the short description field (which I am counting remaining spaces down from 254) and the count result field which displays the remaining number of spaces in the short description field. Any advice is greatly appreciated. Thanks, Bruce _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Pierson, Shawn Sent: Tuesday, March 27, 2007 2:04 PM To: arslist@ARSLIST.ORG Subject: Re: Character Counter ** If you're doing this on the mid tier, you may want to look at embedding some Javascript onto the web view of your form instead. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Bruce Scott Sent: Tuesday, March 27, 2007 3:40 PM To: arslist@ARSLIST.ORG Subject: Character Counter ** List, Late in January, there was a discussion regarding using Interval on an Active Link, for example in a counter to indicate the number of spaces remaining in a field the user was typing in. I have cut an excerpt from that discussion around which my question revolves. Has anyone made this work on mid-tier? If so, what version? Thank your for any help you can provide. Bruce Scott Application Developer - Remedy SSG, PetSMART, Inc. Office: 623.587.2340 eMail: [EMAIL PROTECTED] -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Doug Blair Sent: Wednesday, January 31, 2007 4:08 PM To: arslist@ARSLIST.ORG Subject: Re: Workflow All, Funny that this subject would come up like this, but just Monday I got a request to build the three second interval counter to show characters remaining. Works. I was concerned about performance too, so my test form has one active link that calculates the remaining space in 16 character fields (set fields X = 255 - LENGTH($field$) every three seconds (one set field action, 16 fields). The integer fields have no label, disabled change flag, and is displayed as text adjacent to each character field. If you watch closely Aruser's CPU was up by a (one) percent when this window is open, but you're only typing in one field at a time. No human-discernable pause, but the workflow log gets pretty large... There's no client-server traffic in this, networking's not an issue. Doug _ The information contained in this electronic mail message, including attachments, if any, is PetSmart confidential information. It is intended only for the use of the person(s) named above. If the reader of this message is not the intended recipient, or has received this message in error, you are hereby notified that any review, dissemination, distribution or copying of this communication is strictly prohibited. If you are not the intended recipient or have received this message in error, please notify the sender via e-mail and promptly delete the original
Re: Character Counter
After searching for clues on javascript on the Remedy KB site, I've found a possible easy solution for my version of mid-tier, however, it doesn't seem to work. Am I doing something wrong? Their solution: Add an active link, firing on Window Loaded, which performs a single run-process action: javascript:document.FormFields.FFID.maxLength=value ..where FID is the database fieldId of the related character field, and value is the maximum length of text allowed to be typed in the field. My version of this is: javascript:document.FormFields.F8.maxLength=254 When I put this in place on my dev environment, there is no hard stop. Am I missing something? ARS 5.1.2 p 1313 MidTier 5.1.2 p 1388 Thanks, Bruce = Shawn, I've never done this before with version 5.1.2. I'm guessing that I would add the script directly to the web form via the Insert Script tool in the Admin Tool. How do you reference fields within the form to the script? DB Name or Number? Here is what I'm trying to do (I think this script will work). script http://december.com/html/4/element/script.html language=javascript1.2 type=text/javascript !-- var maxChars = 254; function charsleft() { theInputBox = document.getElementById('Sht_Description'); theCountBox = document.getElementById('numCount'); var currentChars = theInputBox.value.length; theCountBox.value = Math.max((maxChars - currentChars),0); if(currentChars maxChars) { theInputBox.value = theInputBox.value.substring(0,maxChars); } } -- /script The field references Sht_Description and numCount are the DB Names for the short description field (which I am counting remaining spaces down from 254) and the count result field which displays the remaining number of spaces in the short description field. Any advice is greatly appreciated. Thanks, Bruce _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Pierson, Shawn Sent: Tuesday, March 27, 2007 2:04 PM To: arslist@ARSLIST.ORG Subject: Re: Character Counter ** If you're doing this on the mid tier, you may want to look at embedding some Javascript onto the web view of your form instead. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Bruce Scott Sent: Tuesday, March 27, 2007 3:40 PM To: arslist@ARSLIST.ORG Subject: Character Counter ** List, Late in January, there was a discussion regarding using Interval on an Active Link, for example in a counter to indicate the number of spaces remaining in a field the user was typing in. I have cut an excerpt from that discussion around which my question revolves. Has anyone made this work on mid-tier? If so, what version? Thank your for any help you can provide. Bruce Scott Application Developer - Remedy SSG, PetSMART, Inc. Office: 623.587.2340 eMail: [EMAIL PROTECTED] -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Doug Blair Sent: Wednesday, January 31, 2007 4:08 PM To: arslist@ARSLIST.ORG Subject: Re: Workflow All, Funny that this subject would come up like this, but just Monday I got a request to build the three second interval counter to show characters remaining. Works. I was concerned about performance too, so my test form has one active link that calculates the remaining space in 16 character fields (set fields X = 255 - LENGTH($field$) every three seconds (one set field action, 16 fields). The integer fields have no label, disabled change flag, and is displayed as text adjacent to each character field. If you watch closely Aruser's CPU was up by a (one) percent when this window is open, but you're only typing in one field at a time. No human-discernable pause, but the workflow log gets pretty large... There's no client-server traffic in this, networking's not an issue. Doug _ The information contained in this electronic mail message, including attachments, if any, is PetSmart confidential information. It is intended only for the use of the person(s) named above. If the reader of this message is not the intended recipient, or has received this message in error, you are hereby notified that any review, dissemination, distribution or copying of this communication is strictly prohibited. If you are not the intended recipient or have received this message in error, please notify the sender via e-mail and promptly delete the original
Character Counter
List, Late in January, there was a discussion regarding using Interval on an Active Link, for example in a counter to indicate the number of spaces remaining in a field the user was typing in. I have cut an excerpt from that discussion around which my question revolves. Has anyone made this work on mid-tier? If so, what version? Thank your for any help you can provide. Bruce Scott Application Developer - Remedy SSG, PetSMART, Inc. Office: 623.587.2340 eMail: [EMAIL PROTECTED] -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Doug Blair Sent: Wednesday, January 31, 2007 4:08 PM To: arslist@ARSLIST.ORG Subject: Re: Workflow All, Funny that this subject would come up like this, but just Monday I got a request to build the three second interval counter to show characters remaining. Works. I was concerned about performance too, so my test form has one active link that calculates the remaining space in 16 character fields (set fields X = 255 - LENGTH($field$) every three seconds (one set field action, 16 fields). The integer fields have no label, disabled change flag, and is displayed as text adjacent to each character field. If you watch closely Aruser's CPU was up by a (one) percent when this window is open, but you're only typing in one field at a time. No human-discernable pause, but the workflow log gets pretty large... There's no client-server traffic in this, networking's not an issue. Doug # The information contained in this electronic mail message, including attachments, if any, is PetSmart confidential information. It is intended only for the use of the person(s) named above. If the reader of this message is not the intended recipient, or has received this message in error, you are hereby notified that any review, dissemination, distribution or copying of this communication is strictly prohibited. If you are not the intended recipient or have received this message in error, please notify the sender via e-mail and promptly delete the original message. # ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Character Counter
If you're doing this on the mid tier, you may want to look at embedding some Javascript onto the web view of your form instead. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Bruce Scott Sent: Tuesday, March 27, 2007 3:40 PM To: arslist@ARSLIST.ORG Subject: Character Counter ** List, Late in January, there was a discussion regarding using Interval on an Active Link, for example in a counter to indicate the number of spaces remaining in a field the user was typing in. I have cut an excerpt from that discussion around which my question revolves. Has anyone made this work on mid-tier? If so, what version? Thank your for any help you can provide. Bruce Scott Application Developer - Remedy SSG, PetSMART, Inc. Office: 623.587.2340 eMail: [EMAIL PROTECTED] -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Doug Blair Sent: Wednesday, January 31, 2007 4:08 PM To: arslist@ARSLIST.ORG Subject: Re: Workflow All, Funny that this subject would come up like this, but just Monday I got a request to build the three second interval counter to show characters remaining. Works. I was concerned about performance too, so my test form has one active link that calculates the remaining space in 16 character fields (set fields X = 255 - LENGTH($field$) every three seconds (one set field action, 16 fields). The integer fields have no label, disabled change flag, and is displayed as text adjacent to each character field. If you watch closely Aruser's CPU was up by a (one) percent when this window is open, but you're only typing in one field at a time. No human-discernable pause, but the workflow log gets pretty large... There's no client-server traffic in this, networking's not an issue. Doug The information contained in this electronic mail message, including attachments, if any, is PetSmart confidential information. It is intended only for the use of the person(s) named above. If the reader of this message is not the intended recipient, or has received this message in error, you are hereby notified that any review, dissemination, distribution or copying of this communication is strictly prohibited. If you are not the intended recipient or have received this message in error, please notify the sender via e-mail and promptly delete the original message. __20060125___This posting was submitted with HTML in it___ The information in this e-mail, and any files transmitted with it, is intended for the exclusive use of the recipient(s) to which it is addressed and may contain confidential, proprietary or privileged information. If you are not an intended recipient, you have received this transmission in error and any use, review, dissemination, distribution, printing or copying of this information is strictly prohibited. If you have received this e-mail in error, please notify the sender immediately of the erroneous transmission by reply e-mail, immediately delete this e-mail and all electronic copies of it from your system and destroy any hard copies of it that you may have made. Thank you. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are