Applied Concepts HR/Payroll

Home Search Tags Glossary

Welcome Guest ( Login | Register )

Home » articles » HR/Payroll (emPath) » Technical » Field Level Security » Field Level Security - creating a filter using multiple fields.

Field Level Security - creating a filter using multiple fields.

Field Level Security - creating a filter using multiple fields.

Request: A client recently asked for assistance with the creation of a filter, in the emPath feature called Field Level Security. Specifically the request was to only display Timecard Entry when batch number is "12DRIV", check sequence is 1, tax code is 1, and update code is "R".

The client's request was based on a planned release of the Timecard Entry screen to remote timekeepers. The security requirement was that these remote timekeepers should only be able to view timecards as described above. There were additional edit requirements which the client was able to create without assistance.

Resolution: The filter created to satisfy this request is shown below.

select decode(#DATA(TCF_BATCH_NO)# || #DATA(TCF_CHECK_SEQ_NO)# || #DATA(TCF_TAX_CODE)# || #DATA(TCF_UPDATE_CODE)#, '12DRIV11R', 'YES', 'NO') as LISTABLE from dual

Note that the filter concatenated four fields and tested as one test. This approach forces AND logic. Timecards will only be displayed if all four fields match the requirements. Also, the filter uses a decode statement to insure the select statement would always return YES or NO.

Please register to see additional screen prints showing this filter in action. The registered user article is, Registered users - Field Level Security - creating a filter using multiple fields.

Tags:

emPath 6.4, Field Level Security, Filter, SQL, TimecardEntryDetails