cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Want the oppurtunity to discuss enhancements to PTC products? Join a working group! X

poid_list_search_attr function help needed....

byork
17-Peridot

poid_list_search_attr function help needed....

Does anyone have any experience with poid_list_search_attr. I am having a heck of a time trying to figure out the query string I need to use with the function.


Thanks in advance.

7 REPLIES 7
naglists
1-Visitor
(To:byork)

No experience with that function. Are you querying a Documentum repository?
I have DQL queries of various types saved.

Here's one:
select object_name, r_version_label, owner_name, r_object_type,
a_content_type from dm_sysobject WHERE (((upper(object_name) = upper('
myobjectname')))) AND folder('/foldername', descend)

AND folder() searches a top level folder (or cabinet).
descend recurses all folders in the named folder.

The query above probably has more () than necessary. I tended to build
queries, save them. Copy paste and adapt them. Save them. And repeat as I
had different needs. If it worked, I was happy ... I got no style points
... so ...

DQL can be persnickety about quote types. If you're already doing something
close to this, I'll guess proper quoting might be your problem.

It might help to know that the DQL is translated prior to execution to the
query language of the hosting database. In our case, it was SQL Server or
t-sql. You might be in Oracle. *Maybe* this is ... relevant in edge cases?


naglists
1-Visitor
(To:byork)

this might be an even easier "proof of life" query:

select * from dm_sysobject WHERE r_object_id = 'put an object id here'

or even:

select count(*) from dm_sysobject

although I guess I don't know what your poid_xxxx will do with a num.


byork
17-Peridot
(To:byork)

Paul,

Thanks for the info.

I am trying to query against PDMLink. Not sure if it will work that way for PDMLink but I will give it a try.

Thanks,
Brian
byork
17-Peridot
(To:byork)

Well here is what I figured out.

The query string needed to be formatted with special characters like SOH, STX and ETX. Once I used those correctly thing worked for me.

Thanks for your help.

Brian

naglists
1-Visitor
(To:byork)

Wow. Can you post a sample query? (Stripped of proprietary, of course.)

byork
17-Peridot
(To:byork)

Paul,

The query stings looks something like this.

[cid:image001.png@01CCF60E.8F92A830]


Example of how I'm using it.

[cid:image002.png@01CCF60E.8F92A830]

[cid:image003.png@01CCF60E.8F92A830]

Brian
naglists
1-Visitor
(To:byork)

Crazy. Thx.

Announcements

Top Tags