Просмотр истории изменений в редакторе

[olegash]

Как можно увидеть список последних действий в редакторе RK7?

---------- Добавлено в 15:23 ---------- Предыдущее сообщение было размещено в 14:45 ----------

Вроде нашел - отчет по истории. Только он пустой, надо куб пересчитать...

[lEEFT]

у меня в ошибку вываливается куб =( А так бы посмотрел бы действия юного падавана...

[SH]

А этот отчет разве вообще работает?

[olegash]

А этот отчет разве вообще работает?

Да вроде работает... Просто его пересчет по-умолчанию отключен.
Правда пробовал на 7.5.4
Лог, насколько я понял хранится в rk7log.udb. Возможно надо настроить его экспорт в SQL.

---------- Добавлено в 21:09 ---------- Предыдущее сообщение было размещено в 20:20 ----------

Правда работает этот отчет как-то странно. Вот только сейчас добавил модификатор в редакторе. Перезапустил сервер справочников (на всякий случай) -пересчитал куб, но изменений нет в отчете по истории. А вот позавчерашние изменения отображаются. Непонятно...

[SH]

По башоргу работают:

"XXX: Я с точностью могу воспроизвести в голове вчерашний день по минутам, а вот то, что было полчаса назад, для меня не доступно.
YYY: Завтра расскажешь."

[olegash]

А этот отчет разве вообще работает?

Отчет по истории работает. Правда кубы сразу отображают изменения, а вот отчет почему-то с опозданием на сутки. Техподдержка обещала посмотреть в чем дело.

А так бы посмотрел бы действия юного падавана...

Так, что проверяйте на последних версиях. Должны увидеть, что там у вас падаван творит...

[lEEFT]

а можешь выложить SQL запрос куба?

[olegash]

Если еще актуально то вот (извини, не заметил комментарий раньше):
SELECT
LOGBOOK.DATETIME AS "DATETIME",
CLASSINFOS00.CIUSERPLNAME AS COLLECTION,
trk7ChangeTypes00.CHANGENAME AS "CHANGENAME",
EMPLOYEES00.SIFR AS "EMPLOYEESIFR",
EMPLOYEES00.NAME AS "EMPLOYEENAME",
LOGBOOK.OBJ AS "ITEMSIFR",
vrk7RefItemsNames00.NAME AS "ITEMNAME",
STRINGPARTS00.PropName AS "PROPNAME",
STRINGPARTS00.OLDValue AS "OLDVALUE",
STRINGPARTS00.NEWValue AS "NEWVALUE",
1 AS "CHANGESCOUNT"
FROM LOGBOOK
JOIN EMPLOYEES EMPLOYEES00
ON "LOGBOOK"."USER" = "EMPLOYEES00"."SIFR"
JOIN CLASSINFOS CLASSINFOS00
ON LOGBOOK.OBJREF = CLASSINFOS00.REFNO
JOIN trk7ChangeTypes trk7ChangeTypes00
ON LOGBOOK.CHANGETYPE = trk7ChangeTypes00.CHANGETYPE
JOIN vrk7RefItemsNames vrk7RefItemsNames00
ON (LOGBOOK.OBJREF = vrk7RefItemsNames00.REFNO) AND (LOGBOOK.OBJ = vrk7RefItemsNames00.SIFR)
JOIN STRINGPARTS STRINGPARTS00
ON LOGBOOK.IDENT = STRINGPARTS00."LOGENTRY"


UNION


SELECT
LOGBOOK.DATETIME AS "DATETIME",
CLASSINFOS00.CIUSERPLNAME AS COLLECTION,
trk7ChangeTypes00.CHANGENAME AS "CHANGENAME",
EMPLOYEES00.SIFR AS "EMPLOYEESIFR",
EMPLOYEES00.NAME AS "EMPLOYEENAME",
CASE LOGBOOK.OBJREF WHEN 8 THEN LOGBOOK00.OBJ ELSE LOGBOOK.OBJ END AS "ITEMSIFR",
CASE LOGBOOK.OBJREF WHEN 8 THEN LOGBOOK00.ITEMNAME ELSE vrk7RefItemsNames00.NAME END AS "ITEMNAME",
CASE LOGBOOK.OBJREF WHEN 8 THEN 'Category:' + CLASSIFICATORGROUPS01.NAME ELSE INTEGERPARTS00.PropName END AS "PROPNAME",
CASE LOGBOOK.OBJREF WHEN 8 THEN CASE trk7ChangeTypes00.CHANGETYPE WHEN 9 THEN NULL ELSE CAST(LOGBOOK.OBJ AS VARCHAR(255)) END ELSE CAST(INTEGERPARTS00.OLDValue AS VARCHAR(255)) END AS "OLDVALUE",
CASE LOGBOOK.OBJREF WHEN 8 THEN CASE trk7ChangeTypes00.CHANGETYPE WHEN 9 THEN CAST(LOGBOOK.OBJ AS VARCHAR(255)) ELSE NULL END ELSE CAST(INTEGERPARTS00.NEWValue AS VARCHAR(255)) END AS "NEWVALUE",
1 AS "CHANGESCOUNT"
FROM LOGBOOK
JOIN EMPLOYEES EMPLOYEES00 ON "LOGBOOK"."USER" = "EMPLOYEES00"."SIFR"
JOIN CLASSINFOS CLASSINFOS00 ON LOGBOOK.OBJREF = CLASSINFOS00.REFNO
JOIN trk7ChangeTypes trk7ChangeTypes00 ON LOGBOOK.CHANGETYPE = trk7ChangeTypes00.CHANGETYPE
JOIN INTEGERPARTS INTEGERPARTS00 ON LOGBOOK.IDENT = INTEGERPARTS00."LOGENTRY"
LEFT JOIN CLASSIFICATORGROUPS CLASSIFICATORGROUPS00 ON (LOGBOOK.OBJREF = 8) AND (LOGBOOK.OBJ = CLASSIFICATORGROUPS00.SIFR * 256 + CLASSIFICATORGROUPS00.NUMINGROUP)
LEFT JOIN CLASSIFICATORGROUPS CLASSIFICATORGROUPS01 ON (LOGBOOK.OBJREF = 8) AND (CLASSIFICATORGROUPS01.SIFR = CLASSIFICATORGROUPS00.SIFR) AND (CLASSIFICATORGROUPS01.NUMINGROUP = 0)
LEFT JOIN vrk7RefItemsNames vrk7RefItemsNames00 ON (LOGBOOK.OBJREF = vrk7RefItemsNames00.REFNO) AND (LOGBOOK.OBJ = vrk7RefItemsNames00.SIFR)
LEFT JOIN
(SELECT LB.DATETIME AS DATETIME,LB.OBJREF AS OBJREF,LB.OBJ AS OBJ,RIN.NAME AS ITEMNAME,IP.OLDVALUE AS OLDVALUE,IP.NEWVALUE AS NEWVALUE
FROM LOGBOOK LB JOIN INTEGERPARTS IP ON LB.IDENT = IP.LOGENTRY
JOIN vrk7RefItemsNames RIN ON (LB.OBJREF = RIN.REFNO) AND (LB.OBJ = RIN.SIFR)
) LOGBOOK00 ON LOGBOOK.DATETIME = LOGBOOK00.DATETIME AND LOGBOOK.OBJREF = LOGBOOK00.OLDVALUE
AND LOGBOOK.OBJ = LOGBOOK00.NEWVALUE AND INTEGERPARTS00.OLDValue = LOGBOOK00.OBJREF AND INTEGERPARTS00.NEWValue = LOGBOOK00.OBJ
WHERE LOGBOOK.OBJREF = 8 OR vrk7RefItemsNames00.SIFR IS NOT NULL


UNION


SELECT
LOGBOOK.DATETIME AS "DATETIME",
CLASSINFOS00.CIUSERPLNAME AS "COLLECTION",
trk7ChangeTypes00.CHANGENAME AS "CHANGENAME",
EMPLOYEES00.SIFR AS "EMPLOYEESIFR",
EMPLOYEES00.NAME AS "EMPLOYEENAME",
vrk7RefItemsNames00.SIFR AS "ITEMSIFR",
vrk7RefItemsNames00.NAME AS "ITEMNAME",
CASE LOGBOOK.OBJREF WHEN 21 THEN 'PriceType:' + PRICETYPES00.NAME ELSE COMPPARTS00.PropName END AS "PROPNAME",
CAST(COMPPARTS00.OLDValue AS VARCHAR(255)) AS "OLDVALUE",
CAST(COMPPARTS00.NEWValue AS VARCHAR(255)) AS "NEWVALUE",
1 AS "CHANGESCOUNT"
FROM LOGBOOK
JOIN EMPLOYEES EMPLOYEES00 ON "LOGBOOK"."USER" = "EMPLOYEES00"."SIFR"
JOIN CLASSINFOS CLASSINFOS00 ON LOGBOOK.OBJREF = CLASSINFOS00.REFNO
JOIN trk7ChangeTypes trk7ChangeTypes00 ON LOGBOOK.CHANGETYPE = trk7ChangeTypes00.CHANGETYPE
JOIN COMPPARTS COMPPARTS00 ON LOGBOOK.IDENT = COMPPARTS00."LOGENTRY"
LEFT JOIN PRICES PRICES00 ON (LOGBOOK.OBJREF = 21) AND (LOGBOOK.OBJ = PRICES00.SIFR)
LEFT JOIN PRICETYPES PRICETYPES00 ON (LOGBOOK.OBJREF = 21) AND (PRICES00.PRICETYPE = PRICETYPES00.SIFR)
JOIN vrk7RefItemsNames vrk7RefItemsNames00 ON (LOGBOOK.OBJREF = vrk7RefItemsNames00.REFNO) AND (LOGBOOK.OBJ = vrk7RefItemsNames00.SIFR)
OR (LOGBOOK.OBJREF = 21) AND (PRICES00.OBJECTID = vrk7RefItemsNames00.SIFR)


UNION


SELECT
LOGBOOK.DATETIME AS "DATETIME",
CLASSINFOS00.CIUSERPLNAME AS "COLLECTION",
trk7ChangeTypes00.CHANGENAME AS "CHANGENAME",
EMPLOYEES00.SIFR AS "EMPLOYEESIFR",
EMPLOYEES00.NAME AS "EMPLOYEENAME",
LOGBOOK.OBJ AS "ITEMSIFR",
vrk7RefItemsNames00.NAME AS "ITEMNAME",
BLOBPARTS00.PropName AS "PROPNAME",
CAST( DATALENGTH(BLOBPARTS00.OLDValue) AS VARCHAR(255)) AS "OLDVALUE",
CAST( DATALENGTH(BLOBPARTS00.NEWValue) AS VARCHAR(255)) AS "NEWVALUE",
1 AS "CHANGESCOUNT"
FROM LOGBOOK
JOIN EMPLOYEES EMPLOYEES00
ON "LOGBOOK"."USER" = "EMPLOYEES00"."SIFR"
JOIN CLASSINFOS CLASSINFOS00
ON LOGBOOK.OBJREF = CLASSINFOS00.REFNO
JOIN BLOBPARTS BLOBPARTS00
ON LOGBOOK.IDENT = BLOBPARTS00."LOGENTRY"
JOIN trk7ChangeTypes trk7ChangeTypes00
ON LOGBOOK.CHANGETYPE = trk7ChangeTypes00.CHANGETYPE
JOIN vrk7RefItemsNames vrk7RefItemsNames00
ON (LOGBOOK.OBJREF = vrk7RefItemsNames00.REFNO) AND (LOGBOOK.OBJ = vrk7RefItemsNames00.SIFR)


UNION


SELECT
LOGBOOK.DATETIME AS "DATETIME",
CLASSINFOS00.CIUSERPLNAME AS "COLLECTION",
trk7ChangeTypes00.CHANGENAME AS "CHANGENAME",
EMPLOYEES00.SIFR AS "EMPLOYEESIFR",
EMPLOYEES00.NAME AS "EMPLOYEENAME",
LOGBOOK.OBJ AS "ITEMSIFR",
vrk7RefItemsNames00.NAME AS "ITEMNAME",
'Parent' AS "PROPNAME",
CAST( PARENTPARTS00.PARENT AS VARCHAR(255)) AS "OLDVALUE",
vrk7RefItemsNames01.NAME AS "NEWVALUE",
1 AS "CHANGESCOUNT"
FROM LOGBOOK
JOIN EMPLOYEES EMPLOYEES00
ON "LOGBOOK"."USER" = "EMPLOYEES00"."SIFR"
JOIN CLASSINFOS CLASSINFOS00
ON LOGBOOK.OBJREF = CLASSINFOS00.REFNO
JOIN trk7ChangeTypes trk7ChangeTypes00
ON LOGBOOK.CHANGETYPE = trk7ChangeTypes00.CHANGETYPE
JOIN vrk7RefItemsNames vrk7RefItemsNames00
ON (LOGBOOK.OBJREF = vrk7RefItemsNames00.REFNO) AND (LOGBOOK.OBJ = vrk7RefItemsNames00.SIFR)
JOIN PARENTPARTS PARENTPARTS00
ON LOGBOOK.IDENT = PARENTPARTS00."LOGENTRY"
JOIN vrk7RefItemsNames vrk7RefItemsNames01
ON (PARENTPARTS00.REFNO = vrk7RefItemsNames01.REFNO) AND (PARENTPARTS00.PARENT = vrk7RefItemsNames01.SIFR)

В отчете надо выбрать дату на 1 день больше реальной (чтобы отображался сегодняшний день).