We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Search not working for LOV in BI Publisher Report

Accepted answer
31
Views
3
Comments
edited Feb 11, 2020 10:33PM in Reporting and Analytics for ERP 3 comments

Summary

Search not working for LOV in BI Publisher Report

Content

Hi Team,

I have created LOV through SQL in BI Publisher Report. If i am using value without transforming , search is working fine. As soon as i start using to_date or to_char function in the SQL, search stops working. Below are the SQL for the LOV :

 

LOV Query  : User is able to search Manually 
 
SELECT GP.period_name as pname
 FROM gl_periods gp
 
 
LOV Query : 'User is not able to Search , even though value is available in the list. 
SELECT TO_DATE(gp.period_name,'Mon-yy', 'NLS_DATE_LANGUAGE=ENGLISH') as pname

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!