Product updates
Ideas
Groups
E-learning
Documentation
Events

Community
Search

Topics started by Freddy

153 Topics

Most views

Recently active Most replies

FreddyThinkwise Local Partner Brasil

asked in Questions & Conversations

Microsoft Graph - Invalid Audience / Missing Scope

Hi. I have been fiddling around with getting a token for the Microsoft Graph API. I want to read an email box from a fixed user and use it in an application. So I went to the AD portal, registered the App et cetera. When I use the v2 oauth URI's then I get an error : "invalid_requestAADSTS90014: The required field 'scope' is missing from the credential. Ensure that you have all the necessary parameters for the login request. When I use the v1 oath URI's then I get a token, but whenever I try to request a resource I always get the message: "message": "Access token validation failure. Invalid audience." I really don't understand what is the solution. How should I set this up?

FreddyThinkwise Local Partner Brasil

asked in Questions & Conversations

Executing API 'CreateFile' failed with error number 32.

Does anybody know a good way to catch and prevent the error, when a file for some reason is locked for reading and processing? Executing API 'CreateFile' failed with error number 32. Error code 32 is ERROR_SHARING_VIOLATION . So the mailer cannot read the attachment file because something else is reading it. Besides the fact that you cannot really reproduce it until it happens, I cannot really find a way to catch this error upfront. I am using the file_exists function to check upfront if all documents exists, and even though all attachments can be found, at the time of sending the mail at occasions you get this error. The only solution I can think of now is to set the AccountRetryAttempts to 2 times to tackle this problem. But it's not the fanciest solution, anyone has experiences with this?

FreddyThinkwise Local Partner Brasil

Model actionbar elementsPartially completed

Especially with the introduction of the actionbar component, where you can freely position the actionbar it has become more a necessity to model the action groups of the actionbar. I see the taskbar has the following main groups:Filter Pre-filter Tasks Reports CRUD actions (incl. import/export) RefreshIt's not uncommon that you have a grid, form and for example a preview/cube/ or other element not being a reference.. If you put them all on a separate tab all the component gets all the action bar items. Functionally and personally this is unwanted. the filter, pre-filter and mass update for example do not make sense on a form level (exceptions are there of course) because you are looking at a single entity. In the U-GUI we use the previewer to load external apps.. Basically you don't want to have search, filter, CRUD actions there (again exceptions are possible)It would be really great if the option to hide action bar could be extended by modelling at screentype level which action-bar

FreddyThinkwise Local Partner Brasil

Universal Action Bar should always be contained within the defined containerCompleted

We have been playing around with the Universal GUI and we find it more and more limiting that the action bar doesn't play by the rules of the screen containers. The action bar always covers the whole width of the screen and if you want a list on the left and details on the right it becomes very confusing for the user, because you end up with 2 actions bars one under the other. It shouldn't be to hard to make it follow the screen containers you define. The first screenshot only has a container for the detail and the action bar is contained by it. The second should follow the same principle, the action bar(s) should be contained by the containers they've been put in.

FreddyThinkwise Local Partner Brasil

Upgrade rollbackOn the backlog

When you make alterations to the model, especially the data part that results in an upgrade script, there a plenty scenarios that break at actual upgrade. Especially for new users, because it's not always that obvious.I would like to see the SF dealing with this scenario more elegant. And it should be not that hard to offer some kind of rollback. Because all the info is there to upgrade, so also all the info is there to return to start. I am thinking about:Making especially the upgrade part interactive. Especially to have before the deletion of the temporary tables the choice to delete or rollback, in case of any error occurred. Or perhaps a separate task to reinstate the original tables, so you can fix whatever went wrong in the model and rerun the upgrade.Now you have to 'hack' your way through it via SMSS or go for restoring a backup. Which would also be a good and probably simple addition to the SF. Every upgrade should have the option to automatically create a backup before exec

FreddyThinkwise Local Partner Brasil

To not include expression fields in select when they are hidden in a variant.Completed

