Lawson Query Builder - OleDB

 0 Replies
 0 Subscribed to this topic
 14 Subscribed to this forum
Sort:
Author
Messages
JonathanGS
New Member Send Private Message
Posts: 2
New Member
Hi Everyone, I am trying to write a query for a SmartNote. I have done successfully what I am about to describe. I am composing a query with 2 filters. Each work separately just fine. When I combine them, neither work. Here they are: Date Hired: FILE=EMPLOYEE&FIELD=EMPLOYEE;FULL-NAME;EMAIL-ADDRESS;DATE- HIRED;POSITION.DESCRIPTION;POSITION.BARGAIN- UNIT;DEPARTMENT.NAME&SELECT=DATE-HIRED%3E%3D[date=-DS7 fmt=yyyyMMdd] Bargaining-Unit: FILE=EMPLOYEE&FIELD=EMPLOYEE;DATE-HIRED;FULL-NAME;EMAIL- ADDRESS;POSITION.DESCRIPTION;POSITION.BARGAIN- UNIT;DEPARTMENT.NAME&SELECT=POSITION.BARGAIN-UNIT%3DLEAD I feel I am missing something small. Anyone have any suggestions? I tried order of the filters, and that didn't have any effect either. Thank you, Jonathan