How to reference the form's dataid in a key table lookup

I am trying to create a key table lookup on a form template that needs to access the form's dataid. I tried using this code:

select valstr FROM LLUSER . LLATTRDATA

WHERE DEFID = 112475 AND ATTRID = 28 and

id in (select dataid from lluser . dtree where

dataid in (select parentid from lluser . dtree where

dataid in (select parentid from lluser . dtree where dataid = < dataid >)))

I make the form from the template, and when I try my dropdown, I get this message:

Livelink Error: [The attribute named "dataid" was not found though it was referenced in the definition of "Size_Code".]

I know that the dataid is shown in the URL as objId.

Is there an easy way to reference the forms dataid (objId) in a form template?

I am using Livelink 9.7.1

Find more posts tagged with

Comments

Appu_Nair1

I know that the dataid is shown in the URL as objId.

See this example and see if this is what you are after rather done hurry berry so not sure if it is really what you want or not.Anyways I won't be able to help with specific queries you have just showing you manythings with client javasacript can be done to make forms a little easy on the user.

Unfortunately your template and my template varies so I will walk you thru a simple example.If you follow my simple example rather than try to retrofit in your project you can see it is not impossible.

Step 1-Create a Form template and create a Integer field called FORMID & DYNAMICQUERY.Inside this DynamicQuery insert this SQL --select name from dtree where dataid=<FORMID>.You should be able to tset it with any valid dtree.objid to your heart's content.

Step 2-Export the Form template as HTML and see my accompanying attachment for all Areas where you will SEE me say 'APPU'.Now that is because of livelink's inherent transportability problem.I did not want to create a livelink project dump my template and forms and have to pick it up from the ensuing xml. https://knowledge.opentext.com/knowledge/cs.dll?func=ll&objId=38094929&objAction=download&viewType=1

Step 3- Create a Form template from above for simplicity select the HTML view you added and say you don't want revisions and you are happy with Livelink Versions.(A couple of tests will create a couple of dat files)

If the javascript works when you bring up the form you should get an alert and you should see CLIENT JAVASCRIPT FILLING FORMID.If you click the DYNAMICQUERY you will see the dtree row coming from livelink.

Note tested now on a 9.7.1 system with no guarantees of working

stevesscreen

Hi Appu,

I was able to follow you through Step 2 but I am not sure how to complete Step 3:

I am not familiar with creating templates from an HTML file.

Thanks!

Appu_Nair1

I really meant Create a Form, from the template with the amended view.I am sorry if that confused you so here's hopefully better instructions.If you know how to preconsttaite form templates from a xml (project) file I can throw everything in XML and have you pick it up as well.

Read this Step 3- Create a Form template from above for simplicity select the HTML view you added and say you don't want revisions and you are happy with Livelink Versions.(A couple of tests will create a couple of dat files

Step 3-STEP 1 is a Form template that you created with the two attributes.Step 2 is basically exporting step1 form template as HTML,adding the extra javascript I added in the head and body section.After you do that you have to find the Step1 Form Template and find where it says VIEWS,it is somewhere near the properties stuff in functions menu.You will see a place to ADD a HTML view.Now you will add this HTML file with the revised javascript as the VIEW.

Step 4:On the Form Template(Step 1) with the amended view,click 'Make Form' from its function menu.It will ask questions,it knows you want a form form the template so it will be filled in,in that

Custom View=the view that you created if there are more views it will show there in your case only one ,

Revision Mechanism-None

Submission Mechanism-Livelink Versions

Stationery Pad -unchecked default

At run time the form is prefilled by oscript and shown to the browser,with the view that you specify.All I am doing there is basically client javascripting