The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
|
|
query builder question 
Posted: 04 Nov 09 10:04 AM
|
Hello everyone,
I tried to build a query based on the account table, one of the conditions is that the "lasthistorydate" field is null. I draged the lasthistorydate field to the condition area, and selected "does not contain data" as operator - I got an error message: "invalid date/time value". I also noted that I can't use "does not contain data" on all date/time type fields. what I missed? Can anyone help please? I use saleslogix 7.51 LAN client.
Thanks a lot as always!!!
Emily |
|
|
|
Re: query builder question
Posted: 04 Nov 09 10:58 AM
|
Seems indeed as a bug, and probably SAGE is already aware of it, but you should pass it along.
That being said, are you able to do a "CONTAINS DATA" on a Date field?
If so, you could set the Condition to "CONTAINS DATA" and then negate it. |
|
|
|
Re: query builder question
Posted: 04 Nov 09 12:17 PM
|
Thanks Rual. I guess so too. I tried the "Contains data", it does not work either. Thanks again.
Emily |
|
|
|
Re: query builder question
Posted: 04 Nov 09 12:31 PM
|
Then lets build it with a subquery:
Lets assume this group is Account based:
- Add a Condition for ACCOUNTID field.
- Set the Operator to IN
- Set the value to "(SELECT ACCOUNTID FROM ACCOUNT WHERE LASTHISTORYDATE IS NULL)"
- Check the "Use Value as Literal" Checkbox
|
|
|
|