We have a table with quite some expression fields, that normally do not give a lot of performance loss because they are usually always shown as a detail of an order. However, we've created a variant on this table that breaks with this and although I've hidden the majority of the fields, the select that is generated in the end product will still contain all these expression fields that really make things slow. Wouldn't it be a nice idea to not add expression fields to the select of a variant when they are hidden? I know I can make a seperate view, but I would like to not do that. It would be great if the selects for view/tables (based on variants) could only contain the data-elements that will be shown (non-hidden).

FreddyThinkwise Local Partner Brasil

asked in Questions & Conversations

Performance issues Universal GUI

How do I turn this off? I have a view that calculates real-time timings, however I notice that because of lookups the view gets queried once for itself but then also for every lookup. There are many performance issues with this:Why the OR statements and not the actual pre-filter, they tend to be less performant than the exists clause in the pre-filter. Why all lookups are based on the base-table with a left join? Why not directly lookup on the lookup table?This setup is really killing me. Any advice here on how to optimize this situation? declare @handle int;exec sp_prepexec @handle output, N'@p0 int, @p1 int, @p2 int, @p3 int, @p4 int, @p5 int, @p6 int, @p7 int, @p8 int', N'SELECT t1.[process_id], t1.[process_task_id], t1.[tenant_id], t2.[description] AS [lookup_636502171]FROM [process_task_view] t1LEFT OUTER JOIN [tenant_definition_status] t2 ON t1.[tenant_id] = t2.[tenant_id] AND t1.[process_status_id] = t2.[domain_status_id]WHERE (t1.tenant_id = convert(int,SESSION_CONTEXT(N'tenant

FreddyThinkwise Local Partner Brasil

asked in Questions & Conversations

Universal GUI performance

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.

FreddyThinkwise Local Partner Brasil

asked in Questions & Conversations

Process flow to send report (SRSS) to an email

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?

FreddyThinkwise Local Partner Brasil

asked in Questions & Conversations

Error Maps component

For a Demo App, I am trying to integrate the Maps component. However I am getting an error, any ideas where to look for solutions? It's a 404 error. The documentation for me is not sufficient to know where to look for possible answer to this error.

FreddyThinkwise Local Partner Brasil

posted in Questions & Conversations

Some questions on the scheduler

We have been working a bit with the scheduler and I have some questions on how to solve it or when it could be seen in the GUI. How can we have the date range in Portuguese localization? It appears that with the scheduler component there is nog update button, how can I refresh it? Is there a way to dynamically color the bars? In this case there are 2 distinct flows.. I want to give them a different color. And if I have 3 different flows I want 3 different colors for the tasks matching the flow. Is there a way to show the day of the week that is shown? Can you give weekends / holidays a background color? Can we zoom in smaller then days (I know that question has been asked before). can the list on the left be a tree for example? That you can show the main levels and expend to lower levels?

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?

FreddyThinkwise Local Partner Brasil

asked in Questions & Conversations

Issues previewer iframe loading blank in IOS

Hi, We use several additional apps that are loaded via the previewer. On desktops it works perfectly fine.. however when we access the U-GUI via iPad/iPhone the iFrame sometimes loads but more-over ends us loading ‘blank’.. Why is that? There are no errors, no notifications.. just the iframe loads the app (and then it works) or it loads blank and it stays empty obviously. attached a .har file.

FreddyThinkwise Local Partner Brasil

asked in Questions & Conversations

Multiple messages in a panel

Anyone knows why you cannot return messages to the GUI panel using a cursor? I have a procedure that processes stock counts, and when there is an issue these are determined and returned as messages to the GUI panel using a cursor. The problem is I see the warnings in the debug screen but not the actual panel in de the GUI. Bug?

FreddyThinkwise Local Partner Brasil

asked in Questions & Conversations

Image doesn't update after refresh, only when switching between documents

I have a list with a status and status icon. When I have a task that updates the status, de icon changes also. However the text updates, but the icon doesn't update, only when I navigate away from that screen-element, go to another document for example and return to the initial list the icon has visually changed.. Would this be some kind of caching issue?

FreddyThinkwise Local Partner Brasil

