cabrera01
Technical User
- Nov 24, 2008
- 15
I'm currently running a report that will show me a list of all current employees off a sql server.
In this list of employees, I use a table called HRUSERFLDS
This table holds various data fields that pertain to each employee. Among these fields is the "Prev Yrs Experience" field. This field is designated by the field HRUSERFLD.FIELD_KEY = 94 and the actual value of years is listed under HRUSSERFLD.N_FIELD.
My problem is that I need to show this particular field in my list, without excluding those that do not have this particular field and value.
Can someone help me with this.
Thank you
In this list of employees, I use a table called HRUSERFLDS
This table holds various data fields that pertain to each employee. Among these fields is the "Prev Yrs Experience" field. This field is designated by the field HRUSERFLD.FIELD_KEY = 94 and the actual value of years is listed under HRUSSERFLD.N_FIELD.
My problem is that I need to show this particular field in my list, without excluding those that do not have this particular field and value.
Can someone help me with this.
Thank you