Re: Common Table Expression SQL for menus

if this will help, but I frequently see CTEs written with a > leading semicolon before the WITH keyword – e.g. ;WITH cte AS… > > > > IIRC this is required by the SQL engine -- maybe give that a shot? > > --Phil > > > > *From:* ARSList *On Behalf Of *Charlie > Lotridge

Common Table Expression SQL for menus

Hi all, I'm trying to use a SQL query containing a Common Table Expression for a drop-down menu. I can see that the query is submitted to the server and is appropriately generating results. But the menu comes back as empty. For anyone not familiar, a Common Table Expression (CTE) is a construct

Re: Where do I configure "Save Successful With Warnings"?

Remedy Engineer > > 404-582-5699 (Desk) > 704-301-1047 (Mobile) > > > > *From:* ARSList [mailto:arslist-boun...@arslist.org] *On Behalf Of *Charlie > Lotridge > *Sent:* Wednesday, January 23, 2019 1:34 PM > *To:* ARSList > *Subject:* [EXTERNAL] Where do I conf

Where do I configure "Save Successful With Warnings"?

Hi, Sorry for the rookie question here, but I just can't locate where to configure which warnings appear (or don't) in the popup that appears when you save a form in Remedy Developer Studio (v.9.1.06). I used to know, but I think I've stuffed my brain with too much nonsense and that piece of info

Issue with SQL Set Fields that uses a Common Table Expression

Hi, I've got a filter that's performing a SQL Set Fields and the SQL is constructed using a Common Table Expression (i.e. it begins with a "WITH" keyword). Through ARS logging and using SQL Server profiling, I can see that the SQL is being submitted to SQL Server and executed. If I run the SQL

Re: Help with odd set of SQL operations by ARS

> > On Mon, Jun 18, 2018 at 8:47 AM Charlie Lotridge > wrote: > >> Hi, >> >> I'm not exactly sure when this started, but within the past few weeks my >> production ARS has started repeatedly issuing the following three SQL >> statements: >> &

Help with odd set of SQL operations by ARS

Hi, I'm not exactly sure when this started, but within the past few weeks my production ARS has started repeatedly issuing the following three SQL statements: *SELECT TOP 2 T127.C1,C124 FROM T127 WHERE (T127.C101 = N'MidTier Service') ORDER BY 1 ASC* *SELECT MAX(timestamp) FROM user_cache*

Re: Run API from filter deadlocks

ishesthus > deadlock > > simplyyou can't have the doctor operate on himself > > On Wed, Mar 15, 2017 at 12:01 PM, Charlie Lotridge <lotri...@mcs-sf.com> > wrote: > >> ** >> LJ, >> >> Thanks for the suggestion. >> >> Unfortun

Re: Run API from filter deadlocks

many advantages over a > run-processanyway > > You say it's a deadlockcan you identify what you mean by that? > > On Wed, Mar 15, 2017 at 11:11 AM, Charlie Lotridge <lotri...@mcs-sf.com> > wrote: > >> ** >> Hi, >> >> I'm trying to run an API pro

Run API from filter deadlocks

Hi, I'm trying to run an API program I wrote in a filter Set Fields using $PROCESS$, but it's deadlocking and I can't see why. The first thing I tried, described in the documentation here , is to increase the

Re: BoF Groups in Communities

...those of us custom shops that may not be watching the BMC Communities much. Yeah, that would be me. Great idea...voted up. -charlie On Mon, May 4, 2015 at 11:36 AM, Jason Miller jason.mil...@gmail.com wrote: ** Hello all, I am posting this BMC Communities Idea here for those of us

Re: .Net API Wrapper Framework Version

Hi Bruce, I actually have a .net API that I built concurrently with Remedy's. I started the project back around 2005 and have maintained it ever since. And yes, it's currently built against .NET v4.51 and v8.1 of ARS. I built it because I needed something that was higher fidelity to the C API

Re: Refresh my Memory Please

Doug, You should not need any middleware to do this. It's not clear if this is what you're trying, but I'd recommend creating a MS SQL view that pulls the data from the remote DB. One advantage is that if you can successfully query the SQL view in (say) SQL Server Management Studio query window

