sql - How to find all checked out packages in Sparx Enterprise Architect? -

similar this question except i'd find all checked out packages (and ideally list checked them out) rather own.

am assuming there must way of doing modifying sql provided ea's search builder answer linked question - couldn't figure out how...

here current attempt adapted built in "my checked out packages" search query:

select  t_object.ea_guid classguid, t_object.object_type classtype,t_object.name object, t_object.object_type [type], t_object.stereotype, t_object.scope,t_object.status, t_object.phase, t_object.createddate, t_object.modifieddate, mid(t_package.packageflags, instr(t_package.packageflags, 'checkedoutto') + 13, instr(mid(t_package.packageflags, instr(t_package.packageflags, 'checkedoutto') + 13), ';') - 1) checkedoutto t_object, t_package t_object.object_type='package' , #db=other#t_object.pdata1 = cstr(t_package.package_id)#db=other# #db=oracle#t_object.pdata1 = to_char(t_package.package_id) #db=oracle# #db=openedge#cast(t_object.pdata1 char(25)) = cast(t_package.package_id char(25))#db=openedge# #db=asa#t_object.pdata1 = cast(t_package.package_id char)#db=asa# #db=sqlsvr#t_object.pdata1 = cast(t_package.package_id char(25))#db=sqlsvr# #db=mysql#t_object.pdata1 = t_package.package_id#db=mysql# #db=postgres#t_package.package_id = t_object.pdata1::text::int#db=postgres# , t_package.packageflags '*checkedoutto=*' order t_object.name 

the hashed bits macro string replacers documented here.