asked in Questions & Conversations

Indicium console log - dbug messages

I have a question on Indicium logging:I have Indicium running in containers, and would like to know how to supress console logging, the console log is flooded with these dbug messages.

FreddyThinkwise Local Partner Brasil

Question to sql generation?On the backlog

I came across a story , and it mentioned a few AI cases that seemed interesting. Are there any movements towards adopting these type of technologies? There is a specific mention on 'question to SQL generation'. It would be great to have a user type in a question and the systems generates the right query to fetch the data and show it.

FreddyThinkwise Local Partner Brasil

asked in Questions & Conversations

When I logout the returnurl is missing the /indicium/ directory what is causing it?

Hi. I thought I got all working on linux, but I found out that when I logout the return URL is missing /indicium/ in its path. Where do I set this or what is causing this?https://server.lef.tec.br/indicium/account/ui/logout?returnurl=https://server.lef.tec.br

FreddyThinkwise Local Partner Brasil

HTML control UniversalPartially completed

The HTML control in the Universal is very limited, a user cannot do anything HTML like. It would hugely increase its value when it's something like there in the forum, where you can do text layouts including colors, links, quotes etc…

FreddyThinkwise Local Partner Brasil

Visual indication model is loading.Open

When you open the Universal GUI for the first time, or after an update I assume the full model is loaded, this can take up to a few seconds where you are staring at a white screen with not visual indication that there is actually something happening. This is quite unwanted, especially in situations where connections are slower. I would like to see a visual indication (like windows) showing that something is happening.

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.

FreddyThinkwise Local Partner Brasil

Visual indication that a process flow is running (Universal)Completed

I would like to see that the GUI shows a visuals indicator that a user is in a GUI flow. Now when you go from flow starting task A to task B (with a for example a decision node or HTTP requests in between) the user doesn't see that a next task is coming up. Implementation could be something like a tsf_send_progress idea where are user is aware that the flow is getting info, making a decision or whatever is in the flow.

FreddyThinkwise Local Partner Brasil

GPS coordinates Universal from DeviceCompleted

Does the Universal already support fetching the current location from a device that has a GPS function? Or is there a way to get it using HTML and Javascript (https://love2dev.com/blog/html-geolocation/) in for example a task to then fetch a route via API to a known location?

FreddyThinkwise Local Partner Brasil

OData: OpenApi / Metadata subselectsCompleted

For big models and applications, the openapi and metadata result is enormous and more often leeds to crashing client applications who want to read it. Would be great to be able to extract definitions for a specific endpoint or other sub-select. https://docs.thinkwisesoftware.com/docs/indicium/api#metadata

FreddyThinkwise Local Partner Brasil

asked in Questions & Conversations

Thinkwise and timezones (& language cultures)

I'm struggling a bit to understand where the platform support automatic timezone adjustments and where not. Basically I've set every SF part up to always save time elements in UTC and via domains to show local. Whereas based on the user-settings it will show at the timezone of the user. How does the platform change the timezone output? Is it done at runtime in the GUI? Does it only work via IAM or also via SF? It appears that it doesn't always work. Is there a difference between table or view? (see point 1 as well)And then we have custom elements and generated HTML. Here we have to basically sync the timezone information from the IAM with our App.Is there a translation table somewhere in the IAM to do the mapping from the IAM registered values to the windows timezone? (select * from sys.time_zone_info) (see also https://learn.microsoft.com/en-us/sql/linux/sql-server-linux-configure-time-zone?view=sql-server-ver16#time-zone-mapping )This because the SQL function at time zone only list

1
2
3
4
...
7

Page 1 / 7

Badges

Martijn_Reedehas earned the badge Geek
Dennis Kallanseehas earned the badge Geek
Alban_Thas earned the badge Generator
martijngaasbeekhas earned the badge Preparator
SanderAdamhas earned the badge Preparator

Show all badges

Powered by Gainsight

Terms & Conditions Cookie settings

Sign up

Already have an account? Login

Login

Login to the Thinkwise Software Community

Login

Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.

Username or e-mail

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

OK

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

OK