Questions & Conversations

Hi, I have a table ‘contract’. I have a table ‘charges’. I’ve created a connecting table ‘contract_charges’I want to enable Drag&Drop so that the user can easily select (multiple) charges, drop them into the connecting table, and there see an overview of all connected charges for that contract. I’ve created views based on the tables. I open ‘contract’, and show both ‘charges’ and the connecting table as detail. The view for ‘Charges’ is a select * from charges cross join contract. When I drag to from ‘charges’ to table ‘contract’, the task works ok. The row shows in ‘contract_charges’ - however, I think it is counter-intuitive to drag to ‘contract’. I want to drop them into the connecting table. When I try to do this, SF automatically sets both parameters to ‘Check for equality’. This is due to the fact that the parameters exist in both tables(?). If I remove contract_id from the view, it won’t show as a detail (; therefore the cross-join). Can I create a workflow where you can dro

I keep getting asked to login..  and I am 100% sure the credentials are correct.  

Hi. Is there more elaborate documentation available on the Maps component for the Universal GUI? I've read the docs and some postings here, but can't figure it out how I should set it up. And is there also a listing of supported Maps providers? Before I used MapQuest, does this still work? 

Is there a way to load all records in a Cube screen type using Web interface?I do not want to switch every page, i’d prefer to scroll down all records as in windows Gui. Is there a screen component I could use?  

Edited by moderator - Translated to English:We are currently investigating what Application Insights can do for us. We also run into the fact that there is something like a 'snapshot debugger'.As far as we currently understand it, the Snapshot debugger makes it possible to trace all events before and after the occurrence of an error. We believe this could be of great help in analyzing problems.Is the snapshot debugger from Indicium-Universal supported?The documentation I found on this from Microsoft is:https://docs.microsoft.com/nl-nl/azure/azure-monitor/app/snapshot-debugger https://docs.microsoft.com/nl-nl/azure/azure-monitor/app/snapshot-debugger-vm?toc=/azure/azure-monitor/toc.jsonWij zijn momenteel aan het onderzoeken wat Application Insights voor ons kan betekenen. Daarbij lopen we er tegen aan dat er iets bestaat als ‘snapshot debugger’.Voor zover wij het momenteel begrijpen wordt het mbv de snapshot debugger mogelijk om alle events voor en na het optreden van een fout te tracer

Database field (VARBINARY) with SVG image, how to show in Universal

Has anyone dealt with printing labels on a Zebra Printer. With 2 of my clients I have the same issue that I cannot use the full width of the label.The label is automatically scaled to about 70% of it’s label size.And whatever setting I do, I just does not use the full width of the label.I have created reports in as well Dev Express as SSRS and both have the same problem. With DevExpress If I print my label on a HP Laserjet on A4, the label size is correct. If I print it to the Zebra printer the label is scaled to about 70%.I have contacted Zebra and they told me that the paper size of the label is not correct, but I setup the paper size of the label correctly in Dev Express and in the printer driver itself (I’m getting a bit nuts of this)The label size is 105 x 83. I already tried to change every single parameter step by step, but the label is still scaled to about 70%. The last attempt was a bit bigger but still 3-4 centimers of the label is not used. Preview in DevExpressPage setup i

Hi. I created a detail (view) and for some reason when I open it the first row stays blank and the rest gets selected..  which I cannot undo.  When I change the sort order it starts showing the first row. In the debug screen I find it odd that with every click on a record in this detail.. a layout() is called..   

The database of our SF is starting to become a little too big for our liking, and this may result in slower upgrades whenever Thinkwise releases a new version. When we first started using Thinkwise software, we were told it was not necessary to delete any old versions, as one could lose some history in for instance the template code history. I was wondering whether there are any updated best practices or recommendations from Thinkwise on how old project versions and branches can managed.

This is the first time I’ve tried a subflow. I made sure the flow parameters are fed with the values from the main process flow. However it doesn’t run.When I check debug info in the gui it says: “ExecuteSubFlow is not supported in the Windows or Web gui”Does this mean subflows don’t work at all? We’re on the latest 2022.1 version.

Hi, Lately I have been trying to group some fields in my form component to another tab. This is very easy to do in web/desktop gui (img.1). img. 1But now I’m trying to achieve the same thing in Universal but just can’t seem to figure it out. My form component in Universal is as seen on img. 2img. 2 Keep in mind I would like do achieve this without adding another table. Is there a way I can do this for Universal GUI? Thanks.

Hello, I want to create a new row in my table with certain columns from another row. It is possible?

Anyone has experience with how to set up the flow, especially how do I catch the generated PDF from de start_table_report to be able to send it by email?  Where does it, by default, get saved? 

I am using the HTTP-connector to sent a message with content-type application/json. I use a nvarchar(max) variable for the content input. I would like to know whether the http-connector sends the message UTF-8 encoded or UTF-16 encoded.I would like to use a Content-Type application/json; charset=utf-8 but I suspect I have to encode the content as UTF-8. Is this best done using a varbinary(max) or should I do this in a different way? Hope anyone can help.

