AND-LISTS
Chris Long
I have a question about AND-LISTS. We are currently running REALITY V14.
A coworker took two lists: list1 & list2 and used AND-LISTS to see what the union of the lists would be.
The result was 1 item.
After investigation, we found that the one item not in list2. It only occurred in list1. But it occurred twice.
Once we eliminated the repeated item id from list1, the result of AND-LISTS was zero items.
Is this how AND-LISTS is intended to function?
Chris Long
RA Services IT
Bob Wyatt
AND-LISTS
Returns a list comprising all attribute values contained in each of two or more lists, or n times altogether if specified, that is, the intersection of the lists.
Syntax
AND-LISTS list-name list-name {list-name}...{(option}
Syntax Elements
list-name is the name of a saved list.
Option
n number of times attribute value must occur for inclusion in list (default is number of items).
Comments
Uniqueness of values in a source list can be guaranteed by sorting the list with the SORT-LIST command and specifying the U option.
Examples
:AND-LISTS OVERDUE LARGEAMT
429 Items selected.
>SAVE-LIST PHONECALL
[241] 'PHONECALL' Cataloged.
All values that were in both lists OVERDUE and LARGEAMT are now in list PHONECALL.
:AND-LISTS SMKR DRNK OVFF OVWT
7899 Items selected.
>SAVE-LIST BIGRSK
[241] 'BIGRSK' Cataloged.
The list in BIGRSK contains all values that were in every list referenced in the AND-LISTS command.
Regards,
Bob Wyatt
Integration/Support Analyst
--
You received this message because you are subscribed to the Google Groups "Reality" group.
To unsubscribe from this group and stop receiving emails from it, send an email to reality-databa...@googlegroups.com.
To post to this group, send email to reality-...@googlegroups.com.
Visit this group at http://groups.google.com/group/reality-database.
For more options, visit https://groups.google.com/d/optout.
Chris Long
Bob,
Thank you. I missed the comments section.
Chris Long
RA Services IT