tag:blogger.com,1999:blog-4496361440376457974.post8577260166783515171..comments2024-03-27T04:40:00.049-07:00Comments on Connecting the {Dots}: Using component for filtering child nodes of a treeJobinesh Purushothamanhttp://www.blogger.com/profile/02803942794714887699noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-4496361440376457974.post-14882127380799416702013-06-04T03:45:56.085-07:002013-06-04T03:45:56.085-07:00Jobinesh,
This is with reference to your Blog htt...Jobinesh,<br /><br />This is with reference to your Blog http://www.jobinesh.com/2011/03/using-component-for-filtering-child.html<br /><br /><br />I have a requirement where i need to display Email along with first name and last in the search drop down of Quick Query<br /><br /><br />To achieve that<br /><br />I added another bind variable called bndVarEmail and altered the query of Employees View<br /><br />SELECT Employees.EMPLOYEE_ID,<br /> Employees.FIRST_NAME,<br /> Employees.LAST_NAME,<br /> Employees.EMAIL,<br /> Employees.PHONE_NUMBER,<br /> Employees.HIRE_DATE,<br /> Employees.JOB_ID,<br /> Employees.SALARY,<br /> Employees.COMMISSION_PCT,<br /> Employees.MANAGER_ID,<br /> Employees.DEPARTMENT_ID<br />FROM EMPLOYEES Employees<br />WHERE (Employees.FIRST_NAME = :bndVarFirstName OR :bndVarFirstName IS NULL) AND (Employees.LAST_NAME = :bndVarLastName OR :bndVarLastName IS NULL)<br />AND (Employees.EMAIL = :bndVarEmail OR :bndVarEmail IS NULL)<br /><br /><br /><br />but still my email is not appearing in the drop down of search.<br /><br />How to add multiples values in Search DropDown of Quick Query ?<br /><br />Thanks in advance.<br /><br /><br /><br />Regards<br />VidyaAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-4496361440376457974.post-28818364151655546092012-12-14T01:23:21.836-08:002012-12-14T01:23:21.836-08:00try using criteriaItems facet for af:quickQuerytry using criteriaItems facet for af:quickQueryJobinesh Purushothamanhttps://www.blogger.com/profile/02803942794714887699noreply@blogger.comtag:blogger.com,1999:blog-4496361440376457974.post-28106415809675364082012-12-14T01:01:15.702-08:002012-12-14T01:01:15.702-08:00Hi Jibonesh,
This post is really helpful.. but I ...Hi Jibonesh,<br /><br />This post is really helpful.. but I need to turn off one feature on QuickQuery .. I do not want to have drop down in the Query component. Could you please provide me some inputs on this?swathhttps://www.blogger.com/profile/06369206205109044976noreply@blogger.comtag:blogger.com,1999:blog-4496361440376457974.post-77091805056419755242011-07-28T13:51:39.994-07:002011-07-28T13:51:39.994-07:00Awesome ! Thanks a lot.Awesome ! Thanks a lot.Luis Correahttps://www.blogger.com/profile/04976100878886407931noreply@blogger.com