Skip to main content

Questions & Conversations

Ask a question or have a conversation about the Thinkwise Platform

  • 3,027 Topics
  • 10,453 Replies
3027 Topics
Freddy
FreddyThinkwise Local Partner Brasil
asked in Questions & Conversations
Calculated column doesn't use domain values

Hi. I've created a calculated column in SF and used the domain NUMERIC(16,8) ..  however apparently doesn't look to there.. it makes it NUMERIC(38,7).. however this calculation has 8 behind the decimal. How do I make it at least a precision 8?  

534
Freddy
Freddy
FreddyThinkwise Local Partner Brasil
asked in Questions & Conversations
Default value via expression

Hi. Today one of my trainees added in the model the default value via expression and he added the getdate() function as mentioned in the documentation: https://docs.thinkwisesoftware.com/docs/sf/data_model#default-valueBut although it says SQL server is the only one to support it, it create a very strange insert statement at upgrade time, which is not accepted by SQL server. select t1."DataCadastro"(getdate()) as "DataCadastro" from __Processos__ t1It looks like something was not generated correctly in the SF. 

1955
Freddy
U
Warrior
UshaWarrior
asked in Questions & Conversations
Getting error message while using Universal GUI(2021.3.12.0)

When i tried to open my application in Universal GUI, the application opens but no data is getting displayed from DB and  it is showing  error messages as ” Reset dataset failed. Error: An unknown error occurred, please contact your administrator.” and “ [unknown_error]” .It is not updated with latest data model change too. Has someone faced this before? What could be the issue? 

1526
U
Warrior
Remco Duijsens
Vanguard
Remco DuijsensVanguard
asked in Questions & Conversations
API authentication SQL

Hi Community, While implementing different API's we noticed that it could be difficult to write the authentication headers. Examples of these headers are often written in C# or JavaScript and not in SQL.  Is there a way to write these authentication headers in other languages than SQL?  Thanks!  

841
E
Moderator
Freddy
FreddyThinkwise Local Partner Brasil
asked in Questions & Conversations
Universal > Detail > Setting 'Start with Empty Filter'

I think the Universal handles the setting 'Start with Empty Filter' incorrect. It should not clear the context of a detail when it's opened via a detail tile. 

532
Freddy
Rucha Naik
Rucha NaikPartner
asked in Questions & Conversations
What is the limit to create the number of users in IAM?

For my project, we need to use SF as a form, to be filled by candidates who get selected in the recruitment process. The initial data for each candidate comes from a third party (ZOHO recruit) database. As per the requirement an email will be sent to the candidate with a link (universal url), after clicking on this link the form should open. As per my discussion previously with the Thinkwise solution experts, credentials are necessary in order to logging into SF. The workaround for that we are using is creating users for each candidate using their email-id as the user-id. My concern is that, for example : there are 20 candidates per day filling the form, then in a month there will be around : 600 and in a year : approx. 7200. Will this cause any issues in the system performance in the long run? Is there any other solution for this issue?

684
Rucha Naik
A
Hero
Alban_THero
asked in Questions & Conversations
Failed to re-generate code group

Hi,I made a small change to a PROCEDURE template and when I tried to generate the code group on the Functionality > Assigning > gear icon I get the following error: The control procedure it points to seems to be autogenerated?Any pointers on what is going wrong here?

715
A
Hero
M
Captain
Marc FerketCaptain
asked in Questions & Conversations
Show date-time with mask or something like that

Does anyone know if it is possible to use a date-time mask in SF?We have set the default date-time representation in our application using the extended property CustomDateTimeMask.For 1 specific screen we only want to display the month and day + time, so e.g. 22-12 13:24 instead of 22-12-2022 13:24.Is this possible with the help of a mask or something like that, or do we have to convert to a text field (ouch)

1056
M
Captain
Rucha Naik
Rucha NaikPartner
asked in Questions & Conversations
What is the format to write the Body in HTTP connector for API?

I want to create users in IAM using API. In order to POST the details , I am using below JSON query as the Body. Its working via Postman, but not through SF. I think the format to write JSON query is not correct. Has someone tried it. Please let me know the correct format to use JSON query in Body of an API.Postman DetailsSF input 

1769
Rucha Naik
S
Rookie
S KoningRookie
asked in Questions & Conversations
Open a URL with a task

