LAPI Search and Categories and Attributes using LL_ApplyQuery and .Net

[LaPiMg]

Hi,

I'm trying to build a Search that would start in a user's workspace and list a number of records (50 for example) but including everything, much like when you use the search "From Here" on the Livelink UI.

I was able to Search for Names as well as anything related to the Common Region Names (For example OTDoc, OTName, etc.) I want however to be able to search for contents (assuming that we are doing a full text indexing) as well as Attributes. Particularly with Attributes it is my understanding that we need to use something like:

("Attr_3413_9" : "Joe" )

This is fine, when you know which Categories are associated to a node. However, if you have a bunch of categories, each with a bunch of attributes this becomes really hard to do.

The question is, is there a simple/generic way to simulate the UI's "From Here" search, including in this the Document's text as well as all the possible categories and attributes associated to any node?

Really appreciate your help.

 

[appnair]

I guess my first qn is what language are you planning to do this.You should be able to replicate the livelink advanced search in less than half a day if you follow the faq in this forum.Livelink's search engine will accept a form submission,so you can pretty much do everything with the search XML API.Excellent documentation and support is available in the knowledge base.I have created customized search forms,which I then return as XML and massage it with
stsyle shheets and recived accolades,all following this simple faq.I truly appreciate the thoughfullness of this interface.

However if you want to use LAPI then it becomes a completely different ball game,it is going to be inefficient nerve wracking and so on.I have somwhere in this forum published a smaple for that too but belive me it is not very efficient but just to prove that it exists.

Well, if I called the wrong number, why did you answer the phone?
James Thurber, New Yorker cartoon caption, June 5, 1937

 

[LaPiMg]

Hi appnair,

thanks for your reply. Yeah, I guess that a html form submission is not an option and actually I found a good sample of that. What I'm building is being done in VB .Net as a .Net component (dll) with a hierarchical object model representing part of livelink.
Server
|
+ Workspace
|
+ Folders
| |
| + Documents
+ Search

So, as part of this model, I have this LLSearch object that would do the search and everything is fine to the portion where I need to search the attributes and really it seems ridiculous not having a generic API to include that... Well, i guess I'll have to go with GetObjectInfo to get the categories and FetchCategoryVersion and then get the attributes with AttrListNames and AttrGetInfo. Is that what your sample does? Could you please be so kind as to point me out to where it is? Any help really is appreciated.

Thanks

 

[appnair]

http://www.tek-tips.com/viewthread.cfm?qid=1325684&page=1

To search livelink using categories you need to supply the search engine the category attribute_ID.Those are the cryptiv attr13_ things.

If you were to search a personal workspace for all content,reagrdless of the category wouldn't a * at the personal workspace give you that ?

Still easier

select * from dtree where subtype=142

Gives you all personal workspaces

If it is oracle a connect by query based on the personal worspace will give you each object ID beneath the personal workspace.In the below query I am interested in finding out all documents beneath personal workspaces.For SQl server you may have to write a function

(select dataid from dtree 
where subtype=144 
start with dtree.dataid in 
(select dataid from dtree 
where subtype=142) 
connect by prior dtree.dataid = dtree.parentid)

Once you get the dataid's it is gain possible to find the categories and the attributes value also.

Also with c# or VB shouldn'y you be able to simulate the search XML api,as if sombody submitted the form?



Well, if I called the wrong number, why did you answer the phone?
James Thurber, New Yorker cartoon caption, June 5, 1937