This portal is to open public enhancement requests against the products and services belonging to IBM Sustainability Software. To view all of your ideas submitted to IBM, create and manage groups of Ideas, or create an idea explicitly set to be either visible by all (public) or visible only to you and IBM (private), use the IBM Unified Ideas Portal (https://ideas.ibm.com).
We invite you to shape the future of IBM, including product roadmaps, by submitting ideas that matter to you the most. Here's how it works:
Start by searching and reviewing ideas and requests to enhance a product or service. Take a look at ideas others have posted, and add a comment, vote, or subscribe to updates on them if they matter to you. If you can't find what you are looking for,
Post an idea.
Get feedback from the IBM team and other customers to refine your idea.
Follow the idea through the IBM Ideas process.
Welcome to the IBM Ideas Portal (https://www.ibm.com/ideas) - Use this site to find out additional information and details about the IBM Ideas process and statuses.
IBM Unified Ideas Portal (https://ideas.ibm.com) - Use this site to view all of your ideas, create new ideas for any IBM product, or search for ideas across all of IBM.
ideasibm@us.ibm.com - Use this email to suggest enhancements to the Ideas process or request help from IBM for submitting your Ideas.
RFE Review board looked at this and decided to leave it in the product backlog. It has been linked to a feature work item in our product backlog.
As I have been working this issue for several programs another issue has cropped up. As I said earlier I am able to get the date though a JRS query, which is not intuitive but can be done. What the ultimate goal (for some programs, not all) is they want to know how many days each completed work item was "in progress". In JRS Data Warehouse this is easy to do in the advanced query section. However in LQE (which I am told is where all the data is going in the future) there is no way to get an exact answer of the number of days between 2 dates that I can figure out. If there is it will be complicated, I know that. The report can be exported to Excel and calculated there but this is a two step process and is annoying to my users. In trying to figure out an algorithm to implement in SPARQL none gives a reliable day difference. They all are +-2 to 3 days. One algorithm where the dates are converted to Julian days and the two Julian days are subtracted (which is supposed to be the most accurate but yields no better results) However, the algorithm is 675 characters long! Now while I know very little about SPARQL, I think that is the case of most users. SPARQL is not trivial to learn especially when your main goal is to work your project and manage your team. If we have a start date in the work item we can very easily write a calculation java script that will give an accurate answer.
Actually, I think it would be more useful, instead of making 1 status change have a query-able date, make the history query-able. That way you could search for the date and time of any status change.