Good day,I’m trying to open a URL with a task (Windows GUI) but I can’t get it to work.Per the docs, I created a ‘Windows command’ task and gave the Object name the value ‘http:’. I created a task parameter ‘url’.To open a dynamic URL without knowing the default browser, you can trick the task by using 'http:' as Object name and set the first parameter to the URL to be opened. The same goes for other URI schemes like 'mailto:'. The default browser opens up, but it doesn’t go to the URL. I even tried ‘http:[url]’ but I can’t get it to work. However, if I ‘hard code’ a link in the Object name, it does open up.What am I missing?

991
S
Rookie
E
Sidekick
efitskieSidekick
asked in Questions & Conversations
How to automate login to universal to download deployment scripts

We have deployed the Software Factory to Azure. With the new 2022.1 release we are unable to save the deployment .sql scripts. As workaround (or improvement) we can download the files from indicium (/iam/sf/code_file?$filter=project_id eq '<project>' and project_vrs_id eq '<project_version>' and code_file_generated_code ne null&$select=code_file_id, code_file_generated_code)I would like to automate the download process, but struggle to get the login token from indicium.How do i programmatically authenticate to indicium to download the deployment scripts? 

1236
E
Sidekick
J. de Lange
Hero
J. de LangeHero
asked in Questions & Conversations
Change detection @col parameter not filled.

Hi,I’m struggling with the change detection. It seems that our @col_id parameter doesn’t get filled (always null). In the docs it says that the column will only have a value when the logic is called if the table to which the column belongs, is shown as a detail. In our case we display the grid of a table and we have the form of this object under a detail tab. Context, layout and default procedures have no problem reading our @col_id but in the change detection, the value is always null.I thought the primary key columns of an object would be available and filled when a detail tab is opened or a row is selected. Is this not the case? Is there a way around this? I would rather not refresh all objects whenever one object gets changed. 

1625
Anne Buit
Community Manager
Freddy
FreddyThinkwise Local Partner Brasil
asked in Questions & Conversations
How to recursively call HTTP connector?

For our demo App we are utilizing API's that have to be called per row. So we have 28 states and to get my data I want to have a solution that checks which data is missing and then automatically fetches this data per state in this case. Same goes for a company with multiple locations… how do i get my App to automatically get all the coordinates for these locations? Basically a cursor for the HTTP connector. I've tried another solution in the community to go to the first row and then cycle to the last.. but it didn't work because the key values are not passed on and secondly it's a GUI action so the user has to wait until the GUI visually went through all the locations. Any suggestions on how I can subsequently invoke a http connector based on a query result?

835
Freddy
Freddy
FreddyThinkwise Local Partner Brasil
asked in Questions & Conversations
Max number of geo locations with Maps component?

HI. I have a company with 49 active locations…  but I cannot seem to show them all on the map. Is there a limit somewhere defined?  And how do I overrule it?   

513
Freddy
Blommetje
BlommetjePartner
posted in Questions & Conversations
Drag & Drop destination table

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

854
Mark Jongeling
Administrator
Freddy
FreddyThinkwise Local Partner Brasil
asked in Questions & Conversations
Thinkstore problems?

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

945
Mark Jongeling
Administrator
Freddy
FreddyThinkwise Local Partner Brasil
asked in Questions & Conversations
Universal GUI - Maps

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? 

22510
Freddy
M
MatteoSangiorgiPartner
asked in Questions & Conversations
Cube screen type on Web: load all records

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?  

411
Anne Buit
Community Manager
E
Sidekick
ericbosmanSidekick
asked in Questions & Conversations
Application Insights - ‘snapshot debugger’.

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

882
E
Sidekick
Freddy
FreddyThinkwise Local Partner Brasil
asked in Questions & Conversations
Database field with SVG image, how to show in Universal

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

772
Freddy
E
Sidekick
Edwin SaanSidekick
asked in Questions & Conversations
Printing labels on Zebra printer

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

4092
E
Sidekick
Freddy
FreddyThinkwise Local Partner Brasil
asked in Questions & Conversations
Universal GUI: Everything in detail tab gets selected and first row not visible

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..   

272
Freddy
T
Apprentice
Thomas OfmanApprentice
asked in Questions & Conversations
Best practices on managing old project versions in the SF

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.

462
T
Apprentice
R
Hero
RolandHero
asked in Questions & Conversations
Subflow not working - not supported?

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.

901
Mark Jongeling
Administrator
K
Vanguard
kensonlatchmansingVanguard
asked in Questions & Conversations
Tab page in Universal

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.

991
Mark Jongeling
Administrator

Badges

Show all badges
Terms & ConditionsCookie settings