Re: need some ideas from you how to show incidents recordsover4hrinred color.

to walk-a-table fields in a selection-field of a join form. Please let me know how. Thanks // Omega -- From: Charlie Lotridge lotri...@mcs-sf.com Sent: ‎10/‎12/‎14 7:01 AM To: arslist@ARSLIST.ORG Subject: Re: need some ideas from you how to show incidents

Re: need some ideas from you how to show incidents recordsover4hrinred color.

? On Wed, Dec 10, 2014 at 8:12 AM, LJ LongWing lj.longw...@gmail.com wrote: ** Sorry...forgot to credit the source of the 2 ideas I said were still in play :) On Wed, Dec 10, 2014 at 9:09 AM, Charlie Lotridge lotri...@mcs-sf.com wrote: ** Hmmm...let's see... Yeah, I'll vote for option number

Re: need some ideas from you how to show incidents recordsover4hrinred color.

*From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *Charlie Lotridge *Sent:* Wednesday, December 10, 2014 10:31 AM *To:* arslist@ARSLIST.ORG *Subject:* Re: need some ideas from you how to show incidents recordsover4hrinred color. ** LJ

Re: need some ideas from you how to show incidents records over4hrinred color.

to use on display active link to set the fields, and will try it tmr, to see if it can set the display-field under the table-field. Which I think it might works. And will let you all knew the result. . Thank you // Omega -- From: Charlie Lotridge lotri...@mcs-sf.com

Re: need some ideas from you how to show incidents records over 4hrin red color.

when the filter fires Fred *From:* Action Request System discussion list(ARSList) [ mailto:arslist@ARSLIST.ORG arslist@ARSLIST.ORG] *On Behalf Of *Charlie Lotridge *Sent:* Friday, December 05, 2014 10:35 AM *To:* arslist@ARSLIST.ORG *Subject:* Re: need some ideas from you how to show

Re: need some ideas from you how to show incidents records over 4hrinred color.

-- From: Charlie Lotridge lotri...@mcs-sf.com Sent: ‎9/‎12/‎14 5:53 AM To: arslist@ARSLIST.ORG Subject: Re: need some ideas from you how to show incidents records over 4hrinred color. ** Omega, run a filter log to make sure that the Get Entry filter is actually firing on each entry when you

Re: need some ideas from you how to show incidents records over 4 hr in red color.

