jdedwardsenterpriseone

How to filter the data for JDE object browser in date format?


I am new user for JDE and JDE Data browser as well. But for what I know the JDE data browser only enables us to do create some filter condition for our data.

Let say I wish to get the data in a range of dates (Example:20/11/2009 To 8/9/2012).

What comment should I put on JDE Data browser? or the JDE data browser didn't support this function?


Solution

  • The JDE Data browser nor the UTB have that capability. You could achieve this only if you had the field two times in your table. It could be achieved via SQL, but then you would have to face data conversion since JDE store data differently that what it display (dates are stored in julian format).

    So the answer to your question: you cannot query a date range on one column in the data browser.

    Work around: query via SQL, but you will have data conversion to do.

    have a good day