Is it possible to insert into wanted dictionary related item via sql query or else ?
Is it possible to insert into wanted dictionary related item via sql query or else ?
Hi Arthuzad,
the question is very vague, but i'll give few shots to answer:
1. Inserting / Updating on database provided by WEBCON breaks EULA point 3.6 / 1.23 (https://webcon.com/wp-content/uploads/2025/05/WEBCON_EULA_EN_2025.pdf).
2. If you need to import some data into a dictionary, then the easiest option would be Import/Export by Excel
* https://docs.webcon.com/docs/2025R2/Studio/Studio_ToolBar_Import/
3. If there is a lot of records required >500, then it might be better to do it via Cyclic Action, or REST Api, I've written a series which describes both ways: https://blog.lumenn.pl/importing-data-to-webcon-1/
Hi Arthuzad,
the question is very vague, but i'll give few shots to answer:
1. Inserting / Updating on database provided by WEBCON breaks EULA point 3.6 / 1.23 (https://webcon.com/wp-content/uploads/2025/05/WEBCON_EULA_EN_2025.pdf).
2. If you need to import some data into a dictionary, then the easiest option would be Import/Export by Excel
* https://docs.webcon.com/docs/2025R2/Studio/Studio_ToolBar_Import/
3. If there is a lot of records required >500, then it might be better to do it via Cyclic Action, or REST Api, I've written a series which describes both ways: https://blog.lumenn.pl/importing-data-to-webcon-1/
there needs only one item to be inserted, and the data should come from the mentioned item list. as i said i have created a query with "insert into" but i don't know how guid wll be generated and how to access wanted dictionary
there needs only one item to be inserted, and the data should come from the mentioned item list. as i said i have created a query with "insert into" but i don't know how guid wll be generated and how to access wanted dictionary
I'm assuming there are 2 processes then:
1. Dictionary
2. Process which on some form has an item list.
If you want to add something to the dictionary - by "insert" i'm assuming it's a new document, then you could try to use start a subworkflow action:
* https://docs.webcon.com/docs/2025R2/Studio/Action/Workflow/StartWorkFlow/
for updating an item in a dictionary you could try to use update related workflow instance:
* https://docs.webcon.com/docs/2025R2/Studio/Action/Workflow/UpdateParentWorkflow/