Anyone who's read anything I've written over the past year (that I've been contributing here) knows I'm a big fan of using Remedy views over SQL views. And I've used this mechanism to implement exactly what you're looking for here, but without the table walk logic...much (much much) faster and

Re: .Net api 64 bit version

Hi Jean-Louis, I have a 64 bit .net api for Remedy, but it's one that I wrote and is not based on the community version. A few facts about it... - I began work on my .net API nearly 10 years ago because I needed one that provided more functionality and flexibility than the community version did

Bug using Status History value in filter Run If?

Is this a bug or am I doing something wrong? I'm pretty sure it's a bug, but wanted to see if anyone has any insight or has seen this before. Here's a simplified version of the situation: I've got a Case form with a 'Status' that can be set to Draft, Open, or Closed. Users can't change the

Re: Request ID Numbering recovery

Hi Keith, So, it turns out you can just set the nextId column value in arschema to the beginning of your missing sequence and you're good to go. While the unique index violation that Rick mentions will happen, ARS seamlessly handles the problem and will cycle until it finds an unused id. I'd

Re: NOT SOLVED: PERFORM-ACTION-OPEN-URL to open internal network site

Two questions: First, are the files that you want to display always PDF's? Second, are they accessible from the server? If yes and yes, than an alternate solution is for you to construct server workflow (using a service) that retrieves the file as an attachment and passes it up to the client

Re: RRR|Chive vs. DDM

Hi Lyndsay, A bit over a year ago I architected implemented the data migration for my client at the time, which involved an upgrade from 7.1 to 8.1, and a migration of the data from Oracle to SQL Server. Like you, we only wanted to migrate a subset of the data and leave a whole bunch of garbage

Re: Diary field usage

I can't speak to best practices, but IMHO it really depends two things: the expected size of the content and how you plan to use it. With regard to the expected content, if you're planning to document something with a relatively limited life-cycle and not a lot of content, then I think diary

Re: Server side filter log not getting captured!

Hi Ayushi, Make sure the path for the log file is valid. Or you could change it to a path that you're sure IS valid. Remember that the path is relative to the machine on which that AR server is running. Another thing, try viewing the file directly using Windows Explorer, rather than that View

Re: Escalation does not seem to complete its run over all the records..

First, and FYI, the filter counter that's used by the system to determine if a transaction exceeds the filtering limit set for the system is reset for every record process during an escalation. It is NOT cumulative across the entire run of the escalation. So unless one of the records being

Re: Escalation qualification : DSO

This is one of a few situations I've encountered where global fields at the server level would be useful. If we could create a global field with a lifespan of a transaction (or, in this case, the run of the escalation), that retained its same value across all records (of all forms) across the

Re: *Ancient* bug with Set Field from a SQL transaction still present...

Agreed. The Dev Studio (and Admin tool before it) is not in the business of parsing complex SQL, so they punt on the issue and just count commas (and add one). They trust that you, the developer who wrote the SQL, will know how many valid results there actually are. And now on to the subject of

Re: *Ancient* bug with Set Field from a SQL transaction still present...

FYI this comma counting only affects what appears in the list of field choices. There's nothing stopping you from hand typing, say, $10$ or $100$ into a Set Fields value, even if the drop-down shows only (say) 5 choices. Of course, your SQL had then better have at least that many columns of data

Permission problem

I'm at a loss and would appreciate any suggestions on how to fix this. I have a field on a form that has no privileges configured on it, so no one but full admins should see it. But for some reason an underprivileged user account can see this field on the mid-tier running on the same machine,

Re: Permission problem

down Tomcat, deleted all of the contents of the 'cache' directory for Mid-Tier, and restarted?...this is moderately different than a 'Flush Cache' from the config console. On Thu, Aug 7, 2014 at 9:02 AM, Charlie Lotridge lotri...@mcs-sf.com wrote: ** I'm at a loss and would appreciate any

Re: Permission problem

than a 'Flush Cache' from the config console. On Thu, Aug 7, 2014 at 9:02 AM, Charlie Lotridge lotri...@mcs-sf.com wrote: ** I'm at a loss and would appreciate any suggestions on how to fix this. I have a field on a form that has no privileges configured

Re: Permission problem

- From: Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] On Behalf Of Charlie Lotridge Sent: Thursday, August 07, 2014 10:03 AM To: arslist@ARSLIST.ORG Subject: Permission problem ** I'm at a loss and would appreciate any suggestions on how to fix this. I have

Re: Permission problem

that is BMC...and being you are running the latest version, latest service pack, latest patchthere would obviously need to be another fix put in place. On Thu, Aug 7, 2014 at 10:05 AM, Charlie Lotridge lotri...@mcs-sf.com wrote: ** Greg, I'm also concerned about the problem coming back (I

Re: EXTERNAL: Re: using SQL soundex function to find similar names

by its brilliance. - paraphrased by me *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *Charlie Lotridge *Sent:* Thursday, July 31, 2014 11:37 AM *To:* arslist@ARSLIST.ORG *Subject:* EXTERNAL: Re: using SQL soundex function to find similar

Re: using SQL soundex function to find similar names

John, This is a pretty strange problem you're having, and I can suggest the following steps to *try* to figure out what's going on: 1) Run a SQL log and capture the actual SQL being issued to generate the soundex value, then run it in a query window in the MS SQL Management Studio. Make sure

Re: View DDL for ARSystem tables

Hi Karthik, The way to solve this problem is to use logging. Turn on SQL logging on the server to identify *exactly* the SQL statement causing the error. You probably should also turn on Filter logging (and direct them into the same file) so that you can see if the SQL is being caused by some

Re: View Form Not Picking Up Char(1) columns

Hi John, Are you running a unicode server? My guess is that you are, in which case it's only going to recognize nchar/nvarchar and is not going to recognize char/varchar column types. If this is the case, and IF you really meant it when you wrote need to be able to SEE these values (and not

Re: Remedy Developer Performance Metrics

