Find all turnover projects and subprojects that are checked out 

 February 14, 2011

By  NickLitten

Ever wanted to see a quick list of everything that is checked out for a Turnover Project? Lets imagine that Project has many subprojects? We can use the Turnover V100 plugin for RDI, or we can use the good old green screen to poke around but it’s much easier to peek into the Turnover Database itself using SQL.

Very easy to see with one simple SQL command:

select * from softturnd/toutlgll where coref# like 'PROJ0099%'

This will show you every object that is checked out for that 'PROJ0099' and all subsequent 'PROJ009901' '02' '03' etc.. projects

If you want to exclude specific levels (on our system Level=’20’ is production) just use the colev field. ie:

 select * from softturnd/toutlgll where coref# like 'PROJ0099%' and colev <> '20'


IBM i Software Developer, Digital Dad, AS400 Anarchist, RPG Modernizer, Shameless Trekkie, Belligerent Nerd, Englishman Abroad and Passionate Eater of Cheese and Biscuits. Nick Litten Dot Com is a mixture of blog posts that can be sometimes serious, frequently playful and probably down-right pointless all in the space of a day. Enjoy your stay, feel free to comment and remember: If at first you don't succeed then skydiving probably isn't a hobby you should look into.

Nick Litten

related posts:

{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}
__CONFIG_colors_palette__{"active_palette":0,"config":{"colors":{"cff50":{"name":"Main Accent","parent":-1},"a344d":{"name":"Accent Transparent","parent":"cff50"}},"gradients":[]},"palettes":[{"name":"Default","value":{"colors":{"cff50":{"val":"var(--tcb-skin-color-0)"},"a344d":{"val":"rgba(46, 138, 229, 0.85)","hsl_parent_dependency":{"h":210,"l":0.54,"s":0.78}}},"gradients":[]},"original":{"colors":{"cff50":{"val":"rgb(0, 178, 255)","hsl":{"h":198,"s":1,"l":0.5}},"a344d":{"val":"rgba(0, 178, 255, 0.85)","hsl_parent_dependency":{"h":198,"s":1,"l":0.5}}},"gradients":[]}}]}__CONFIG_colors_palette__

Get In Touch

Iā€™m always looking for awesome input, feedback and critique!