nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

WorkRoute Form UDA value

billychan

Dear,

1. Are WorkRoute Form UDA values stored in UdaValues Table in teamflowdb?
2. Are WorkRoute Form UDA values still stored in teamflowdb database after the workflow process is completed?

Thanks.

Find more posts tagged with

Comments

Nicholas

Dear,

1. Are WorkRoute Form UDA values stored in UdaValues Table in teamflowdb?
2. Are WorkRoute Form UDA values still stored in teamflowdb database after the workflow process is completed?
Thanks.

1. YES
2. NOT SURE, HAVE TO CHECK FIRST

billychan

Thanks

Looking forward to your reply on Q2

MailingLabels3.rptdesign

billychan

We have checked the UdaValues Table in teamflowdb. There is no data even we have many going-on workflow processes. Any idea?

wiel

I noticed the udaValues table is used since hotfix B7 of 4.1 Sp1 for values that are defined as "workListUDA". Before that I only saw that values where stored in the ProcessDataset table (but there the values are stored in a xml structure)!

Nicholas

What V you are using? this probably the case you don't have records in UdaValues table if you are below to B7.

Migrateduser

I believe Wiel is right. UDA values are stored in two places. All UDAs marked as filterable/sortable are stored in a separate table (guess the table name is UdaValues, I have to check). All other udas are stored as an XML blob field in another table (ProcessDataSet?, sorry I need to check the schema).

Also you might notice some new entries in UdaValues table after HFB7 migration as we are now automatically converting some previously non-filterable hidden UDAs (used for in house operations) into filterable set.