Unsolved
This post is more than 5 years old
30 Posts
0
1117
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
Phukon
337 Posts
0
July 23rd, 2010 05:00
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
spatils
30 Posts
0
July 26th, 2010 00:00
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
RajalakshmiGaut
29 Posts
0
July 26th, 2010 02:00
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
spatils
30 Posts
0
July 26th, 2010 03:00
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?