Not applicable
2013-09-23
03:37 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
How to use filter (where not in) in QV script
this what we are using in sql scipting while generating qvd
AND THE.CallerID NOT IN (45,67,667,288)
but i wanted to apply this filter to qvd before reload.
can anyone help me.
thanks in advance.
1,345 Views
4 Replies
rbecher
MVP
2013-09-23
04:45 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
you can probably use:
AND NOT Match(THE.CallerID, 45, 67, 667, 288)
- Ralf
Astrato.io Head of R&D
yavoro
Partner - Contributor III
2013-09-24
05:03 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
rather use it like this: AND Match(THE.CallerID, 45, 67, 667, 288) = 0
Y.A.
981 Views
rbecher
MVP
2013-09-24
08:15 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Same result but hard to read..
Astrato.io Head of R&D
981 Views
yavoro
Partner - Contributor III
2013-09-24
09:53 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Maybe this is the best option then (just found it):
AND NOT EXISTS (THE.CallerID,45,67,667,288)
Never used it myself, but will do next time I need something like that.
Regards
Y.A.
981 Views