Re: set fields behavior if no requests match filter
I'm having a hard time even getting to stage one where you are looking for a duplicate value on the same field on the same form. When I create my Filter, I have one Action as well - Set Fields. The Server Name is the correct server name, and the Read Value for Field From is my Form A. I do a Set Field If: 'requestid' != $requestid$ AND 'Field 1' = $Field 1$ AND 'Field 1' != $NULL$, then set another field (like your nonUnique field) to something, save the filter and the Server Name and Read Value for Field From options go back to CURRENT TRANSACTION. It sounds like we are doing the exact same thing, not sure why I can't even get to the stage to at least get my filter to run. I thought you can read a value from the same form. Lisa ARS 7.1 Windows 2003 Oracle 10g AR WUT 7.5 Brien Dieterle wrote: Is it normal for a set fields operation, which is set to Set Fields to $NULL$ if no records match, to actually set the fields anyway if no records match? I didn't think so. Here is the scenario: I have Form A with a 'Field 1' character field and a 'NotUnique' character field. I want a set fields operation to, on modify, check to see if there are any other records in Form A that have the same value as 'Field 1'. I know this is a great case for a unique index, but lets just assume that isn't an option. So my Filter executes on modify and has one action- set fields. It uses the Data Source of Server and Form A as the source. The qualification is something like this: 'requestid' != $requestid$ AND 'Field 1' = $Field 1$ AND 'Field 1' != $NULL$. In this way I don't care if there are Nulls that match, just actual values, and I prevent matching my own record. If no requests match: set fields to $Null$ if multiple requests match: use first matching request Set Field: NotUnique = True So what happens is NotUnique is set to True ALL the time, no matter what. Very, very strange. Here is the kicker: If I change the Set Field to: Set Field: NotUnique = $Request ID$ THEN, it works exactly as expected. For duplicate records NotUnique contains the Request ID of the offending record. If there is no duplicate, it is null. My guess is it is still broken and trying to set the field despite no matches, but since there really isn't any value to get, it sets it to null. Whereas, in the former case I am using a static string True instead of a field name. 7.5 patch 1 Brien ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are -- View this message in context: http://ars-action-request-system.1093659.n2.nabble.com/set-fields-behavior-if-no-requests-match-filter-tp5684874p5718896.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: 7.5 Mid Tier Object List Question
Has anyone been able to figure this out? Looks like the only forms that show up on this list is the ones with Public Permissions. We want it to act just like the Object List on the client (where the customer can only see the forms that they have access to). Also, is there an easier way for the midtier customer to get to the object list other than an entry link or adding a button on every single form that takes them to the MidTier Object List Form? We enabled the Enable Object List setting on the Midtier configuration, but it appears that enabling on the MidTier server is sort of an error trap. The MidTier will bring up the Object List if a bad URL is entered. I can't get this to work even if I try to use a bad URL (whatever that is!) Thanks! Lisa Midtier 7.5 p4 ARS 7.1 p7 Oracle 10g -- View this message in context: http://ars-action-request-system.1093659.n2.nabble.com/7-5-Mid-Tier-Object-List-Question-tp4469645p5209293.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Still See Fields After I Deleted Them
Joe Souza gave me some instructions on how to get rid of the fields that are in the Fields Not In View and I cannot find the instructions. Even though I deleted these fields, they are still in Fields Not in View and are coming up when creating Active Links, it's really irritating! Does anyone have the instructions on how to get rid of them completely? I think I had to create a new view and all sorts of other things. Why is it so hard to delete a field off of a form? (this is a display only form as well). ARS 7.1 p7 Windows 2003 Oracle 10g Thanks! Lisa lisakemes wrote: Thanks! OK, they are in the Fields in View but they are on the Fields Not In View side. How do I get rid of them? Lisa From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Grooms, Frederick W Sent: Friday, March 05, 2010 5:14 PM To: arslist@ARSLIST.ORG Subject: Re: Still See Fields After I Deleted Them ** Just to be safe look at the Fields in View. Even on a single view form you can have fields not in the view Fred From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Kemes, Lisa Sent: Friday, March 05, 2010 4:11 PM To: arslist@ARSLIST.ORG Subject: Still See Fields After I Deleted Them ** I deleted a bunch of fields off of my form and I still see them when I go to create an Active Link. I exported the form (and workflow), deleted the my form (which deletes the workflow) and reimported and I still see all the fields that I deleted. So I just deleted the Active Links and then reimported them, same thing. I do not have any views on this form and this is a display form. Lisa Kemes AR System Developer Tyco Electronics 717-810-2408 tel 717-810-2124 fax lisa.ke...@tycoelectronics.com _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are -- View this message in context: http://ars-action-request-system.1093659.n2.nabble.com/Still-See-Fields-After-I-Deleted-Them-tp4683738p5004658.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Still See Fields After I Deleted Them
Hi Doug! Thanks for responding! I must be doing something wrong then. I don't use the edit then delete but simply click on my delete button on my keyboard. I get the dialog box that asks me if I really want to delete and I select yes. But sometimes it doesn't delete it from my form, but simply puts the field in Fields not in View. Maybe I'm hitting no by mistake, saving the form and this moves it to the Fields not in View? I'm not sure, but I'm doing something wrong! I just did what you suggested and now everything is nice and clean! Thanks again! Lisa From: Mueller, Doug [via ARS (Action Request System)] [mailto:ml-node+5004852-265296041-94...@n2.nabble.com] Sent: Tuesday, May 04, 2010 2:25 PM To: Kemes, Lisa Subject: Re: Still See Fields After I Deleted Them Lisa, If the fields are in the Fields Not In View list, then they have not been deleted. They have simply been moved out of the view. To delete a field, select the field and choose the Delete option (under the Edit menu). If a field is not in the view, you can either 1) Go to a view that has the field in view 2) Go to the Fields Not in View list and move it into the view Then, the field is there, you can select it, and select the Delete option. There will be a dialog that shows up asking if you really want to delete the field. Respond Yes to really delete the field. Then, save the form. The field will be deleted -- from the form and so from all views. The only way that the field is present in the list of fields whether in view or not in view is that it really exists and has not been deleted. That would be why you are seeing it on lists of fields -- it is really there. Some people think that just by taking a field off the view -- moving it from in view to not in view -- will delete it. Only Deleting a field will gaurantee deleting it. Now, if the field is a piece of trim, removing from all views may cause the field to be deleted because it no longer has meaning because all it is is a display. BUT, this is a side effect and may or may not happen (I don't remember whether it does or not). If you want a field deleted, select it and select the Delete operation and it will be deleted. I hope this helps, Doug Mueller -Original Message- From: Action Request System discussion list(ARSList) [mailto:[hidden email]/user/SendEmail.jtp?type=nodenode=5004852i=0] On Behalf Of lisakemes Sent: Tuesday, May 04, 2010 10:47 AM To: [hidden email]/user/SendEmail.jtp?type=nodenode=5004852i=1 Subject: Re: Still See Fields After I Deleted Them Joe Souza gave me some instructions on how to get rid of the fields that are in the Fields Not In View and I cannot find the instructions. Even though I deleted these fields, they are still in Fields Not in View and are coming up when creating Active Links, it's really irritating! Does anyone have the instructions on how to get rid of them completely? I think I had to create a new view and all sorts of other things. Why is it so hard to delete a field off of a form? (this is a display only form as well). ARS 7.1 p7 Windows 2003 Oracle 10g Thanks! Lisa lisakemes wrote: Thanks! OK, they are in the Fields in View but they are on the Fields Not In View side. How do I get rid of them? Lisa From: Action Request System discussion list(ARSList) [mailto:[hidden email]/user/SendEmail.jtp?type=nodenode=5004852i=2] On Behalf Of Grooms, Frederick W Sent: Friday, March 05, 2010 5:14 PM To: [hidden email]/user/SendEmail.jtp?type=nodenode=5004852i=3 Subject: Re: Still See Fields After I Deleted Them ** Just to be safe look at the Fields in View. Even on a single view form you can have fields not in the view Fred From: Action Request System discussion list(ARSList) [mailto:[hidden email]/user/SendEmail.jtp?type=nodenode=5004852i=4] On Behalf Of Kemes, Lisa Sent: Friday, March 05, 2010 4:11 PM To: [hidden email]/user/SendEmail.jtp?type=nodenode=5004852i=5 Subject: Still See Fields After I Deleted Them ** I deleted a bunch of fields off of my form and I still see them when I go to create an Active Link. I exported the form (and workflow), deleted the my form (which deletes the workflow) and reimported and I still see all the fields that I deleted. So I just deleted the Active Links and then reimported them, same thing. I do not have any views on this form and this is a display form. Lisa Kemes AR System Developer Tyco Electronics 717-810-2408 tel 717-810-2124 fax [hidden email]/user/SendEmail.jtp?type=nodenode=5004852i=6 _Platinum Sponsor: [hidden email]/user/SendEmail.jtp?type=nodenode=5004852i=7 ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[hidden email]/user/SendEmail.jtp?type=nodenode=5004852i=8 ARSlist
Re: DST Issues
Not sure if this is the same thing (we are NOT dealing with Business Time in this scenario), but wanted to see what people were doing in this situation. I have an On Call System that allows the user to create multiple records if they are on call every XX number of days. So if someone were to type in a Start Date of 2/2/2010 12:00:00 AM and an End Date of 2/3/2010 12:00:00 AM and add multiple records every 100 days for 3 times, I get: Start 2/2/2010 12:00:00 AM End 2/3/2010 12:00:00 AM Start 5/13/2010 1:00:00 AM End 5/14/2010 1:00:00 AM Start 8/21/2010 1:00:00 AM End 8/22/2010 1:00:00 AM Start 11/29/2010 12:00:00 AM End 11/30/2010 12:00:00 AM (I'm adding 60 * 60) * 24) * $Day Interval$) * $IntervalCounter$) to the Start Date and End Date) We understand WHY this happens, but wondering what people do about this? Once March 14th rolls around, the times in May and August will still be 1:00:00 AM correct? (the customer wants 12:00:00 AM) I checked the database (hoping that in the DB it was correct and the it was only displaying in the client differently) but the Database is also showing these dates and times. We are thinking about creating a separate table to clarify DST Dates and Times and if a date falls on a certain date and time, subtracting or adding an hour to the Start Date or End Date. UGH! --- David: Have a look at Test3, it appears that the business time 1 subtract function, using a unit of days, has a different result than all other units; it is off by 1 hour. Maybe this is being calculated incorrectly? * Test 3 Business Time Type: Business Time 1 TestID: 202 Start: 3/10/2007 11:00:00 PM End: 3/11/2007 11:00:00 PM Diff Seconds: 86400 Diff Minutes: 1440 Diff Hours: 24 Diff Days: 1 Workday: 24 Hr Tag Holiday: 24 Hr Tag Result of Add to Start (Seconds): 3/11/2007 11:00:00 PM Result of Add to Start (Minutes): 3/11/2007 11:00:00 PM Result of Add to Start (Hours): 3/11/2007 11:00:00 PM Result of Add to Start (Days): 3/11/2007 11:00:00 PM Result of Subtract from End (Seconds): 3/10/2007 11:00:00 PM Result of Subtract from End (Minutes): 3/10/2007 11:00:00 PM Result of Subtract from End (Hours): 3/10/2007 11:00:00 PM Result of Subtract from End (Days): 3/11/2007 12:00:00 AM * DB Values: REQUEST_ID: 202 STARTDATE: 1173585600 ENDDATE: 1173668400 ENDDATE-STARTDATE: 82800 Axton Grams On 3/6/07, Easter, David david_eas...@bmc.com wrote: Business Time is not DST aware. This has been true for quite some time now, and is probably why you're seeing the issue. Basically, Business Time doesn't know that the change from Standard to DST is a 23 hour day nor that from DST to Standard is a 25 hour day. It's unrelated to the changes in DST rules for 2007 - i.e. folks have been dealing with this for years. This is somewhat obliquely mentioned in the tech bulletin: In addition, as happens during any DST event, when DST begins, the day loses one hour (hour interchange of −1). At this date, a full hour is skipped and does not exist either before or after the transition, so this date includes only 23 hours. Workflow that is designed to fire only during that lost hour may not fire properly. However, since this issue occurs during every DST event, we expect that customers that would be affected by this event have already compensated for this issue. This issue is not related to AR System and thus affects all versions of AR System. Due to the raised level of concern on this issue, BMC is looking into adding more intelligence into Business Time in the next release (i.e. 7.1.00) to deal with DST and time zones more gracefully. One may also be able to write some workflow that influences Business Time results to compensate for the lost (or gained) hour during the switch between Standard and Daylight. Thanks, -David J. Easter Sr. Product Manager, Service Management Business Unit BMC Software, Inc. The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Axton Sent: Tuesday, March 06, 2007 4:56 PM To: arslist@ARSLIST.ORG Subject: DST Issues Reposting this because I've seen no replies and wasn't sure if it went into a black hole today when no posts were being sent. I really need a sanity check on this to make sure I'm not out of whack. Axton I am seeing some strange results in my DST testing in regards to business time. Environment: ARServer 7.0.01 patch 001 SunOS 5.9 Generic_118558-26 Mid-Tier 7.0.01 patch 001 IBM WebSphere Application Server/6.0 IBM Java 1.4.2_11 I took 2 dates, a start and end
Re: Remedy 7.x and Web services
Has anyone been able to find anymore documents on web services for 7.x? RaviRaj wrote: You can find in document: BMC Remedy Action Request System 7.0.01/7.1.00/7.5.00 Integrating with Plug-ins and Third-Party Products. Even I am looking for some more information/supporting documents on Web Services, are there any other documents for Web Services ? Thanks, Raj On Sun, Nov 8, 2009 at 9:29 AM, Victor vic...@klub.chip.pl wrote: Hello all, Could someone point me to documentations/tutorials/examples on how to use/develop/integrate web services functionalities of Remedy 7.x ? Thanks in advance Victor ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.netsponsor%3armisoluti...@verizon.netARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are -- View this message in context: http://old.nabble.com/Remedy-7.x-and-Web-services-tp26255852p26342325.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: On Call System
I've decided to go with Fred's suggestion and just have the user click on a start time and end time as to when they are on call. One question, have you had any problems with DST? Grooms, Frederick W wrote: No. None of the users have asked for that option (s, Dont give them the idea). Our on call data is like... GroupUser StartEnd Remedy Fred 2/6/2008 8:00 AM 2/13/2008 8:00 AM Remedy Fred 2/13/2008 8:00 AM 2/20/2008 8:00 AM Fred From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kemes, Lisa Sent: Thursday, February 21, 2008 1:48 PM To: arslist@ARSLIST.ORG Subject: Re: On Call System ** Another question, do you have a recurring option? So someone could enter a start date and end date (let's say 5:00pm to 7:00am) and then recur that for 7 days or weeks or months? From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W Sent: Thursday, February 21, 2008 2:39 PM To: arslist@ARSLIST.ORG Subject: Re: On Call System ** What we do here is give the user's start and end fields so we don't have to have a record per day. A group that may have 1 person on call for a week would only have 1 record instead of 7. When displaying the on call we show any record whose start = $TIMESTAMP$ and end = $TIMESTAMP$. To validate on Submit or Modify we check that the Start Date/Time = an ending Date/Time for the same group (or this start is in between another records start/end dates). Showing it in a calander is a bit trickier but can be done. Fred From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kemes, Lisa Sent: Thursday, February 21, 2008 1:01 PM To: arslist@ARSLIST.ORG Subject: Re: On Call System ** The application is going to cover a year. Each group is going to have their own oncall schedule so that our help desk knows who to call after hours for an urgent ticket. We are a 24/7 shop. It's all in Microsoft Access right now (a different access database for each group that I tie in all together through a website). It's horrible to maintain, so we are going to develop something in the AR System (7.0.1 Patch 005, Windows 2003, Oracle 10i) From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Ben Cantatore Sent: Thursday, February 21, 2008 1:48 PM To: arslist@ARSLIST.ORG Subject: Re: On Call System ** Lisa, Can you provide a little more information about your app? For example how is the user prompted for his/her oncall schedule? What period of time does this cover, week, month, reoccurring, variable? Just off the top of my head, if you were getting the users to enter their oncall schedule for let's say a month, then all you need to do is a tablewalk check for days missing between the beginning and end of the month. Assuming this was a 24/7 shop. Ben Cantatore Remedy Administrator Avon (914) 935-2946 Kemes, Lisa [EMAIL PROTECTED] Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 02/21/2008 01:11 PM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject On Call System ** I'm creating an on call system for our company and I would like to make sure that the end user does not accidentally skip a date or a time. So when they are entering information as to who is on call I don't want (this would be in a table): Feb 20 Lisa Kemes Feb 22 Lisa Kemes Feb 23 Lisa Kemes I would like them to see: Feb 20 Lisa Kemes Feb 21 Feb 22 Lisa Kemes Feb 23 Lisa Kemes Is there any easy way to do this? (other than creating a separate table with every hour and date on it). Just wondering/brain storming Lisa Kemes AR System Developer Tyco Electronics 717-810-2408 tel 717-810-2124 fax [EMAIL PROTECTED] __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are -- View this message in context: http://www.nabble.com/On-Call-System-tp15617543p20254264.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
