STARTING SQL SUBWORKFLOW USING ITEM LIST FOR DIFFERENT COMPANY'S

0

Hi, Mateusz.
You choose any, and in the sql query add:
, DET_att5 as COM_ID

Within your select, you can rename DET_Att5 to COM_ID, as written in context help (see screenshot).

It should override whatever you have typed in Default configuration tab.

@Edit
Seems like Karol was faster, and i havent refreshed my browser :)

I do this:

SELECT DET_ID as WFD_AttText19,

DET_Att4 as COM_ID /* here also this DBO.ClearWFElemID(DET_Att4) as COM_ID but also error that said that that functions is not avaible

FROM WFElementDetails

WHERE DET_WFDID=1515422 AND DET_WFCONID=2398 AND DET_Att3=1


but I have an error

Wystąpił błąd wykonania akcji Uruchom podobieg (SQL) na ścieżce. (Krok: Ręczna weryfikacja załączników, ścieżka: Wiele faktur)
Błąd konfiguracji: Nieprawidłowy format kolumny COM_ID

I do this:

SELECT DET_ID as WFD_AttText19,

DET_Att4 as COM_ID /* here also this DBO.ClearWFElemID(DET_Att4) as COM_ID but also error that said that that functions is not avaible

FROM WFElementDetails

WHERE DET_WFDID=1515422 AND DET_WFCONID=2398 AND DET_Att3=1


but I have an error

Wystąpił błąd wykonania akcji Uruchom podobieg (SQL) na ścieżce. (Krok: Ręczna weryfikacja załączników, ścieżka: Wiele faktur)
Błąd konfiguracji: Nieprawidłowy format kolumny COM_ID

Mateusz,
can you build a sql query in the context of the item for which you are getting an error and show what data is returned to COM_ID?

If you chose set dynamically , enter there e.g. 0 (cannot be empty.)

I assume that you have companies created in the configuration with such ids for which you want to register documents?

Query:

SELECT [COM_ID]
,[COM_Code]
,[COM_Description]
FROM [BPS_Content].[dbo].[Companies]

I meant the result of the query that starts your elements. what is the data
for this erroneous element for column DBO.ClearWFElemID(DET_Att4) as COM_ID

Now it's working meaby I don't refresh something in document. Thank you for support :)

It'll propably be a detail, but cast it to INT, as ClearWFElemID returns NVARCHAR.

now is everything working fine :) Thank you for help