Replies posted by Freddy

340 Replies

FreddyThinkwise Local Partner Brasil

Scheduler: Calendar viewOpen

Something like this: https://vkurko.github.io/calendar/

4 months ago

Arie VSuperhero

FreddyThinkwise Local Partner Brasil

OData: OpenApi / Metadata subselectsCompleted

New→Needs feedback Uh yeah, when you build your own custom frontend on top of thinkwise that are used by power-users..It's not just client applications, it's custom front-ends, it's extended integrations using preview components that inherit user profiles.. power users can have a very big set of rights. And also in these scenario's it can be handy to load the API definition in Postman.Insomnia, etc.. So yeah, the rights are correct, but you only need a special subset to develop a custom page or something.

5 months ago

Gabriela AndesRookie

asked in Questions & Conversations

SESSION_CONTEXT(N'guid') to be used globally.

@Vincent Doppenberg agreed, but I am reading this with a lot of interest, as we have a running opportunity for a system that would require this as well, a user set encryption key preferably not to be stored in a DB but in a key vault or to be provided by the user to fetch encrypted data, do something with it and encrypt it again for storage. Besides the data filter, which I would always recommend in this scenario, one of other requirements is that some user-entered info is always stored encrypted via a key only known by the user, which can never be stored in the system itself.. just in the user-session to be used to en/decrypt.

7 months ago

Gabriela AndesRookie

asked in Questions & Conversations

SESSION_CONTEXT(N'guid') to be used globally.

Hi Freddy, We tried this approach already and added/overwritten the value of a session_context inside a process flow. But the problem we faced is that the data for that session_context is only available on the specific process flow it was created. We will be using this in a view, so we are finding a way to transfer the session_context data from one process flow to another without saving it in the database. Hi Gabriela, The idea is not to overwrite the SESSSION_CONTEXT yourself but let the platform do it by storing a temporary extended property per user session.GUID whereas the platform will persist the session variable. Just don't forget to destroy the session variable when it’s no longer needed.

7 months ago

BramGVanguard

asked in Questions & Conversations

Detail tab page icons appear to be inconsistent

The icons are a bit inconsistent and not complete:In the menu some icons are not shown, whilst if you activate it, the icon is shown at open documents. Also it appears the icons only show for details, not tab-pages or the own subject. The first in the vertical tabs is the form… the second a fixed container in the screen-component. Also, the icons in the submenu appear to be shown larger than the icon of the parent. I guess it needs some finetuning still.

6 months ago

Gabriela AndesRookie

asked in Questions & Conversations

SESSION_CONTEXT(N'guid') to be used globally.

I don't think this is possible using TSQL. In theory you would I guess be able to store as session variable dynamically in the IAM extended property for the application during the process flow (don't forget to de-set it at the end).. via de IAM API endpoint /gui_appl({model_id},{branch_id},{gui_appl_id})/detail_ref_gui_appl_gui_appl_extended_propertySession.[session_variable] Universal GUI Indicium Indicium Basic Add session variables. A guid session variable is available by default to uniquely identify a user session. You can use the value of a session variable in your SQL business logic or prefilters using the SESSION_CONTEXT function, e.g. select session_context(n'guid'). https://docs.thinkwisesoftware.com/docs/sf/extended_properties

7 months ago

FreddyThinkwise Local Partner Brasil

asked in Questions & Conversations

Previewer with URL listed in allowed origins is blocked CORS.