in certain situations. I would be happy to take this offline with you if you would like...maybe get a bit more into your reasons for looking for this metric. On Tue, Jun 3, 2014 at 5:03 PM, Charlie Lotridge lotri...@mcs-sf.com wrote: ** LJ says 'performance metrics suck and don't work the way

Remedy Developer Performance Metrics

Hi all, I'm curious...what are your opinions about what might be useful metrics to use to judge the performance of Remedy developers? To narrow the conversation a bit, let's just talk about during the creation of a new custom application, or custom module to an existing application. In other

Re: Remedy Developer Performance Metrics

is doing 'better' than another developer. On Tue, Jun 3, 2014 at 3:46 PM, Charlie Lotridge lotri...@mcs-sf.com wrote: ** Hi all, I'm curious...what are your opinions about what might be useful metrics to use to judge the performance of Remedy developers? To narrow the conversation a bit, let's

Re: Remedy Developer Performance Metrics

, at 5:46 PM, Charlie Lotridge lotri...@mcs-sf.com wrote: ** Hi all, I'm curious...what are your opinions about what might be useful metrics to use to judge the performance of Remedy developers? To narrow the conversation a bit, let's just talk about during the creation of a new custom

Re: Active-link Associated with from

Hi Rajesh, These three queries pull the desired counts for the User form. Change User to your desired form to get the results you need. SELECT COUNT(*) FROM actlink a JOIN actlink_mapping am ON am.actlinkId = a.actlinkId JOIN arschema s ON s.schemaId = am.schemaId WHERE s.name = 'User' SELECT

Re: Transactional (TR) and Database (DB)

Hi Randeep Misi, I've performed a few tests and confirmed your propositions that the 'DB.' construct causes a DB read. In a SQL log I can see a DB read before the UPDATE only when I have a 'DB.' filter active (but not when I just have one using 'TR.'). This is interesting and something I wasn't

Re: Transactional (TR) and Database (DB)

I'm curious, what's the 0.1% case when it would be useful? I'm just not seeing any unique use for it at all. -charlie On Sat, May 17, 2014 at 1:04 PM, Misi Mladoniczky m...@rrr.se wrote: Hi, It is up to the client. If this for example was done through a Push-Fields, 'TR.City' could

Re: Transactional (TR) and Database (DB)

Hi all, I have to admit that I've never once used the TR. construct, and I've been working with this system a long time. I guess I've always assumed it had a reasonable usage but, since I was always able to accomplish everything I needed to do with the 'Field' and 'DB.Field' constructs, I never

Re: Indirect reference to form field value

Hi Robin, [Given how the ARSLIST is performing these days, I'm sending this to you directly as well as back to the list so that it'll hopefully get to you more quickly.] The very first thing I want to mention is that I got it wrong when I said that a return value of 0 indicates failure As Fred

Re: Dynamic user-specific color coding for table field rows and columns

Hi Robin, Unfortunately, no, you can't directly do what you want here. The table column coloring configurations are embedded in some very low level display properties associated with the table column fields in the data dictionary. There is no way to either dynamically change these, or have user

Re: Self-Terminating/disabling Escalation

LJ, Although it's not a feature that I've found particularly useful, your use case sounds like a perfect candidate for an error handler filter. If you use one on the target form (of the push) to catch the individual errors, it should allow the whole transaction to succeed. However, there's

Re: Self-Terminating/disabling Escalation

Hi Sapna, The bad news is that there is no workflow action that will accomplish this for you. You could potentially try to use a SQL update (in a Direct SQL action) to directly update the Remedy data dictionary, which would look something like this: UPDATE escalation SET enable = 0 WHERE name =

Re: Indirect reference to form field value

Hi Robin, Sorry to hear that. Are you capturing the value being returned by the operation? If so, is it indicating the failure (i.e. returning 0). Also, are you capturing a workflow log to make sure the reference values (e.g. the 'SourceFieldID' and 'TargetFieldID' in my example) are being set

Re: Filed attributes

, 2014 at 12:53 PM, vidyasagar kommu kommuvidyasa...@gmail.com wrote: Thanks a lot charlie ... On Mon, Apr 21, 2014 at 12:08 AM, Charlie Lotridge lotri...@mcs-sf.comwrote: ** No, there's no need to use the custom enumeration type, you just need to go in and switch the Yes name

