Skip to Main Content

Knowledge base

Knowledge Base
Knowledge Base - How to find paragraphs in VOC that are not on a Xmenu
by Alice Moore
04/11/2012 (Software)


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]"

SAVE.LIST W04.ADV.XMENU

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.

>SAVE.LIST W04ADV.NOTONMENU

90 key(s) saved to 1 record(s).

 

GET. LIST W04ADV.NOTONMENU

SORT VOC