how to pass attribute 'Text-Field' value to 'Text- Table Key Lookup' attribute

We have created a category wherein we have cascade attributes using table key lookup.

First attribute is ID which is a 'Text:Field' attribute.

Second attribute is name which is 'Text: Table Key Lookup' attribute

ID is being entered by user as text value and then second column does not return any value. This is happening only becasue column 1 is a test value attribute. If we keep this as integer , it works fine. We need this to be working in text case only as our user IDs are like 'CD5268'

Please help!

table keep lookup issue.jpg

Find more posts tagged with

Comments

Hans Stoop

You need to put the attribute name in ‘<’ and ‘>’.

Hans

From: eLink Entry: Content Server Development Forum [mailto:development@elinkkc.opentext.com]
Sent: Dienstag, 3. Mai 2016 14:08
To: eLink Recipient
Subject: how to pass attribute 'Text-Field' value to 'Text- Table Key Lookup' attribute

[Attachments exceeded pre-set size limits. Use the links provided to access]

how to pass attribute 'Text-Field' value to 'Text- Table Key Lookup' attribute

Posted by Walia, Abhimanu On 05/03/2016 08:03 AM

We have created a category wherein we have cascade attributes using table key lookup.

First attribute is ID which is a 'Text:Field' attribute.

Second attribute is name which is 'Text: Table Key Lookup' attribute

Please help!

Attachment Links:

table keep lookup issue.jpg (86 KB)

[To post a comment, use the normal reply function]
Forum:	Content Server Development Forum
Content Server:	Knowledge Center

Abhimanu_Walia

Hi Hans,

Thank you very much for your Reply, i changed this as you mentioned see below query but now i get different error. However i check that attribute 'IonsID' exist as my first attribute.

=================================Lookup query=========

select distinct aka_id from mip_person where aka_id = '<’ IonsID ‘>' order by aka_id

-----------------------------------------------------------------------------------------------------------

Error.JPG

Pramod Mohandas

Don’t put the quotes. Just the angular brackets will do.

select distinct aka_id from mip_person where aka_id =<IonsID> order by aka_id

eLink User

You should be able to do this with the GUI of Attribute Extensions or A D N Table Key but the format looks like this

select VALUE "Project", DESCRIPTION "Project Name" from some_table

where CATEGORY = <Document Category>

and KEY1 = 'Project' and DELETED = 0 order by VALUE

In this example I have defined a attribute called Document Category

the rest is just SQL and tables that make sense for us.

If you are new to this consider doing the example that shows you the City,State,Country example

trying to show a screen cap hope it makes it.The pull down will show values if a user has picked a value of the

preceding attribute,which is "cascaded" into the next.

.....appu appnair appunair

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

On Tue, May 3, 2016 at 8:14 AM, eLink Entry: Content Server Development Forum <development@elinkkc.opentext.com> wrote:

[Attachments exceeded pre-set size limits. Use the links provided to access]
RE how to pass attribute 'Text-Field' value to 'Text- Table Key Lookup' attribute Posted byWalia, AbhimanuOn 05/03/2016 09:08 AM

Hi Hans,Thank you very much for your Reply, i changed this as you mentioned see below query but now i get different error. However i check that attribute 'IonsID' exist as my first attribute.=================================Lookup query=========select distinct aka_id from mip_person where aka_id = '<’ IonsID ‘>' order by aka_id-----------------------------------------------------------------------------------------------------------

Attachment Links:
Error.JPG(37 KB)
[To post a comment, use the normal reply function]
Topic: how to pass attribute 'Text-Field' value to 'Text- Table Key Lookup' attribute
Forum: Content Server Development Forum
Content Server: Knowledge Center

image.png

Abhimanu_Walia

Thank you all for your reply.

We found the solution. i believe this is a bug and this was happening due to text attribute has trailing spaces while we pass this to text table key lookup. This happen only when you pass a text attribute to table key lookup. This works fine when you pass number or TKL attribute to a TKL attribute.

Our query worked this way.....

select distinct column_name from "Tablename" where TRIM(aka_id) = TRIM(<IonsID>) order by first_name