When executing a JSON request (by Postman), I get an 422 - Unprocessable Entity Error. In the Indicium log, the following error message can be traced. What does this error mean? [DBG] Endpoint '"{metaSourceAliasOrID:length(2,3):regex(^iam$|^api$|^sf$)}/{guiApplAliasOrID}/{**odataRoute}"' with route pattern '"{metaSourceAliasOrID:length(2,3):regex(^iam$|^api$|^sf$)}/{guiApplAliasOrID}/{**odataRoute}"' is valid for the request path '"/iam/test/customer"' (430aaaf2)[DBG] Endpoint '"{protocolSegment:length(4,5):regex(^odata$|^open$)}/{metaSourceAliasOrID:length(2,3):regex(^iam$|^api$|^sf$)}/{guiApplAliasOrID}/{**odataRoute}"' with route pattern '"{protocolSegment:length(4,5):regex(^odata$|^open$)}/{metaSourceAliasOrID:length(2,3):regex(^iam$|^api$|^sf$)}/{guiApplAliasOrID}/{**odataRoute}"' was rejected by constraint '"protocolSegment"':'"Microsoft.AspNetCore.Routing.Constraints.LengthRouteConstraint"' with value '"iam"' for the request path '"/iam/test/customer"' (5b506098)[DBG] Endpoint '

Dear Thinkwise,Because the Universal-GUI uses the cache of the browser it is not allowed to have more than 1 webapplication of the universal-gui in 1 sub domain.But I’m having now:http://ericwebsite.acto.nl/acto-d-upgradetest-evo-indicium-universalhttp://ericwebsite.acto.nl/acto-d-upgradetest-evo-indiciumhttp://ericwebsite.acto.nl/acto-d-upgradetest-evo-universal-guiSo I want to change our IIS structure to support this. What I want to do is creating the next structure:http://ericwebsite.acto.nl/acto-d-upgradetest-evo-indicium-universalhttp://ericwebsite.acto.nl/acto-d-upgradetest-evo-indiciumhttp://acto-d-upgradetest-evo-universal-gui.acto.nlThis structure needs to use the ‘CORS’ possibilities of IIS/ThinkwiseMy questions is: do you support these new structure? And if so: how do I enable the CORS in this structure? I have read about CORS and indicium and found the next instructions and I tried them on the appsettings.json of indicium-universal, but these doesn’t seem to work.{  "Allowe

Hello all,Does anyone have an example of an t-sql request against a REST API with a Multidata/Form? We already call several REST APIs, but not with Multidata/form. Below is a setup (which does not work). The API converts a PDF document into fields in json format. It contains 2 fields that must be included:name (name of the document) document (base64 encoded string)Below is a first attempt, but it does not work :-). Thanks in advance for the reactions.declare @response table (txt nvarchar(max)); declare @object int , @url_endpoint nvarchar(200) , @response_format nvarchar(5) , @request nvarchar(250) , @json nvarchar(max) , @address address , @body varchar(max) , @status int , @d

We are looking to upgrade our TW software to version 2022.1, and during my tests I encountered some performance issues while synchronizing our latest version. Our performance monitor pointed towards the function look_up_chain_granted. This function is called around 1.5 million times, as our application contains a high amount of Roles. At 1.25ms per execution this could take a very long time. The performance index suggested adding the index stated below and this decreased the avg execition time to 0.075ms, which helped with decreasing the total sync time from almost one hour to just ten minutes.I would suggest Thinkwise take a look at this suggestion as it has helped us very much.CREATE NONCLUSTERED INDEX [<Name of Missing Index, sysname, >] ON [dev_sf_upgrade_test_2022].[dbo].[ref_col] ([project_id],[project_vrs_id],[target_col_id]) INCLUDE ([abs_order_no]) 

The project I am working on needs to fill a form (which is developed in SF) by the candidates. This form will be sent as the link to the candidate in an email. When the candidate clicks this link it should take the candidate to the form. My question is :If the candidate does not have the log in details for SF , can he still open and save his data through the form?  Can the universal GUI url open without user id and password?

Hi. I am trying some cubes and charts. Why do only column values get shown the elements, as when they are added as a row they get their DB values. Socio Type (Combo with Elements), as a column and states as rows I see the named elements.  Socio Type (Combo with Elements), as a row I see the DB values instead of elements.  

I am trying to use the OAuth connector to make a synchronization with the tax service platform of the British Government.I have followed the docs and set everything up accordingly. However when the proces action of the OAuth login connector is reached, a white screen comes up and nothing is happening. I assume thinkwise is adding the client_id, scope and redirect_uri to the Authorization URL? I was hoping to find more information in the debug screen to find out what URL’s etc are being called, but that is not the case. Can someone tell me what I am doing wrong here? I below screenshots you can see my settings.   Settings in OAuth servers      White screen. Nothing happening.    My proces flow 

What could be the reason a query is taking way more time through the GUI than direct on SMSS? If I copy this query into SMSS and execute it, it's done instantly. While via the GUI it takes quite some milliseconds. 

What can be the reason that the initial connection takes seconds…  I have another query that runs 5 ms direct on DB..  and this time I see that it stays for seconds in initial connection.   and after 6.7 minutes it's done.. 

The license is not automatically renewed.The registration has been successful.Starting the IIS application manually also works fine; when i start it as administrator as well when i start it as de pool-user.Automatically it does not work.I'm working with the installation 2021.1I have checked the problemsolving: idle-time is set to 0 and startmodus is AlwaysRunning. The authorization on the wwwroot-map is set correctly.So beats me. What can i do? Who has any ideas?

I have a table with over 48 million records and I would like, besides some default pre-filters, to have the filter form pre-filled with an option and let the user alter these selections ( they are combo's). On of them is company type, can I give these fields by default a value and make sure that they cannot be empty?