Re: Indirect reference to form field value

Hi Robin, I actually use this mechanism quite a lot, and it certainly does work when it gets the field id from other fields. One thing to note is that you MUST use this in a Set Fields - I actually don't think it'll even work in a Run Process (though I haven't confirmed this just now, but I'm

Re: OpenWindow vs. PERFORM-ACTION-OPEN-URL

). Doug Mueller *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *Charlie Lotridge *Sent:* Thursday, April 17, 2014 12:07 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: OpenWindow vs. PERFORM-ACTION-OPEN-URL ** A quick update... So

Re: Moving Large Amount of Data to External Remedy System

Hi Kathy, Is it Oracle to Oracle? Why not have the DBA's transfer the data dictionary data tables directly? At a previous client when we upgraded from 7.1 to 8.1 we also switched from Oracle to MS SQL Server. An in place upgrade wasn't an option, so we devised and implemented a strategy that

Re: Filed attributes

No, there's no need to use the custom enumeration type, you just need to go in and switch the Yes name (and labels on all views) to No, and the No name and labels to Yes. HOWEVER you must change the existing data to match the new mapping. I'd recommend using SQL to execute a command like the

Re: OpenWindow vs. PERFORM-ACTION-OPEN-URL

, it's having to communicate with the web server to determine which session is yours, which is taking a bit of time? On Sun, Apr 13, 2014 at 7:37 PM, Charlie Lotridge lotri...@mcs-sf.com wrote: ** Thanks for the suggestion Joe. Unfortunately the solution is not going to be that simple: I

OpenWindow vs. PERFORM-ACTION-OPEN-URL

Hi, Recently I was experimenting using PERFORM-ACTION-OPEN-URL instead of an OpenWindow action to open a Modify window on a specific entry (using the ?eid=request id parameter). It's easy enough to use and I certainly got it working, but the performance as compared to OpenWindow was abysmal. My

Re: OpenWindow vs. PERFORM-ACTION-OPEN-URL

-- *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *Charlie Lotridge *Sent:* Sunday, April 13, 2014 1:51 PM *To:* arslist@ARSLIST.ORG *Subject:* OpenWindow vs. PERFORM-ACTION-OPEN-URL ** Hi, Recently I

Re: Filter Push to View Form

Hi Todd, When you say when we restore the old filter, do you mean loading it from a definitions file (.def or .xml?) or are you restoring it some other way (e.g. a database restore). If you can load the definition from a definitions file and get it to work correctly then an approach using this

Esoteric Bugs relating to ARS View forms

If you use ARS views, this could be a problem for you. It's probably no surprise that if you modify the SQL table (or view) used as the table for an ARS view, and (effectively) rename one of the columns used by one of the ARS view fields, the ARS view breaks. What I discovered, though, is that

Re: Esoteric Bugs relating to ARS View forms

exact version/patch? On Fri, Mar 28, 2014 at 2:27 PM, Charlie Lotridge lotri...@mcs-sf.comwrote: ** If you use ARS views, this could be a problem for you. It's probably no surprise that if you modify the SQL table (or view) used as the table for an ARS view, and (effectively) rename one

Re: Menu Bar in mid-tier (v8.1)

On Wed, Mar 19, 2014 at 9:30 AM, Charlie Lotridge lotri...@mcs-sf.comwrote: ** Hi, Can anyone tell me if the Menu Bar functionality has been deprecated in the mid-tier? The Dev Studio allows me to specify menu bar menus and items just like the Admin tool used to, but I don't see

Re: $NULL$ = $NULL$?

This looks like it might be generated workflow. If so, whatever generated it might normally have a field it would put in place of one side of the relation (normally resulting in 'Some Field' = $NULL$), but for whatever reason in these cases it didn't have such a field so harmlessly substituted

Menu Bar in mid-tier (v8.1)

Hi, Can anyone tell me if the Menu Bar functionality has been deprecated in the mid-tier? The Dev Studio allows me to specify menu bar menus and items just like the Admin tool used to, but I don't see these anywhere when I open the form in the browser. The documentation

