Clarity

  • Private Community

  • 1.  Unfilled Requirement Allocation

    Posted Jul 26, 2012 09:20 PM
    I need to write a SQL query to show the "Unfilled Requirement Allocations" i.e., the unfilled Roles and their soft allocations.

    1) Any idea of how to do it?
    2) Also, please guide me as to how we know what data needs to be pulled from which table?


    Also, any sort of conceptual explanation will be highly appreciated. Thanks for your time!


  • 2.  RE: Unfilled Requirement Allocation
    Best Answer

    Posted Jul 27, 2012 03:23 AM
      |   view attached
    You could have a look at the Unfilled Requirements portlet.
    That is using the team allocation as the data provider.

    The Tech ref is a good place to start.
    See the Entity Relationship diagrams and then the table descriptions.



    Martti K.

    .


  • 3.  RE: Unfilled Requirement Allocation

     
    Posted Jul 31, 2012 04:47 PM
    Hi rk,

    Did Martti's response help answer your question? If so please mark his post as Accepted Solution.

    Thanks!
    Chris