Data sources

Initialize Item List with SQL Query from Oracle DB

0 4

Hello all, Does anyone configured an Item List to be initialized with a SQL query that will query from another database? In this case I want to query from an Oracle DB and initialize the columns with the columns from the query: select milestone as {DCNCOL:185}, milestone_date as {DCNCOL:186}, amount as {DCNCOL:187}, currency_code as {DCNCOL:188}, amount_euro as {DCNCOL:189} from PL_Invoicing I'm trying to this but it's not working. Hope anyone has ideas for this! Thank yo (...)

Interact with Microsoft Business Central

1 1

Are there best practices how interaction with business central (formerly known as MS Dynamics NAV) can take place? What would be the preferred interface? I remember a communication with Webcon where comon data source was mentioned. Where are we here?

Start Workflow using Sharepoint Library

0 1

Hi all, I'm taking some time to explore the possibilities of Sharepoint and Webcon. I have a process set up to approve internal documents and they need to be renewed after 1 year from the previous date. I was trying to set up the beginning of the process in the Library List (and in the future use the renewal date do display the Start Workflow option for the line) and took the example of https://community.webcon.com/posts/post/starting-workflow-from-the-sharepoint-document-library/54 (...)

Add Item List for Sharepoint Calendar

0 2

Hello all, Does anyone set up an action to add items in a Sharepoint Calendar? I'm using this https://howto.webcon.com/sharepoint-calendar-adding-entries-from-bps-workflows/ to help in the configurations and I'm able to send the information to Sharepoint: Message Log for my Action Message Address of a Sharepoint list: https://visionboxdomain.sharepoint.com/sites/customers/Lists/Calendar Inserting values: Title: Renovation Doc, Location: PT, EventDate: 3/12/2021 12:00 AM, EndDate: 3/14/ (...)

SQL-Query for short Workflow History Data-Source

3 1

Hi all, i thought it might be a good idea to share useful queries that should be reusable for any of us as they are. Although I personally find the built in Workflow-History very useful and really like it for admin-purposes, it might be some kind of an detail-overkill for common users. In order to give users a more simple look of what happened so far in the workflow, I created a datasource that should work for all workflows and translations. Values are shown depending on the users browser la (...)

Problem with using WEBOCN with external SQL in Master Data Management

0 2

We are implementing a solution of Master Data Management and are trying to use Webcon as a User interface with all the logic behind forms. The database is prepared in MS SQL with different tables. The challenge we are having is to update entries with foreing keys. Scenario: Table 1: Country has one column (apart from ID) – 'Country' Table 2: City has two columns 'Country ID' (Choice column from table Country) and 'City' So in City table, we have one foreign key that shows on Country table. (...)