Repeating attribute in Conditional Value Assistance

We have a repeating attribute (attribute_1) with different retrieved values from a registered table by a DQL query in the Conditional Value Assistance. This attribute shows all the values in the registered table then the user selects the values that he wants to add therefore this attribute can have more than one value. This is fine.

The problem is that we have a different repeating attribute (attribute_2) that depends on the previous selection by the user on the first attribute values (attribute_1) and the same registered table to obtain their values. We want to get those values through defining a DQL query in the Conditional Value Assistance in composer. But the value assistance shows just the first value obtained by the query even if attribute_1 have more than one.

What would be the right way to do a query for this?

is it possible in Conditional Value Assistance?

Thanks

Find more posts tagged with

Note:

If there are Accepted Answers, those will be shown by default. You can switch to 'All Replies' by selecting the tab below.

Accepted answers

DCTM_Guru

This is not supported in Conditional Value Assistance. You will need to customize wdk component and write your own query. The challenge is to support OR search clause without having a fixed limit.

For example:

select * from my_type where attribute_2 = "attribute_1 value 1" OR attribute_2 = "attribute_1 value 2" OR attribute_2 = "attribute_1 value 3" ...

All comments

DCTM_Guru

This is not supported in Conditional Value Assistance. You will need to customize wdk component and write your own query. The challenge is to support OR search clause without having a fixed limit.

For example:

select * from my_type where attribute_2 = "attribute_1 value 1" OR attribute_2 = "attribute_1 value 2" OR attribute_2 = "attribute_1 value 3" ...

JAlfredo

Thank you Johnny

I have a lot of values, for my case I guess is better the wdk customization

DCTM_Guru

You can also use IN clause:

select * from my_type where attribute_2 IN ("attribute_1 value 1","attribute_1 value 2","attribute_1 value 3",...)

JAlfredo

Thank you Johnny

The big problem is that I don’t know which are the values in the attribute_1 because those depends the user selection and these values are comparing whit values from a registered table.

Pump

you can look at the previous forum helps like https://community.emc.com/message/264066

that should get you going

JAlfredo

Unfortunately we have more than 70 and may increase, is the reason why the values are in a registered table and we can’t handled all the values with conditions.

I’ll try to explain myself better

This is my table (example)

nam_company	key_soc
Name1	1
Name2	2
Name3	3
Name4	4
Name5	1000

Attribute_1(cod_repsoc) and attribute_2 (key_soc)

on our first query (select distinct key_soc from dm_dbo.SOCIETY order by 1) the values shown are: 1,2,3,4,1000

The user select: 1,4,1000. (there are the values in attribute_1)

on the second query (select nam_company from dm_dbo.SOCIETY where key_soc = 'cod_repsoc' order by 1) we want obtain the following values: Name1,Name4, and Name5

This query just take the first value

The question is: how to obtain all the values in the attribute_1 for comparison with values in the table?

DCTM_Guru

I dont think you can do this with single query. The easiest way to solve your problem is to run individual subqueries based result set of your initial query.

JAlfredo

I understand that you said that is necessary do these subqueries to get the value in each position.
Could you please confirm if my understanding is correct?

This is possible in Value Assistance

DCTM_Guru

Value assistance is NOT going to fire each time you add a value of attribute_1 and JOIN the search results. As stated before, you will need to write your own component.

rbhavanasi

Hi All

We have same requirement with our clients, It is very difficult WDK customization.

I have acheived by using WDK customization with lot of investigations.

Step 1) Required to write custom tag class for specific attribute

Step 2) provide the tag class information in docbaseobjectconfiguration_dm_sysobject.xml (of course in custom folder)

sample:

<names>

<tagclass>com.****.****.xxxValHandler</tagclass>

</attribute>

</names>

</docbaseobjectconfiguration>

</scopt>

</config>

Step 3: Write a class which extends DocbaseAttributeTag

Override the renderEnd Method and query the data and fill the result by using the DocbaseValueAssitance Class (refer DocbaseValueAssitance Class) and lastly required to call super.renderEnd(out)