Re: BMC should have made upgrades easier - Customers loosing interests

I don't really have the time for this, but let me jump into the fray with a few somewhat related but disparate points of my own... First, with regard to the bad resources issue, I've been seeing pattern for years. On three separate occasions in my career as a Remedy Developer contractor, I've

Re: Get Entry filter trigger - request for opinions

) If you are worried about it being pulled when it is not being used by a visible user you can use the $CLIENT-TYPE$ to only have the filter fire when you want it to. Fred *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *Charlie

Get Entry filter trigger - request for opinions

Hi all, In some 20+ years of doing Remedy development, if I've written 2 filters that use Get Entry as a trigger, that's a lot. I've just never found any significant reason to use the mechanism. But now I'm having second thoughts. So, first, I'd like to get an idea...does anyone use Get Entry

Re: Get Entry filter trigger - request for opinions

want it to. Fred *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *Charlie Lotridge *Sent:* Friday, February 21, 2014 1:44 PM *To:* arslist@ARSLIST.ORG *Subject:* Get Entry filter trigger - request for opinions ** Hi all

FYI...SQL in Set Fields MUST begin with SELECT

I use quite a lot of SQL in my workflow, yet somehow never discovered this one before. It turns out that if you're using SQL to pull data back for a Set Fields action, it must begin with the SELECT keyword, or it won't return any results. For example, if you have a Set Fields with this SQL:

Re: FYI...SQL in Set Fields MUST begin with SELECT

://community.jaspersoft.com/wiki/jaspersoft-security-changes-and-configuration Janie On Thu, Feb 20, 2014 at 11:59 AM, Charlie Lotridge lotri...@mcs-sf.comwrote: ** I use quite a lot of SQL in my workflow, yet somehow never discovered this one before. It turns out that if you're using SQL

Re: FYI...SQL in Set Fields MUST begin with SELECT

executing it or notnot sure what would be found if you went down that rabbit hole. On Thu, Feb 20, 2014 at 1:25 PM, Charlie Lotridge lotri...@mcs-sf.comwrote: ** Interesting, thanks for this info. I suppose this could be what's going on, but I'd think it would be more appropriate for ARS

Re: FYI...SQL in Set Fields MUST begin with SELECT

, Charlie Lotridge lotri...@mcs-sf.com wrote: ** I use quite a lot of SQL in my workflow, yet somehow never discovered this one before. It turns out that if you're using SQL to pull data back for a Set Fields action, it must begin with the SELECT keyword, or it won't return any results

Re: Why does the ARS Service take so long to start?

Another thing to keep in mind is fragmentation of the ARS data dictionary. During startup, (I'm 99% sure that) ARS pulls the entire data dictionary into memory. Over time, as you implement changes and unless you've taken steps to mitigate the problem, the DD will become increasingly fragmented.

Why the 80 character name limit on workflow objects?

In the recent Friday Special thread, there was some discussion about object naming and the need for good naming conventions. The naming convention I've developed for my own use over the years starts with a structured portion (identifying the schema, triggering criteria, execution order, etc), but

Re: Friday Special, The First Post to the ARSList

Hi Joe, Sure the Return trigger works with checkboxes, and exactly as though it were a drop-down or a radio button (in fact, I suspect the underlying mechanism is completely divorced from the display type of the selection field). Try this: Create a selection field with the display type

Re: Friday Special, The First Post to the ARSList

type from radio to check box and it failed, but when I reversed, it worked with no change in workflow. What version are you on? Joe -- *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *Charlie Lotridge *Sent

Re: Friday Special, The First Post to the ARSList

Hi Dan Fred, This brings back memories. Though I've only been a very infrequent participant in the ARSList (something I've been lately trying to change), I've been working with ARS for nearly as long. I was with Brookhaven National Lab (home of the RHIC) back in the 93-94 timeframe when we

Re: Remedy Form Archiving

Hi Nesma, That's a good one. The only thing I can think of is that you have some workflow throwing an error and preventing the operation. If this is the case, here are a few thoughts on how you can locate the problem: First, look for filters that Execute On on Delete and see if any of them

Re: Table Column Data Alignment issue