This is not something that is because of Indicium (so changing the "allowed origins” won't have effect). This is because your dashboard uri (https://dashboard.esm.app.br/) returns the X-Frame-Options header. The browser tries to load the url you provided for the previewer/iframe and blocks it because of this header. Hi @Dick van den Brink, Thanks for the tip.. I was able to do an override via the config to not set this header.. but however it still doesn't load, don't get the blocked message anymore, but the previewer stays empty. <iframe data-testid="previewer__custom-screen-url" src="https://dashboard.esm.app.br/superset/dashboard/p/lr87LblDQkE/" sandbox="allow-scripts allow-same-origin allow-popups allow-popups-to-escape-sandbox" class="css-y1obzt"></iframe> Any suggestions no how to troubleshoot this? For some reason, the header kept coming back.. I have resolved the issue for now by altering the reverse proxy with an additional statement. proxy_hide_header

6 months ago

FreddyThinkwise Local Partner Brasil

asked in Questions & Conversations

Previewer with URL listed in allowed origins is blocked CORS.

6 months ago

Linde van DyckPartner

asked in Questions & Conversations

Charts in Universal

Group Interval Date doesn’t seem to be working still? I’d like to get rid of the T00:00:00 and only show the date. I’m a bit surprised it even shows this since the domain is DATE and not DATETIME(2). Being able to show the a date in a chart is basic functionality and I wonder why this has not been fixed yet (Or I might be doing something wrong). @Marius Korff yes the date notation, has been this horrible since the start.. however the latest U-GUI should have improvements (didn't check it yet)..

7 months ago

BramGVanguard

Create role Data analyzer in SFOpen

Good idea.. Would be great to have a role for authorizations, role definitions etc…

7 months ago

FreddyThinkwise Local Partner Brasil

asked in Questions & Conversations

Process with HTTP connector to download file and subsequently unzip action.. doesn't work.

I found out that the destination folder has to be empty.. but I do stil have a question. I have a zip that contains 5 CSV files which I want to process and subsequently delete from the hard-disk. what would be an advisable way without creating a physical table? As I understand you cannot create a temp table that only exists during the process-flow correct?

8 months ago

FreddyThinkwise Local Partner Brasil

When refreshing a list, also refresh the preview (URL)Closed

Hello Freddy, We intentionally do not refresh the previewer when switching rows as this can quickly result in a lot of network traffic if larger files are shown in the previewer. I do agree that the content of the previewer should be refreshed when a manual refresh is performed. If this is currently not the case, could you submit a ticket? Done 7452S

8 months ago

ElenaTodirenchiVanguard

asked in Questions & Conversations

Generate report and save it like a record in a table

Hello, Thank you for the quick response. I tried something similar with the "HTTP Connector", however, I want to insert the report as a record in another table, and I am not certain of how to achieve this without getting duplicate reports (one coming from the report generation and one after inserting the record into the other table, which automatically gets saved in azure). Depends on ‘the other table’ where it is and how you can access it. I see 3 options:The write_file like @Mark Jongeling suggested where you use the platforms storage locations. The http_connector where you use an API of sorts to get the record inserted in Azure. The database_connector. The flow stays the same generate_report > do something with the report (one of the above)The part on duplication I don't really follow.. you generate a report and process it.. if you have no intention of keeping the generated one you can delete it with the delete_file connector (if you have saved it somewhere along the way)..

8 months ago

FreddyThinkwise Local Partner Brasil

asked in Questions & Conversations

Automate default backup at every deployment, anyone already made this and cares to share?

@John Sangers it's that easy :) Thanks!As we use containers, I did it as followed:declare @database varchar(30) = (select DB_NAME())declare @path varchar(150) = '/var/opt/mssql/backup/'declare @target varchar(260) = @path + @database + '.bak'BACKUP DATABASE @database TO DISK = @target WITH FORMAT;

9 months ago

FreddyThinkwise Local Partner Brasil

asked in Questions & Conversations

Status drag and drop records Universal GUI

@Mark Jongeling in the latest beta drag-drop works from a grid. I was looking at the forecast.. will drag-drop from cardlist ever be supported? In an era where everybody loves a Kanban it's a huge deficit if it wouldn't be supported. Hi Freddy, Looking at the Universal GUI backlog, it does have User stories for it. In the future, we would love to add drag-drop support for cardlists. However, drag-drop from or onto a cardlist never worked before thus making it a new feature. As we are currently focusing on having the Universal GUI replace the Windows GUI in functionality as stated in this blog by Jasper, it is unknown when drag-drop from and onto a cardlist will be planned for implementation. It's a bit of a pity, and a missed opportunity, because the cardlist doesn't exist in the Windows GUI and in a web-environment it is much more a go to component. What you are saying is that we probably have to wait over a year to have full drag-drop functionality. I would really lo

9 months ago

FreddyThinkwise Local Partner Brasil

asked in Questions & Conversations

Status drag and drop records Universal GUI

9 months ago

BasWesselinkSidekick

asked in Questions & Conversations

ODATA: Function that returns nested JSON

@BasWesselink what I was aiming at was:returnselect * from ( query that creates your json ) j Should return it as a json (unescaped).. You might have to do direct $select=<column> where the selected column is the full json .. so the TVF just returns one row and one column.. it's a bit of a hack.. but if I remember correctly this should function..

9 months ago

BasWesselinkSidekick

asked in Questions & Conversations

ODATA: Function that returns nested JSON

@BasWesselink you can create the json but return it Table valued in stead of a scalar. That would return the json unescaped.

9 months ago

Anne BuitCommunity Manager

published in News & Blogs

Forecasting demoBlog

Is their any indication on the minimal CPU/MEM availability for the container running the forecasting service?

2042

9 months ago

FreddyThinkwise Local Partner Brasil

Standard API for combo elementsOpen

@Freddy If I understand you correctly: you would like to be able to receive the Domain element translation as part of a regular API call to a record? So for example: if you wish to receive a Contact record and the gender is registered with a Domain with elements, you would like to be able to retrieve the gender translation (e.g. male or female) to replace the 0 and 1 domain elements as part of the regular API call to the contact table. If yes: sounds like a great idea to me! Yes indeed. Basically a domain with elements is a modelled reference table.. For the sake of uniformity and making just one call to get translated data it would be very nice if the $expand function would treat domain elements like it was any other lookup table.

11 months ago

FreddyThinkwise Local Partner Brasil

Model actionbar elementsPartially completed

Hi @Freddy, If I understand your idea correctly, it looks like this is the same idea as mentioned here: The way I read it, both ideas focus on being able to determine which elements of the action bar should be shown, depending on the context. Would it be an option to merge these ideas, and that you add your business case as described above to that idea as a reaction? It has overlap, but my idea goes further:I want to actually hide for example the combined search and pre-filters in a situation when there is only form. I want to hide standard CRUD actions, search, pre-filters etc in a situation where a preview component is used on a third tab with only the previewer. It now gets the full actionbar and this is unwanted. And the hide main action-bar removes it from all tabs, not just that one. So you can merge, but make the solution comprehensive..

24 days ago

Page 3 / 14

Replies posted by Freddy

Scheduler: Calendar viewOpen

Add custom Menu items to topbar in Universal GUIOpen

OData: OpenApi / Metadata subselectsCompleted

Create role Data analyzer in SFOpen

When refreshing a list, also refresh the preview (URL)Closed

Forecasting demoBlog

Standard API for combo elementsOpen

Model actionbar elementsPartially completed

Badges

Sign up

Login to the Thinkwise Software Community

Scanning file for viruses.

This file cannot be downloaded