AXForum  
Вернуться   AXForum > Microsoft Dynamics AX > DAX: Программирование
All
Забыли пароль?
Зарегистрироваться Правила Справка Пользователи Сообщения за день Поиск Все разделы прочитаны

 
 
Опции темы Поиск в этой теме Опции просмотра
Старый 26.04.2006, 13:32   #1  
leshy is offline
leshy
Участник
 
118 / 11 (1) +
Регистрация: 23.02.2004
Адрес: Киев
Временная таблица + RLS
Наткнулся на следующую ситуацию.

Есть временная таблица (создается на сервере), к ней присоединена InventDim.
Все нормально работает.
Но как только на InventDim настроил RLS (в моем случае десяток складов, разделенных запятыми) то тут же начинаются жуткие тормоза при прокручивании записей в гриде, после чего аксапта вообще вылетает с сообщением, что сервер завершил сессию.
Если строк во временной таблице немного (порядка 100) то еще кое-как работает.

Посмотрел мониторинг запросов, испугался. Вот пример запроса:

SELECT A.INVENTDIMID,A.INVENTBATCHID,A.WMSLOCATIONID,A.WMSPALLETID,A.INVENTSERIALID,A.INVENTLOCATIONID,A.CONFIGID,A.INVENTSIZEID,A.INVENTCOLORID,A.INVENTGTDID_RU,A.RECID
FROM INVENTDIM A
WHERE ((DATAAREAID=?)
AND ((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((INVENTDIMID=?)
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?))))
ORDER BY A.DATAAREAID,A.INVENTDIMID OPTION(FAST 1)
Такое ощущение, что аксапта прибавила условия RLS в несколько десятков раз вместо одного.
Старый 27.04.2006, 09:55   #2  
mit is offline
mit
Участник
Аватар для mit
 
386 / 36 (2) +++
Регистрация: 15.01.2003
Адрес: Moscow
может права как то интересно настоены?
Старый 27.04.2006, 10:10   #3  
glibs is offline
glibs
Member
Сотрудники компании It Box
Most Valuable Professional
Лучший по профессии 2011
Лучший по профессии 2009
 
4,942 / 911 (40) +++++++
Регистрация: 10.06.2002
Адрес: I am from Kyiv, Ukraine. Now I am in Moscow. For private contacts: glibs@hotmail.com
Мы как-то наблюдали подобную проблему. Не уверен, была ли там временная таблица, но эффект был очень похожий. Решать не стали. Скорее всего — это бага.
__________________
С уважением,
glibs®
Старый 27.04.2006, 11:19   #4  
leshy is offline
leshy
Участник
 
118 / 11 (1) +
Регистрация: 23.02.2004
Адрес: Киев
В настройках прав ничего особенного: есть группа пользователей для которой настроен RLS на InventDim, через запятую указан список складов (это видно и по запросу).
Если сделать таблицу постоянной - тогда все нормально.

А можно как нибудь для формы отключить RLS (он учитываетя при создании временной таблицы)? Пробовал в Init формы указывать inventDim.recordLevelSecurity(false) - результат тот же.
Старый 27.04.2006, 11:40   #5  
mit is offline
mit
Участник
Аватар для mit
 
386 / 36 (2) +++
Регистрация: 15.01.2003
Адрес: Moscow
мне казалось что эти запросы формируются на уровне ядра
Старый 27.04.2006, 12:33   #6  
leshy is offline
leshy
Участник
 
118 / 11 (1) +
Регистрация: 23.02.2004
Адрес: Киев
Вобщем да, но в руководстве разработчика сказано что этим процессом можно управлять:
You may want to code other methods on reports or forms, and still have the rules of RLS applied. Or, within the RLS-scoped methods listed in the previous section, you might want the scoped RLS to be disabled on selected queries. To have this functionality, a method on a table buffer is available, recordLevelSecurity, to overrule default behavior.

Within scoped RLS, you simply "sign-up" for RLS coverage using:


SalesLine.recordLevelSecurity(true);



And in RLS covered X++ code, you may “sign-up” for an exemption from the rule by using:


SalesLine.recordLevelSecurity(false);
Старый 27.04.2006, 12:39   #7  
mit is offline
mit
Участник
Аватар для mit
 
386 / 36 (2) +++
Регистрация: 15.01.2003
Адрес: Moscow
да, есть такая штука, но сам на практике не проверял
 

Похожие темы
Тема Автор Раздел Ответов Посл. сообщение
Отчет и временная таблица asd1274 DAX: Программирование 2 16.12.2008 09:04
Временная таблица Antoncheg DAX: Программирование 21 15.08.2008 18:25
производительность: map или временная таблица kitty DAX: Программирование 5 15.11.2007 12:36
select sum(amount) from временная таблица ATimTim DAX: Программирование 6 11.06.2004 14:16
next и временная таблица Dron AKA andy DAX: Программирование 3 24.04.2003 16:42
Опции темы Поиск в этой теме
Поиск в этой теме:

Расширенный поиск
Опции просмотра

Ваши права в разделе
Вы не можете создавать новые темы
Вы не можете отвечать в темах
Вы не можете прикреплять вложения
Вы не можете редактировать свои сообщения

BB коды Вкл.
Смайлы Вкл.
[IMG] код Вкл.
HTML код Выкл.
Быстрый переход

Рейтинг@Mail.ru
Часовой пояс GMT +3, время: 20:00.
Powered by vBulletin® v3.8.5. Перевод: zCarot
Контактная информация, Реклама.