. I have been struggling with this all day.
** **
*From:* Action Request System discussion list(ARSList) [mailto:
arslist@ARSLIST.ORG] *On Behalf Of *Brian Goralczyk
*Sent:* Thursday, August 15, 2013 5:47 PM
*To:* arslist@ARSLIST.ORG
*Subject:* Re: SQL Query
** **
**
Do
Don't forget your H350 table too. But the C1 from T350 if I remember
right is the C1 from H350 B350.
Also, can't you do this with an escalation or filter? If you do this
with workflow the system will get all the sub tables for you.
From: Action Request System discussion list(ARSList)
Kathy,
Is this about the RE:Job Runs form?
Use ARSystem to do the delete. It will clean up H and B tables for you. Did you
create the filter to do the delete?
Are you having an issue deleting the RE:Job runs records?
Regards,
Ryan.
From: Action Request System discussion list(ARSList)
Is there any reason you can't remove them using the client?
You would have to do a compound query and do the B and H table(s) first before
deleting from the T table
i.e.
Select C1
From B350
Where C1 in (Select C1 from T350 Where C8 = 'Reconciliation' )
Select ENTRYID
From B350C536870923
Where
Of Kathy Morris
Sent: Thursday, August 15, 2013 10:43 AM
To: arslist@ARSLIST.ORG
Subject: Re: SQL Query
**
**
Our performance is so poor right now that we are doing this directly thru SQL.
I did not do a query on C1, I queried C8. Is there something that need to do
with C1?
We are trying
some history.
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Downing, Ryan
Sent: Thursday, August 15, 2013 11:03 AM
To: arslist@ARSLIST.ORG
Subject: Re: SQL Query
**
Kathy,
Unless you need to keep the records in this form...perform
@ARSLIST.ORG
Subject: Re: SQL Query
**
Is there any reason you can't remove them using the client?
You would have to do a compound query and do the B and H table(s) first
before deleting from the T table
i.e.
Select C1
From B350
Where C1 in (Select C1 from T350 Where C8
: Re: SQL Query
**
Is there any reason you can't remove them using the client?
You would have to do a compound query and do the B and H table(s) first
before deleting from the T table
i.e.
Select C1
From B350
Where C1 in (Select C1 from T350 Where C8 = 'Reconciliation
: Thursday, August 15, 2013 11:24 AM
To: arslist@ARSLIST.ORG
Subject: Re: SQL Query
**
***
What is B350C536870923?
When I entered this value B30+the column - the query did not work for me.
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick
*Subject:* Re: SQL Query
** **
**
Is there any reason you can’t remove them using the client?
** **
You would have to do a compound query and do the B and H table(s) first
before deleting from the T table
** **
i.e.
Select C1
From B350
Where
System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Brian Goralczyk
Sent: Thursday, August 15, 2013 5:47 PM
To: arslist@ARSLIST.ORG
Subject: Re: SQL Query
**
Do NOT use an escalation. It will review all the rows. Unless you are
running it on a different table that doesn't
11 matches
Mail list logo