I’m working on a Generic Inquiry (GI) to display projects, and I need to filter the results based on the logged-in users employee record.
Howver, I added the condition as the EPEmployee.UserID=@me.
Below are the tables I have used and the relationship. I could not get the excat values.
Best answer by noorula77
Revised Table Structure
Add PX.Objects.CR.Contact as a new data source with alias Contact
| Alias | Table |
| PMProject | PX.Objects.PM.PMProject |
| EPEmployee | PX.Objects.EP.EPEmployee |
| EPEmployeeContract | PX.Objects.EP.EPEmployeeContract |
| Customer | PX.Objects.AR.Customer |
| CreatedBy | PX.SM.Users |
| Contact | PX.Objects.CR.Contact (add this) |
Relations Tab Setup
| Parent Table | Parent Field | Child Table | Child Field | Join Type |
| PMProject | CustomerID | Customer | BAccountID | LEFT JOIN |
| PMProject | CreatedByID | CreatedBy | PKID | LEFT JOIN |
| EPEmployee | DefContactID | Contact | ContactID | LEFT JOIN |
| Contact | UserID | CreatedBy | PKID | LEFT JOIN |
The Key Chain
PMProject
↓
EPEmployee.DefContactID → Contact.ContactID
↓
Contact.UserID → PX.SM.Users.PKID (@me)
Condition Tab
| Field | Operator | Value | Value Type |
| Contact.UserID | == | @me | Form Parameter |
+3Hi!
Try using the Employee.DefContactID
Revised Table Structure
Add PX.Objects.CR.Contact as a new data source with alias Contact
| Alias | Table |
| PMProject | PX.Objects.PM.PMProject |
| EPEmployee | PX.Objects.EP.EPEmployee |
| EPEmployeeContract | PX.Objects.EP.EPEmployeeContract |
| Customer | PX.Objects.AR.Customer |
| CreatedBy | PX.SM.Users |
| Contact | PX.Objects.CR.Contact (add this) |
Relations Tab Setup
| Parent Table | Parent Field | Child Table | Child Field | Join Type |
| PMProject | CustomerID | Customer | BAccountID | LEFT JOIN |
| PMProject | CreatedByID | CreatedBy | PKID | LEFT JOIN |
| EPEmployee | DefContactID | Contact | ContactID | LEFT JOIN |
| Contact | UserID | CreatedBy | PKID | LEFT JOIN |
The Key Chain
PMProject
↓
EPEmployee.DefContactID → Contact.ContactID
↓
Contact.UserID → PX.SM.Users.PKID (@me)
Condition Tab
| Field | Operator | Value | Value Type |
| Contact.UserID | == | @me | Form Parameter |
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
