AnsweredAssumed Answered

resource for approver

Question asked by shivakumar.yellam on May 23, 2013
Latest reply on May 29, 2013 by another_martink
a list of resources who do not have any approvers , i need to write the sql query for this. i need to display this fields resource name, resource id, obs, resource manager, approver for resource. i can able to display four fields, i am not able to do that for approver for resource. we need to display the approve names for resource and resouce does not have approver that field should be blank please suggest which database table is using for this field, any body has SQL query on those fields. thanks, siva