|Knowledge Base - How to find paragraphs in VOC that are not on a Xmenu|
|by Alice Moore|
Do you know of a way I can query my paragraphs to find only the ones that are not on the XWAB menu. All my paragraphs begin with “W04.ADV”. I currently have 121 of these paragraphs and only want to look at those that are not on the XWAB menu that may have to be re-written. Some of these paragraphs may have been run only once and do not have to be re-written.
To find paragraphs that are not on a CA menu:
NOTE: (You can change the appl.PRCS.CTL file to whichever app is applicable if you are doing other offices)
This example is specific to the CA menus:
SELECT CA.PRCS.CTL WITH @ID LIKE X... WITH PROCESS.TO.EXECUTE LIKE ‘...W04...’ SAVING EVAL "PROCESS.TO.EXECUTE[8,35]"
GET.LIST W04ADV.VOCS TO 1
121 records retrieved to list 1.
:GET.LIST W04.ADV.XMENU TO 2
31 records retrieved to list 2.
:MERGE.LIST 1 DIFF 2
90 record(s) selected.
90 key(s) saved to 1 record(s).
GET. LIST W04ADV.NOTONMENU