Where is "Status Update History" in Database
Does anyone out there know where the information for "Status Update History" in the Approval Center is located in the database? In particular I am looking for the Status Flag (unpublished or published) for a given update. I am trying to build a report off of this information and I am hoping someone has found this flag in the database. I am using Project Server 2013.
Answered Post from Technet by Raushan_kumar
I am still interested in linking the actual hours approved to the query, but so far have been unsuccessful.
Status History related information are available in MSP_ASSIGNMENT_TRANSACTIONS table however Status Flag can be check by comparing WPROJ_LAST_PUB and ASSN_TRANS_SUBMIT_DATE fields.
SQL Query:
SELECT T.ASSN_TRANS_SUBMIT_DATE, P.PROJ_NAME, A.TASK_NAME,
IS_PUBLISHED = CASE WHEN P.WPROJ_LAST_PUB > T.ASSN_TRANS_SUBMIT_DATE THEN 1 ELSE 0 END
FROM PUB.MSP_ASSIGNMENT_TRANSACTIONS T
LEFT OUTER JOIN PUB.MSP_ASSIGNMENTS_SAVED A ON T.ASSN_UID = A.ASSN_UID
LEFT OUTER JOIN PUB.MSP_PROJECTS P ON A.PROJ_UID = P.PROJ_UID
- User registration with CodeIgniter
- select multiple cells inner join one table
- Split a string with no delimiters into columns
- "FATAL: remaining connection slots are reserved for non-replication superuser connections" triggers despite closing connections
- "Unsupported OP_QUERY command: insert" in Elixir project when trying to insert into Mongo DB
- Sql Server ldf files growing very fast
- How do I change the timezone to UTC in postgres permanently?
- What performance gains can I expect from database paging?
- Model.create is not a function - strapi
- Unable to copy or move file from databases folder with RNFS in react native
- Android Unit Tests Requiring Context
- Delphi FireDAC with MS Access 2010 database. Why does it convert ACE to Jet?
- database - flattened out vs. normalized
- Extract dirname from full path stored in database
- How to find a string inside a entire database?
- Implementing result paging in hibernate (getting total number of rows)
- Options to enforce a logical constraint in an Oracle database
- How can I tell a database to only return data in discrete portions?
- Where is the boundary for creating a table with types in the database?
- How to sort numbers before letters with linguistic sorting?
- How to implement database engine independent paging?
- How to simulate lost update in MySQL?
- Looking for fast ways to process 2 billion rows of data
- Does a SELECT query always return rows in the same order? Table with clustered index
- Delphi XE5 FireDAC Error: Cannot load vendor library [libmysql.dll or libmysqld.dll]
- Can an executable file display a website by precising the url? Can I run a specific website on my own .exe file?
- No start database manager command was issued. SQLSTATE=57019
- How to visualize database tables in postgresql using pgAdmin?
- Django Filter __In Preserve Order
- PostgreSQL - query all tables' all table columns