new

AfmHighltQuerySetAssignedFilter and AfmHighltQuerySetOwnerFilter Commands

Various query commands are typically used together to generate different types of reports. The AfmHighltQuerySetAssignedFilter and AfmHighltQuerySetOwnerFilter commands enable you to specify filters or restrictions on what to highlight in reports by whether the data is in an owner or an assigned table.

The following illustrates using these commands to create several different reports.

' Highlight Vertical Penetration by Standard. (defun c:afm_hvertxstd () (setq old_snapMode (getvar "osmode")) (if (> old_snapMode 0) (setvar "osmode" 0)) (AfmHighltQuerySetOwner "vertstd") (AfmHighltQuerySetAssigned "vert") (AfmHighltQueryByOwner) (afm_hl_tmp_draworder) (setvar "osmode" old_snapMode) (princ) ) ' Highlight Vertical Penetrations Rooms by Type. (defun c:afm_hvertxtype () (setq old_snapMode (getvar "osmode")) (if (> old_snapMode 0) (setvar "osmode" 0)) (AfmHighltQuerySetOwner "rmtype" ) (AfmHighltQuerySetAssigned "rm") (AfmHighltQuerySetOwnerFilter "rm_cat='VERT'") (AfmHighltQueryByOwner) (afm_hl_tmp_draworder) (setvar "osmode" old_snapMode) (princ) ) ' Highlight Service Areas by Standard. (defun c:afm_hservxstd () (setq old_snapMode (getvar "osmode")) (if (> old_snapMode 0) (setvar "osmode" 0)) (AfmHighltQuerySetOwner "servstd") (AfmHighltQuerySetAssigned "serv") (AfmHighltQueryByOwner) (afm_hl_tmp_draworder) (setvar "osmode" old_snapMode) (princ) ) ' Highlight Service Area Rooms by Type. (defun c:afm_hservxtype () (setq old_snapMode (getvar "osmode")) (if (> old_snapMode 0) (setvar "osmode" 0)) ( AfmHighltQuerySetOwner "rmtype") (AfmHighltQuerySetAssigned "rm") (AfmHighltQuerySetOwnerFilter "rm_cat='SERV'") ( AfmHighltQueryByOwner) (afm_hl_tmp_draworder) (setvar "osmode" old_snapMode) (princ) ) ' Highlight Groups by Department (defun c:afm_hgpxdp () (setq old_snapMode (getvar "osmode")) (if (> old_snapMode 0) (setvar "osmode" 0)) (AfmHighltQuerySetOwner "dp") (AfmHighltQuerySetAssigned "gp") (AfmHighltQueryByOwner) (afm_hl_tmp_draworder) (setvar "osmode" old_snapMode) (princ) ) ' Highlight Groups by Division (defun c:afm_hgpxdv () (setq old_snapMode (getvar "osmode")) (if (> old_snapMode 0) (setvar "osmode" 0)) (AfmHighltQuerySetOwner "dv") (AfmHighltQuerySetAssigned "gp") (AfmHighltQueryByOwner) (afm_hl_tmp_draworder) (setvar "osmode" old_snapMode) (princ) ) ' Highlight Groups by Standard (defun c:afm_hgpxstd () (setq old_snapMode (getvar "osmode")) (if (> old_snapMode 0) (setvar "osmode" 0)) (AfmHighltQuerySetOwner "gpstd") (AfmHighltQuerySetAssigned "gp") (AfmHighltQueryByOwner) (afm_hl_tmp_draworder) (setvar "osmode" old_snapMode) (princ) ) ' Highlight Rooms by Department (defun c:afm_hrmxdp () (setq old_snapMode (getvar "osmode")) (if (> old_snapMode 0) (setvar "osmode" 0)) (AfmHighltQuerySetOwner "dp") (AfmHighltQuerySetAssigned "rm") (AfmHighltQueryByOwner) (afm_hl_tmp_draworder) (setvar "osmode" old_snapMode) (princ) ) ' Highlight Rooms by Standard (defun c:afm_hrmxstd () (setq old_snapMode (getvar "osmode")) (if (> old_snapMode 0) (setvar "osmode" 0)) (AfmHighltQuerySetOwner "rmstd") (AfmHighltQuerySetAssigned "rm") (AfmHighltQueryByOwner) (afm_hl_tmp_draworder) (setvar "osmode" old_snapMode) (princ) ) ' Highlight Rooms by Category (defun c:afm_hrmxcat () (setq old_snapMode (getvar "osmode")) (if (> old_snapMode 0) (setvar "osmode" 0)) (AfmHighltQuerySetOwner "rmcat") (AfmHighltQuerySetAssigned "rm") (AfmHighltQueryByOwner) (afm_hl_tmp_draworder) (setvar "osmode" old_snapMode) (princ) ) ' Highlight Rooms by Type (defun c:afm_hrmxtyp () (setq old_snapMode (getvar "osmode")) (if (> old_snapMode 0) (setvar "osmode" 0)) (AfmHighltQuerySetOwner "rmtype") (AfmHighltQuerySetAssigned "rm") (AfmHighltQueryByOwner) (afm_hl_tmp_draworder) (setvar "osmode" old_snapMode) (princ) ) ' Highlight Suites by Lease (defun c:afm_hsuxls () (setq old_snapMode (getvar "osmode")) (if (> old_snapMode 0) (setvar "osmode" 0)) (AfmHighltQuerySetOwner "ls") (AfmHighltQuerySetAssigned "su") (AfmHighltQueryByOwner) (afm_hl_tmp_draworder) (setvar "osmode" old_snapMode) (princ) ) ' Highlight Groups by Lease (defun c:afm_hgpxls () (setq old_snapMode (getvar "osmode")) (if (> old_snapMode 0) (setvar "osmode" 0)) (AfmHighltQuerySetOwner "ls") (AfmHighltQuerySetAssigned "gp") (AfmHighltQueryByOwner) (afm_hl_tmp_draworder) (setvar "osmode" old_snapMode) (princ) )