Product updates
Ideas
Groups
E-learning
Documentation
Events

Community
Search

Replies posted by Freddy

350 Replies

Newest first

Oldest first

Sjors NiestenApprentice

Release notes Universal GUI (2022.1.12)Release Notes

Hi Why is my grouping field not spanning? In the SF : Could there be hidden columns between your Grid groups that are not visible in your screen? You can disable the prefilter "Possibly visible” to see the hidden fields. I checked this, there is on hidden field but that’s not in between the grouped fields.

2565

2 years ago

FreddyThinkwise Local Partner Brasil

asked in Questions & Conversations

Indicium - Initial connection takes a long time.

I think I found the issue, completely overlooked it. I have a key value that I can search. Apparently it's passed on via the U-GUI as 'contains' in stead of a 'Equal to' (see other post).. in this case the key value is passed as a like '%value%' and then it scans the entire database 3 times.. because this view has 40 Mln+ companies, 60 Mln. Establishments and 30 Mln partners … when I do the query with EQ it's milliseconds because it actually does a seek. But when it's passed with a 'LIKE'.. the actual query plan shows the 3 streams (company, establishment and socio) being scanned ( so it scans to all records and this takes a long time). The other problem that added to the 6 minutes is the way that the filter form fills itself. I have a related field with 60 options.. however it doesn't get the options from the related table but it first joins it with the full view and than groups it to make it unique.. This takes a lot of time, also because the lookup is a left join and not a fu

2 years ago

FreddyThinkwise Local Partner Brasil

asked in Questions & Conversations

Universal GUI performance

@Vincent Doppenberg any release date known? We have an event April 12th and we want to showcase this App and I would really like to have this fix as it speeds up the application but without showing any error. Any chance it will ship before that date?

2 years ago

Sjors NiestenApprentice

Release notes Universal GUI (2022.1.12)Release Notes

Hi Why is my grouping field not spanning? In the SF :

2565

2 years ago

FreddyThinkwise Local Partner Brasil

posted in Questions & Conversations

Filter form dropdown (related table) empty when starting empty with filter.

I can now see that this is created as a result of having this related table in the filter. Is there a way to just have it look at the related table? And not create something like below. Would a select from the related table with perhaps an exist in context table be more performant? SELECT t1.[natureza_juridica], t1.[lookup_955552244]FROM (SELECT t1.[natureza_juridica], t1.[lookup_955552244]FROM (SELECT t1.[ativo], t1.[natureza_juridica], t2.[descricao] AS [lookup_955552244]FROM [empresa_view] t1LEFT OUTER JOIN [natureza_juridica] t2 ON t1.[natureza_juridica] = t2.[natureza_juridica]) t1WHERE t1.[ativo] = @p0GROUP BY t1.[natureza_juridica], t1.[lookup_955552244]) t1ORDER BY t1.[lookup_955552244] ASC

1 year ago

FreddyThinkwise Local Partner Brasil

asked in Questions & Conversations

FreddyThinkwise Local Partner Brasil

asked in Questions & Conversations

Universal GUI performance

SELECT COUNT(*) AS [count]FROM (SELECT t1.[ativo], @p0 AS [tsf_placeholder], t1.[nome_empresarial]FROM [empresa_view] t1OPTION (RECOMPILE)) t1WHERE t1.[ativo] = @p1 AND t1.[nome_empresarial] LIKE @p2This construct is not valid as it seems.

2 years ago

FreddyThinkwise Local Partner Brasil

asked in Questions & Conversations

Universal GUI performance

Hi @Vincent Doppenberg , That did the trick, 59ms. However I now get an error 500 on the count query… any idea why?

2 years ago

FreddyThinkwise Local Partner Brasil

asked in Questions & Conversations

Universal GUI performance

Hi @Vincent Doppenberg .. I think it's the query, see screenshot. Just another question I am running directly on the SF. This extended property also exists in the SF? Or how do I force the recompile without extended properties of the IAM?

2 years ago

FreddyThinkwise Local Partner Brasil

asked in Questions & Conversations

Universal GUI performance

@Mark Jongeling it improved a little bit but still 19223 milliseconds and in SMS stays well under a second.

2 years ago

mperrottHero

SF support for date formats on the domainOpen

Good idea, would be interesting to extent this feature with also numerical formats… so a currency would actually show as a currency based on a users locale or set locale.

2 years ago

FreddyThinkwise Local Partner Brasil

asked in Questions & Conversations

Filter Form with required values

Hi Freddy, That is currently not possible. Feel free to create an idea for that. Alternatively you could create a Task that fills a "Filter result” table based on the inputted filter values. Changing any of these filter values will empty the table and insert the row that match the given filter values. This would be similar to how the Code search works in the Software Factory. It's an idea but not very feasible in my situation I guess, where even with 3 filters I would get a result set of a million + which I then have to insert into a tabel. But I'll keep it in mind. I'll at least make the idea.

2 years ago

FreddyThinkwise Local Partner Brasil

asked in Questions & Conversations

Indicium DB log

Thanks @Arie V that indeed did the trick.

2 years ago

FreddyThinkwise Local Partner Brasil

asked in Questions & Conversations

Http connector and large JSON results

I’ll have to troubleshoot, because I see more data in the DB but it only shows so many records and there is no cap defined in the settings.

2 years ago

FreddyThinkwise Local Partner Brasil

asked in Questions & Conversations

Default value via expression

Hi Mark. I already fixed the issue, so I am trying to recreate the issue.. and I can't.. when I try to recreate what happend it doesn't… you can use the getdate() and it works.. but for some reason within our upcycled project it created something very strange… So forget it for now, there must have been something else as well I guess…

2 years ago

FreddyThinkwise Local Partner Brasil

asked in Questions & Conversations

Best practice on rolling back an upgrade gone wrong.

@Erwin Ekkel you can give your vote 😀

2 years ago

FreddyThinkwise Local Partner Brasil

Data entry masksMerged

HI @Mark Jongeling if they are set up to have them used as input and visualization masks, then yes the idea overlaps. A lot of these numbers are stored as numeric fields, but you want to insert and show them formatted with reading signs. So you want them for input, but also for visualization when a form/list is shown.

2 years ago

mehmet kayaRookie

asked in Questions & Conversations

An explicit DROP INDEX is not allowed on index

To fix this problem, first drop al Foreign Keys and Constraints on any of the columns used in the Index. Then drop the INDEX and afterwards you can recreate the FK and constraints. I've had a similar issue.

2 years ago

H. LukassenSidekick

posted in Questions & Conversations

transfer our real-time freight data

Our local servers here have an sftp instance. We use it to send information securely to the server and a file connector can pick it up from there and process the XML.

2 years ago

Edwin SaanSidekick

asked in Questions & Conversations

Continous barcode scanning with Android device in universal

Hi Guy, You can read about the required MIME types over here: https://docs.thinkwisesoftware.com/docs/deployment/universal#deployment Kind regards, Erik Perhaps good to know that in IIS 10 only the .wasm mimetype is missing by default.

2 years ago

FreddyThinkwise Local Partner Brasil

posted in Questions & Conversations

What would be the best approach to process various CSV files on disk (1GB each) and import them.

Hi @Mark Jongeling, Any chance you have been playing with the FORMATFILE option? I guess I'll try it with the bul insert and see how it performs.

2 years ago

Philip NRookie

asked in Questions & Conversations

Automatically add users to IAM

You can create a table where you import your excel connect every addition to a process flow that utilizes the standard API's of the IAM to add users…

2 years ago

Diana KuipersModerator

Thinkwise Platform release 2022.1release notes

Last night I've run the upgrade to 2022.1 and although everything seems fine, the authorizations of my trainees that where in a separate tenant got stripped of their SF rights in the IAM and on the DB (no more End User rights). Anything incorrect in the upgrade script or did I do something wrong?

74614

2 years ago

Page 13 / 14

Badges

NickJanssenhas earned the badge Critical Thinker
Roelhas earned the badge Hero
Martijn_Reedehas earned the badge Geek
Dennis Kallanseehas earned the badge Geek
Alban_Thas earned the badge Generator

Show all badges

Terms & Conditions Cookie settings

Sign up

Already have an account? Login

Login to the Thinkwise Software Community

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

Enter your email address

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.

This file cannot be downloaded

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