spatils
3 Argentium

Query based Value Assistance

Hello Experts,

I am facing one issue while using date column in where clasue in QBVA.

I have used following query in

SELECT DISTINCT MPL_POL_CARR_LOC  FROM DM_DBO.MDOCS_POLICY_LKUP  WHERE mpl_company_nbr = '$value(mdocs_company_nbr)' AND mpl_policy_eff_date = '$value(mdocs_policy_eff_dt)'  order by MPL_POL_CARR_LOC  asc

In above query  both mpl_policy_eff_date and mdocs_policy_eff_dt are date type.

I could install dar successfuly. But when accessing this attribute I am getting following error.

Wed Jun 30 06:48:12 2010 106193 [DM_QUERY_E_CURSOR_ERROR]error: "A database error has occurred during the creation of a cursor ('ORA-01858: a non-numeric character was found where a numeric was expected

')."

Please let me know if anybody has used DATE field in QBVA.

Regards

Sameer

Tags (2)
0 Kudos
4 Replies
Phukon
3 Zinc

Re: Query based Value Assistance

Hi,

I see that your thread has been unanswered yet. For Quicker reply please post this question in the following group:

ECN >                      Support  Forums >                           Documentum >             Discussions

Here are few links/threads which may be useful:

http://customernet.emc.com/developer/tippage.htm#0900c35580265daa

https://community.emc.com/message/260370#260370

Cheers

Phukon

0 Kudos
spatils
3 Argentium

Re: Query based Value Assistance

Phukon,

thanks for the interest in my post.

I am able to use QBVA successfuly for string data type.

But it gives error for when i use date data type.

I think its limitation of QBVA.

regards

Sameer

0 Kudos
Highlighted
RajalakshmiGaut
3 Argentium

Re: Query based Value Assistance

Hi,

Can you try converting the value on RHS to date and thn add to LHS.

mpl_policy_eff_date = date($value(mdocs_policy_eff_dt)).

Rajalakshmi

0 Kudos
spatils
3 Argentium

Re: Query based Value Assistance

Thanks for replay  Rajalakshmi .

I tried taking out date function also. But it did not work.

Have you ever used QBVA for date columns successfuly?

Did following example worked for you?

0 Kudos