I've created a simple form "ADM:TK:DeleteEntryQueue" in where you push the SchemaName and the requestID (Field 1) ... Then a periodic escalation runs through and performs the Run-Process-Delete-Entry.
Works like a champ - especially with the extended features such as a "delete time" so you can batch delete bunches of entries during off-hours... On Tue, Jan 4, 2011 at 9:31 AM, Ben Chernys < [email protected]> wrote: > ** > > If you use the API you need permissions. The API adhere to the ARS > permissions model (of course). Note again that you cannot inhibit > filters. So, a filter could simply throw an error and abort an API delete. > I use these (and Meta-Update) as a matter of convenience when problem > solving, developing, etc. > > > > Cheers > > Ben > > > > *From:* Action Request System discussion list(ARSList) [mailto: > [email protected]] *On Behalf Of *LJ LongWing > *Sent:* January-04-11 17:27 > > *To:* [email protected] > *Subject:* Re: Deleting entry with api > > > > ** > > Ben, > > I’m curious. How have you written an API based program that deletes > records without sufficient permissions? > > > > *From:* Action Request System discussion list(ARSList) [mailto: > [email protected]] *On Behalf Of *Ben Chernys > *Sent:* Tuesday, January 04, 2011 8:51 AM > *To:* [email protected] > *Subject:* Re: Deleting entry with api > > > > ** > > > > We do have such a binary(binaries) the delete with the API. It’s available > in Windows and support ARS platforms. > > > > It is also relatively easy for you to make such a binary. Note that you > cannot inhibit filters that fire on Delete with the API. > > > > I am currently considering marketing and publication options such as > packaging it with the Meta-Update distribution or making them available > separately. This consideration ranges to a set of binaries including a > query tool, so you could say, query first, then delete. > > > > The binaries work something along the lines of: > > > > SthMqry –c schema query to return results count only > > SthMqry –n schema query to return results only > > SthMqry schema query to return results with field values on > separate lines > > SthMqry –f schema query to return results with field values as > a CSV for say, Excel > > SthMqry –S “;” schema query (specify CSV separator) > > > > SthMdel –q schema query to delete results of query > > > > And additionally to the SthMqry synopsis above, Meta-Query supports SQL > queries. > > > > SthMqry –q sql_query issues an SQL query through the API; > also supports -f > > > > Email me off-list if you’re interested or want to know more. > > > > Happy New Year! > > > > Ben Chernys > > Senior Software Architect > Software Tool House Inc. > > Canada / Deutschland / Germany > Mobile: +49 171 380 2329 GMT + 1 + [ DST ] > Email: Ben.Chernys _AT_ > softwaretoolhouse.com<[email protected]> > Web: www.softwaretoolhouse.com > > Check out Software Tool House's free Diary Editor. > > *Meta-Update**,* our premium ARS Data tool, lets you automate > your imports, migrations, *in no time at all*, without programming, > without staging forms, without merge workflow. > http://www.softwaretoolhouse.com/ > > > > > > > > *From:* Action Request System discussion list(ARSList) [mailto: > [email protected]] *On Behalf Of *Marek B. > *Sent:* January-04-11 16:00 > *To:* [email protected] > *Subject:* Deleting entry with api > > > > ** > > Hi listers, > > > > Is there any method to delete an entry in a custom form via java or dotnet > api? > > Using a DeleteEntry method gives me no administrative permissions error, > which is correct and I don't want to give such permissions. > > Also I don't want to create any extra workflow on server side. Is it > feasible? > > > > regards, > > Marek > > _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ > > _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ > > _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ > _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ > -- If it were not for the gutter, my mind would be homeless! _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
