Lawson Query Builder - OleDB

 0 Replies
 0 Subscribed to this topic
 14 Subscribed to this forum
Sort:
Author
Messages
JonathanGS
New Member
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