Issue with repating attribute

Hello experts,

I have a repating attribute where I have stored some data. Now I have a form which selects the data from the attribut and lists in a list box.

When I try with this query "select case_c_e_evaluation from s_org_config where ANY case_c_e_evaluation is not nullstring" the result is something like this,

When I try with yhis query, select case_c_e_evaluation from s_org_config where ANY case_c_e_evaluation is not nullstring AND ANY case_c_e_evaluation!=''

it retruns no results.

Please help me to solve the issue.

Find more posts tagged with

Documentum

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

Try this:

select case_c_e_evaluation from s_org_config where ANY case_c_e_evaluation is not nullstring ENABLE (ROW_BASED)

All comments

Try this:

select case_c_e_evaluation from s_org_config where ANY case_c_e_evaluation is not nullstring ENABLE (ROW_BASED)

Johnny,

I guess I am too tired.

Hi Imran,

So, does the query suggested by Johnny worked? :-)

yes