There have been no responses to this, so I'm guessing that no one has seen this issue. Can anyone confirm that this does work for them? Or is it perhaps a little used feature? Thanks, Charlie On Sun, Jan 26, 2014 at 1:35 PM, Charlie Lotridge lotri...@mcs-sf.comwrote: Hi all, I have

Re: Table Column Data Alignment issue

Of *Charlie Lotridge *Sent:* Sunday, January 26, 2014 4:35 PM *To:* arslist@ARSLIST.ORG *Subject:* Table Column Data Alignment issue ** Hi all, I have several (list type) tables that contain columns that contain integer values. As stated in the documentation, these default to being

Table Column Data Alignment issue

Hi all, I have several (list type) tables that contain columns that contain integer values. As stated in the documentation, these default to being right-aligned. However, when there is any left-aligned value in the column immediately to the right, the data becomes nearly unreadable. This is

Re: Using $GROUPS$ OR $GROUPIDS$ to hide fields for certain Groupid

Remedyart, you had it nearly right, but you need to use $GROUPIDS$ instead of $GROUPS$ (and replace the colon with a semicolon at the end), so: *$GROUPIDS$ LIKE %;10042;%* should do the trick. $GROUPS$ returns the *names* of the groups that the current user belongs to, but without any

Re: CPU utilization sometimes goes up to 100%

Hi all, LJ, ARS absolutely WILL generate nvarchar strings (using the N prefix) on unicode servers, though I have no idea if this particular SQL is being generated by ARS or not. On my 8.1 dev box, Application Pending form has no defined indexes, so there's only the clustered index on the request

Re: Namesake Views

I've heard of this before, and my recollection is that people set up a script to re-grant needed permissions like this that they need and run after each release as part of the rollout procedure. Question for the Oracle gurus out there: would it help to set up a level of indirection on this?

Re: Dev Studio error

gave me a hotfix for it but I think it is addressed in the most recent patch of 8.1. Jason On Sun, Jan 19, 2014 at 9:02 AM, Charlie Lotridge lotri...@mcs-sf.comwrote: ** Hi all, I've only recently moved past working with v7.1, so I'm relatively new to the Dev Studio. While it's

Dev Studio error

Hi all, I've only recently moved past working with v7.1, so I'm relatively new to the Dev Studio. While it's certainly got some benefits over the old Admin tool, it's also got some significant issues. One of the worst of these is that it's very frequently throwing an error that eventually makes

Re: Dev Studio error

increased the memory allocated in the devstudio.ini? On Jan 19, 2014 10:03 AM, Charlie Lotridge lotri...@mcs-sf.com wrote: ** Hi all, I've only recently moved past working with v7.1, so I'm relatively new to the Dev Studio. While it's certainly got some benefits over the old Admin tool, it's

Re: Delta Data Migration for initial data migration.

Hi Ken, For my last client (eBay), I orchestrated an upgrade from 7.1 to 8.1 (data only, not UI) of a purely custom application (no ITSM). The upgrade was complicated by the fact that we decided to move from Oracle back-end to SQL Server, which of course made doing either a direct in-place

Re: Cleaning up forms before migration

Assuming you're planning to delete ALL the data in each of these forms, I agree with Ken Fred: using TRUNCATE TABLE is the only way to go. If you only want to selectively delete data, well, that's going to be a lot more painful though you still may want to consider using SQL (DELETE FROM) for

Re: BMC Dev Studio - Windows 7

Neha, has the run as admin solution worked? This really sounds like a firewall issue to me. In my experience having insufficient privileges (which would be solved with running as Admin), would manifest as a problem with running the Dev Studio executable or its access to local resources, and not

Re: Multiple level join forms

When ARS performs data interaction with a Join form, it simply issues the appropriate SQL against the SQL View it created to represent the Join (named Tschema id of the join). In situations like yours, that SQL View itself references other SQL Views representing the lower level joins, and so on.

Re: Decrypt AR User password

Hi James, You don't need the unencrypted password (and you can't get it anyway). Instead, obtain the original password from the user and use the ARVerifyUser (or ARVerifyUser2) API to let Remedy itself perform the validation. If it validates (i.e. you don't get an error return), then use