O
O
one__for__one2018-10-20 16:59:01
Document flow
one__for__one, 2018-10-20 16:59:01

How to programmatically get a list of tasks from a document in 1C 8.3 workflow?

Hello.
Installed 1s workflow 8.3. No changes were made to the configuration. All business processes are configured through the user interface.
5bcb349f0199b059581092.jpeg
Please tell me how to programmatically get a list of tasks that a document has.
I find the document using the query:

выбрать * из Справочник.ВнутренниеДокументы КАК док где док.РегистрационныйНомер = &ном

But there are no tasks.
Found some problems here
ВЫБРАТЬ первые 100 *
ИЗ БизнесПроцесс.Исполнение КАК Исполнение 
Упорядочить по  Дата Убыв

But I don't know how to connect.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
K
Konstantin, 2018-10-22
@fosihas

Nu...
You need to find which BP was created, then the list of Tasks that it initiated.
For example, open the Internal Document card, it displays BP and Tasks.
SELECT
Contractor Task.BusinessProcess,
Contractor Task.Reference
FROM
Task.Executor Task AS Task Contractor

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question