• #levelName#
  • select tl.* from tbl_ter_territoryLevels tl where tl.ownerId = and tl.fsl_tablecode = and tl.parentLevelId = and tl.parentLevelId is null order by name QueryAddRow( qmd_levels ); QuerySetCell( qmd_levels, "levelId", qmd_terLevels.levelId ); QuerySetCell( qmd_levels, "levelName", qmd_terLevels.name ); QuerySetCell( qmd_levels, "depth", arguments.rank ); QuerySetCell( qmd_levels, "brokerLevel", qmd_terLevels.brokerLevel ); QuerySetCell( qmd_levels, "parentLevelId", qmd_terLevels.parentLevelId );