table key lookup

[ahaboub]

i have a "table key lookup" attribute in a category, and i want it to read data from an external database (one residing on a different server)
is there any needed configuration to do this?

 

[appnair]

The only way is to make the other table to be made pretend to be belonging to the livelink schema.

For eg if you use this query for your tablekey thing

select * from dtree where subtype=0 the resaon it works is because livelink knows it as table in its database.

So using SQlserver or Oracle it should be possible to create an entry in the livelink schema for your foreign table. Livelink will not know its difference.Check with your DBA for the specifics about it

Several companies have asked for this feature including me,so you should have your company added to it.

I think you already know webforms can query external database tables and a kludged soln using workflows could be conceived as well

Well, if I called the wrong number, why did you answer the phone?
James Thurber, New Yorker cartoon caption, June 5, 1937
Certified OT Developer,Livelink ECM Champion 2008

http://www.tek-tips.com/faqs.cfm?fid=2884

http://www.linkedin.com/in/appunair

 

[ahaboub]

i had the same thoughts too, unfortunatly no other workarrounds

thanks anyway

 

[ninhkieu1]

how do I check for an audit deleted user(s)? I want to know when did he get deleted, who deleted him, which group he was in, and why (if any). Thanks.

 

[appnair]

first of all this information is in dauditnew table but the catch is that this event needs to be audited.It may be one that is default turned on.Otherwise the only way is to go thru webserver logs or lightweight timings logs all of which are more work that regular dauditnew queries.

Well, if I called the wrong number, why did you answer the phone?
James Thurber, New Yorker cartoon caption, June 5, 1937
Certified OT Developer,Livelink ECM Champion 2008,Livelink ECM Champion 2010

http://www.tek-tips.com/faqs.cfm?fid=2884

http://www.linkedin.com/in/appunair