• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

E9.1 How to delete favorites of jde userids by sql ?

johnsnow

Member
Hi Friends,
We found below query to delete favorites from userids (example here : BB and AA). After executing this query , user complained about menus went missing . So we restored table F9001 and F9000.
Please have a look at this query and suggest if it requires any modification further ?
delete from ctl.f9000 where tmtaskid in (select trchildtsk from ctl.f9001 where trparnttsk in (select tmtaskid from ctl.f9000 where tmlngtask in ('@BB','@AA') and tmtasknm in (''@BB','@AA') ))

Regards,
J
 

jean_driscoll

VIP Member
When you first used select instead of delete to test the statement what records came up?

(select tmtaskid from prodctl.f9000 where tmtasknm like '@%' and tmtasktype = '07') = favorites
 
Top