search results

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 t

Currently selection attributes, such as picker, poll the database in such a way that LIKEs are always placed in the WHERE clause. The data that the database returns are then filtered according to the picker configuration (exact match, contains phrase, starts with). In my company, we collect customer data from several CRM systems. For one of them, we have the customer's data materialized in the

Hi everyone, this is just a short list of actions I had to do, when I switched from a "local" text field, WFD_AttText1, to a global WFD_AttText1Glob: 1. Fixing Start Subworkflow actions Due to the change of the field type the assignment was "lost". Internally the action uses the database name, so it's obvious, that the assignment of field {690} to field WFD_AttText1 is no longer valid. Co

(...) Hi, I haven't realized before that the REST Api doesn't contain any information about the database column . I agree in most cases this is of no use and would only create unnecessary traffic. There's one use case though were one needs it. When you read the metadata information so that you can provide a configuration option in another system to start a workflow using the URL parameters: ...?com_id=1&AttText1 (...)

Hi, WFD_Att Choose columns have size nvarchar(1000). When using the 'allow multiple values' mode and having translations in the source into 3-4 languages, additionally if the ID is e.g. guid, this value is exceeded very quickly. Is it possible to increase the database size of this type of columns to nvarchar(4000)? Regards

Hi is there a way to get from the database all the permissions to all the reports that we have ? I was not able to find any column with that information and I do not know how to get such info

Hi, I've inserted a line chart to my form. It gets data from database (4 columns). 2 columns are presented on a chart as data series. Sometimes there are nulls in one of the columns. Then Webcon interpreters it as 0. Do you know any countermeasures to it? If there is a null value from the database, then it shouldn't show that line at the given point in time. I attach a photo of that such gra

Hi Folks, whenever I try to execute [Menu button] action, which should open a hyperlink, I get an error: "Error in Menu button action Start Counterparty Card. The INSERT statement conflicted with the FOREIGN KEY constraint "FK_WFElementDatails_WFD". The conflict occurred in database "BPS_Content", table "dbo.WFElements", column 'WFD_ID'. The statement has been terminated." I have exactly same

Hi, this may sound strange, but so was the reason, why I'm proposing this. My suggestion is that the expression editor for a SQL command inserts the instance id variable in a way: Currently it is inserted as: {WFD_ID} My suggestion is that it is inserted within single quotes: '{WFD_ID}' The reason for this is, that it would prevent errors which may only surface in production. This is