Skip to main content
B
byork17-Peridot
17-Peridot
February 22, 2012
Question

poid_list_search_attr function help needed....

  • February 22, 2012
  • 7 replies
  • 1598 views

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

    N
    naglists1-Visitor
    1-Visitor
    February 23, 2012
    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?


    N
    naglists1-Visitor
    1-Visitor
    February 23, 2012
    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.


    B
    byork17-PeridotAuthor
    17-Peridot
    February 23, 2012
    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
    B
    byork17-PeridotAuthor
    17-Peridot
    February 28, 2012
    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

    N
    naglists1-Visitor
    1-Visitor
    February 28, 2012
    Wow. Can you post a sample query? (Stripped of proprietary, of course.)

    B
    byork17-PeridotAuthor
    17-Peridot
    February 28, 2012
    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
    N
    naglists1-Visitor
    1-Visitor
    February 28, 2012
    Crazy. Thx.

    Terms & ConditionsCookie settingsAccessibility statement