Data sources
Hi. Is there a way to query the Active Directory only for the department column and add this as a datasource. What I'm seaking is a list of all departments we have in the company. Kind regards Klaus
Hi there, ever since OAuth2 connection was implemented I was happy and thought it would make connecting to Dynamics BC (Saas / Cloud Version) a breeze. However, so far, it was / is not. setting up the OAuth2 app authentication in Azure and webcon is pretty straightforward. - it works like a charm in Postman ( I get my bearer token back) but I have no real way to test it in webcon, so I have to assume it´s working. then you still have to set up the REST Web Service connection, then the (...)
Hi. I have a big SQL from 3-4 apps. Is the possibility to generate report from my SQL data source ?
Hi community! In some scenarios it is necessary for us to render datatables on form containing some custom links or buttons. For this reason we built following SQL statement for testing purposes: SELECT 'Internal' AS ID, '<input type="checkbox">Click me</input>' AS HTML UNION SELECT 'Azure' AS ID, '<a href="https://somedomain.com" onclick="alert(''hello'')">Link</a>' AS HTML And we used this datasource in a datatable field on form. However, we have some interesting results. (...)
Hi, I have some problem with privilages. I have the choice field which is sourcing by BPS Internal view. One of user don't see the data in this field (she see field but data source is empty for her). I checked already if there is some space sign or any other which limited the search result. She has privilages to application, form, on choice field there is no limit. I've seen everything because I have an admin privilages but even if I revoke permission (to replicate the problem) I stil (...)
Hi, I have a following problem. I've created a data table form field that downloads data from SQL query. In that SQL query I have a following where clause, which compares a date from Oracle table to a date from a form field that is completed by an user (it is "user's date"): "where table1.date = User's date: date acc. browser settings(text)" and it doesn't work because of different date formats. I've tried multiple methods and nothing worked. Do you know any solution? However, the fo (...)
Is it possible to sort by the selected column (additional column, e.g. priority) in the dictionary selection field? Or to arrange your own order?
Hi, I add new connection (MSSQL database) - test it with success. Next I add new data source with some SQL query which returns some data when I test it. If I save that connection Webcon shows the error: "Failed to retrive column from data source XXX. No connection settings." If I want to test that data source in choice form field I've returned: Nieznany błąd: The ConnectionString property has not been initialized.. Does anyone have some idea what I should do to fix it? Than you (...)
Hi there, does anybody know why this error occurs? Happens the following way: - Business rule retrieves datasource column (from [CacheOrganizationStructure]) COS_AD_name by means of a form field value (see 1.png) - Rule works fine if clicked on 'Test' button - This business rule is used in the cyclical action 'Update related workflow instance' with the goal to update a workflow's form values on an interval (thus using 'Change value of single field is not available as an action) - In (...)
Hello, I tried to import some templates from DEV environment to TEST environment and when I uploaded the .zip archive the following error occured on the .xlsx report: "Value cannot be null. Parameter name: securityProvider" Does anyone know why do we get this error? Thanks!
Hi everyone, Does anyone has an idea on how to retrieve all "objectClass=contact" from Active Directory and use the result as a Data Source? Thank you.
Hello. Is there a way to use a stored procedure as datasource instead of a view or table or Select statement? I use at the moment a query on two tables (UNION) which has an inner join on another table. The speed is not really breathtaking, thus I wanted to use a stored procedure where I can perform all the timetaking steps already on the SQL server. Regards Klaus
Hello Community, Does anyone established the connection between Sales Force and Webcon? I have all the documentation on the Webcon side for the REST API but I'm finding some difficulties on the Sales Force side as I'm not sure on where and how to configure the necessary steps to get the connection between the 2 systems. Thank you all for the attention!
Hi community! We implemented a document template with certain fields coming from a custom datarow (based on SQL-Query). We deployed the solution and the document template to PROD and everything was fine. After that we added one new field to the datarow (SQL query was modified) as a new requirement and added the new field also to document template. On DEV system everything looks fine, we deployed the solution to PROD and suddenly this new field is missing in Word Add-In (in the selection of d (...)
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 (...)
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?
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 (...)
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/ (...)
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 (...)
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. (...)
+48 12 443 13 90