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