Querying a database using LAPI with .NET

Can any one please let me know how to retrieve the information from kuaf table and store the results using LAPI with .NET?

Find more posts tagged with

Comments

Appu_Nair

Could you clarify the requirement.This code excerpt published by OThttps://knowledge.opentext.com/knowledge/llisapi.dll?func=ll&objId=3728655&objAction=ArticleView&viewType=1shows you how a Live Report can be run thru LAPI.Usually KUAF stores user group information and the LAPI_USERS class parts you that info as well.here's an example that does ithttps://knowledge.opentext.com/knowledge/llisapi.dll?func=ll&objId=3754925&objAction=ArticleView&viewType=1If your lladministrator gives you access to the ll schema you can just use typical database access methods to get that info as well.

Support_Lloyds_Register

Thank for your reply Appu. I would like to retrieve all the group names from kuaf table. How to do this?I have used Listgroups() method, ans used hasmoreElements() method to list out all the group names, but it also displays many other unuseful information

Appu_Nair

You probably need to use EasyLapi or study how to parse the livelink api datastructures aka LLValue objects.I enclose a cs file that shows common approaches.Not tested for any performance etc just to show how it can be done.