ФОРУМ за света на PTC CREO CAD/CAM/CAE софтуерните решения
Здравейте,


office@cadcamcae.bg

www.soft.cadcamcae.bg - Софтуерни решения за машиностроене;

www.forum.cadcamcae.bg - Форум;

www.blog.cadcamcae.bg - Блог;

http://e-shop.cadcamcae.bg - Електронен CAD магазин;

http://www.facebook.com/cad.digest

http://twitter.com/cadcamcae

3D инженерни мишки;

Поздрави

ФОРУМ за света на PTC CREO CAD/CAM/CAE софтуерните решения

ФОРУМ: Част от проекта на списание CAD ДАЙДЖЕСТ - www.cadcamcae.bg;

CAD ДАЙДЖЕСТ . Едно онлайн издание за CAD/CAM/CAE технологии и машиностроене
 

ИндексИндекс  PortalPortal  CalendarCalendar  GalleryGallery  Въпроси/ОтговориВъпроси/Отговори  ТърсенеТърсене  ПотребителиПотребители  Потребителски групиПотребителски групи  Регистрирайте сеРегистрирайте се  ВходВход  
Вход
Потребител:
Парола:
Искам да влизам автоматично с всяко посещение: 
:: Забравих си паролата!
Social bookmarking
Social bookmarking Digg  Social bookmarking Delicious  Social bookmarking Reddit  Social bookmarking Stumbleupon  Social bookmarking Slashdot  Social bookmarking Furl  Social bookmarking Yahoo  Social bookmarking Google  Social bookmarking Blinklist  Social bookmarking Blogmarks  Social bookmarking Technorati  

Bookmark and share the address of ФОРУМ за света на PTC CREO CAD/CAM/CAE софтуерните решения on your social bookmarking website
Новини от twitter.
Latest topics
Търсене
 
 

Display results as :
 
Rechercher Advanced Search
Споделете с приятел.
Споделете форума В,,, с,,,в,,,е,,,т,,,а,,, н,,,а,,, CAD/CAM/CAE/PLM i Вашия форум за социално споделянеBookmark and Share
Навигация.
 Portal
 Индекс
 Потребители
 Профил
 Въпроси/Отговори
 Търсене
Декември 2016
НедПонВтоСряЧетПетСъб
    123
45678910
11121314151617
18192021222324
25262728293031
CalendarCalendar

Share | 
 

 Intralink Commonspace Search for Locked Objects

Предишната тема Следващата тема Go down 
АвторСъобщение
Admin
Admin


Male Брой мнения : 795
Местожителство : София, България
Job/hobbies : CAD/CAM специалист
Reputation : 3
Points : 5300
Registration date : 27.03.2008

ПисанеЗаглавие: Intralink Commonspace Search for Locked Objects   Вто 13 Май - 15:01:21

2008
Intralink Commonspace Search for Locked Objects

A PTC/User post of mine from Sep 2002:

The official way:

Check out http://www.ptc.com/cs/tan/106363.htm for a TAN describing how to add a search for Commonspace Status (aka Status Description). Also check out http://www.ptc.com/cs/tan/106893.htm for another TAN describing how to add additional filtering options using a similar workaround.

The trick for Locate is to define and save a search for Release Level, then edit your ilprefs.txt file to change the search to Status Description. In the ilprefs.txt file the 'Operand' for a Release Level search is 7. This needs to be changed to 14 for a Status Description search. Set the 'Value' field to be 'Lock*' to search for all locked objects. Set it to '*username*' for objects locked by or shared with a user and also those with Intent to Modify.

After figuring out how to get it to work consistently, I'm beginning to see why searches for Status Description were 'omitted'. I think the developers found that this type of search didn't work right and excluded it from the gui. It seems as if Locate must find everything first, and then it can search for a specific value.

Here is a method that works every time, unfortunately it also takes a really, really long time:



Make sure 'Status Description' is a displayed column in the results section.
Search for: Status Description='*' and Latest Revision/Version. Bypassing this step seems always to produce no results. This isn't needed for every search, but it is needed at least once per session.
Search for: Status Description='*something*'. Where 'something' is what you were looking for in the first place.

The unofficial way:

If you want much faster results (1-2 seconds), you can use the following SQL query to show locked objects and the user who owns the lock. Replace 'joe' with the user name, or use the '%' wildcard (slower). The 'set' and 'col' statements are optional, but help clean up the output.


set linesize 200col username format A15 heading 'User Name'col PINAME format A35 heading 'Object Name'col MODIFIEDON format A15 heading 'Date Changed'col FOLPATH format A75 heading 'Folder Name'select usr.username, pi.piname, brlock.MODIFIEDON, fld.folpathfrom pdm.PDM_BRLOCK brlock, pdm.PDM_BRANCH branch, pdm.PDM_PRODUCTITEM pi, pdm.PDM_USER usr, pdm.PDM_FOLDER fldwhere brlock.brid=branch.brid and branch.piid=pi.piid and brlock.userid=usr.userid and pi.folid=fld.folid and usr.username like 'joe';
To see users with whom a lock is shared and the corresponding objects, use this SQL query. Replace 'joe' with the user name, or use the '%' wildcard.


set linesize 200col username format A15 heading 'User Name'col PINAME format A35 heading 'Object Name'col FOLPATH format A75 heading 'Folder Name'select usr.username, pi.piname, fld.folpathfrom pdm.PDM_BRLOCK brlock, pdm.PDM_BRLOCKSHARED brlockshared, pdm.PDM_BRANCH branch, pdm.PDM_PRODUCTITEM pi, pdm.PDM_USER usr, pdm.PDM_FOLDER fldwhere brlock.brid=branch.brid and brlockshared.brlid=brlock.brlid and branch.piid=pi.piid and brlockshared.userid=usr.userid and pi.folid=fld.folid and usr.username like 'joe';




If you use this query and you get results that have old dates for TXNMSTARTTIME and/or TXNMFINISHTIME, then chances are you have objects that are Locked by System or some other similar problem.

set linesize 200col username format A15 heading 'User Name'col PINAME format A35 heading 'Object Name'col FOLPATH format A75 heading 'Folder Name'select usr.username, pi.piname, txnmaster.TXNMSTARTTIME, txnmaster.TXNMFINISHTIME, fld.folpathfrom pdm.PDM_TXNMASTER txnmaster, pdm.PDM_BRLOCK brlock, pdm.PDM_BRANCH branch, pdm.PDM_PRODUCTITEM pi, pdm.PDM_USER usr, pdm.PDM_FOLDER fldwhere txnmaster.txnmid=brlock.txnmid and brlock.brid=branch.brid and branch.piid=pi.piid and txnmaster.userid=usr.userid and pi.folid=fld.folid
Върнете се в началото Go down
Вижте профила на потребителя http://cadcamcae-bg.top-forum.net
 
Intralink Commonspace Search for Locked Objects
Предишната тема Следващата тема Върнете се в началото 
Страница 1 от 1

Permissions in this forum:Не Можете да отговаряте на темите
ФОРУМ за света на PTC CREO CAD/CAM/CAE софтуерните решения :: PTC CREO 3.0: СОФТУЕР ЗА МАШИНОСТРОЕНЕ :: CREO 3.0: Моделиер от висок клас (бивш Pro/ENGINEER Wildfire) :: PDM/PLM - Pro/INTRALINK; Windchill, ProductPoint-
Идете на: