Questions & Conversations

Hi Everyone,We're populating a table with over 9 million addresses. These addresses serve an auto-complete lookup. Whenever a user starts typing, the lookup displays results that match what the user typed thusfar. This worked great when we had 10 addresses in the database. Now that the database is filled with over a million addresses, the lookup grinds to a halt whenever the user starts to type, uses the caret or clicks the looking glass to open the selection form. How do we handle tables containing a large amount of records with an auto-complete lookup?The database is still getting filled. Once filled, we'll create an index on the table. This will speed it up. What other things can we do to keep the UI user-friendly and responsive? Can the looking glass and/or the caret be removed from the field, for instance?We're using Universal, but the Windows GUI suffers from the same lag. Our database is an Azure hosted database.Thanks,- Alex.

Hi, in our application we create users and with the API endpoints mentioned in the topic below we also create and maintain them in IAM.Intelligent Application Manager - API on UserIn some cases it is necessaryto rename the user id and for that I want to use the task “rename_usr_general” in IAM. Is there a way to use this task as a API endpoint or is there a complete list of all the endpoints Indicium offers?

Hi, For our application, we are facing on several screens performance issues since we are in production and the set of data is growing.Some examples:For a table we moved some big fields containing json content already to a separate table, and made them visible in a form tab. But when click on the form tab, it still will take > 30 sec before it is loaded. It looks like the full table is loading before the related record is shown. For a screen we have defined a form layout to show (summary) details of related child records. This is currently build in a view, but when loading that tab it will take some time before the (filtered) data is shown. For a table we are showing lot of extra data with expression fields as the base data is not stored in that table, but in related tables. It is not preferred to have that data stored twice, als in the ‘header’ table to reduce the number of expression fields.Are there suggestions to improve the performance for loading the data in a form detail?

 Hi! I have put speciifc label for each group of columns as you can see below .I did this from subjects->compomontes>grid->group label .I want this label to be automatically generated based on the current month as the data is now hard coded .It there any possibility to do that with a layout or maybe other procedure?

I have a problem, perhaps because of the distance, that my downloads from TCP are failing more than they are successful. Looks like a download link is generated and doesn't persists.. because after a ‘network failure’ somewhere between Brazil and the Netherlands there is no way to restart or resume the download. I sometimes have to try 10 times before I successfully have downloaded updates and upgrades. Would be great if somebody could have a look at this.     

Hi,I've set up an image column with an image_upload domain.This is how the domain is set up:The ‘azure image’ storage location is configured like this:Where the user name is the storage account name and the password is key 1 from the Acces keys page for that particular storage.  All seems right to me so far. But when I opend the tab where this column is located I get an unknown error:This error can't be found in the logs and Redux isn't showing me anything to fix either. I know it's the image column that causes the error, because when I change the domain to something random like a varchar, the page loads fine. I'm on Universal GUI 2022.2.15 Anyone has an idea what it could be? 

How do I create a BEFORE trigger on a table still have the AFTER trigger working? I just noticed there is only the INSTEAD OF and AFTER trigger, can we create a BEFORE trigger with the SF?

I want to show a different text in a URL control type. It always shows the URL link, Is there a way to do this?

We tried to change our existing domain to new format (*.*.*.nl) to (*.*.nl), it is not working.Currently we are using non SSL url and when we changed it to SSL domain and updated indicium and SSL configuration files. But it is not showing the application as expected but the indicium page.(indicium.png). We don’t understand what we are missing here.Attaching the config files and error log too for your reference. Note: We are using Linux server with nginx.Hope someone could help us to resolve this issue. Thank you.  

What is the way to refresh the data model in the Universal GUI?I have an application built for the Windows GUI and now I want to use it in Universal but that needed some changes in the model. I am running the Universal GUI directly to SF.For example; I disabled the Layout input of a column, but Universal keeps giving an error about a missing parameter in the layout procedure.The only way to stop all these errors was to recycle Indicium, but there must be a nicer/easier way.

Hi,While trying to create user in IAM, the user is getting created when using Insomnia (after disabling SSL). The GUI version is : 2022.2.16.0The complete process worked form SF when the URL did not have SSL certificate.However for the URL with SSL certificate, the HTTP connector returned -1 .Can you please guide, how can I get it correct?it worked for insomniaHTTP connector input 

Hi all,we are having the following issues in Universal:where the data is not displaying properly. and Universal is changing the data. See attachmentsAnyone know what causes these issues? Datatype is bigint

Since the latest Universal GUI you can change the filter condition. I have a key field that keeps showing up as 'contains' in stead of 'equal to' (as defined in the SF).. It's a numerical field. Any ideas?

We are getting errors on our Indicium when executing process flows, it seems that Indicium opens a SQL connection for every scheduled process flow.On paper this sounds not to bad but our development environment we run into the limitations of Azure SQL. Azure SQL only has a limited amount of open connections which we are running into on our current tier (which is for all other metrics plenty). Currently it results in SQL errors regarding to many open connections.It also seems a bit strange to have constant open connections even for process flows that might only run once per day, week or even less.

I’m trying to create an inlineable Table Valued Function. I’ve created a subroutine with option INLINE set to ON. The function has a nearly empty template only containing:return;whenever I try to execute the source code I get this error:Msg 487, Level 16, State 1, Procedure get_calculation_component_overview, Line 47 [Batch Start Line 6]An invalid option was specified for the statement "CREATE/ALTER FUNCTION".The function executes fine when I remove the linewith inline = onThe database compatibility is 150 and we’re using SQL server 2019: Why isn’t this working?

Hi, I am looking for a solution to a challenge we seem to have with the possibility of two users editing the same record simultaneously. Now, any changes made by the first user to save his or her changes will be overwritten by the changes of the second user.Is there any known way to prevent this from happening? (Preferably using some form of user feedback, “User X is editing this record, it is not possible to update it at this time”) I'm not familiar with whether/what kind of session information is available in Thinkwise. Thanks in advance.  

Hello, We’re currently working on our CI/CD processes where we let Azure Devops Pipelines automatically deploy our environments. To validate whether the deployed environment is stable, we execute unit tests. This will give us an idea of the stability, but ideally we would also like to (automatically) execute process tests. This is currently not available in the Universal GUI and i don’t think we can execute them automatically on the Windows GUI.So my question is when we can expect to run process tests in the Universal GUI and can we execute these process tests with for example odata calls? Or will there be an other way to execute these process tests automatically after deployment? We’ve read the below topic but it doesnt really give a clear answer and is already a year old. We’ve hoped that there might be more information available at the moment. 

Hi,Can the size of the menu Help (opening with F1 ) be modified? I have a 32 inch monitor, yet my help is the size of a beer coaster?! It looks silly, and readability is not great either.  I have set the popup size with the extended propety (which works), but Help seems to ignore this. Let me know, would be nice! Kind regards,  Alexander 

Hi everyone,We have a detail page with a SQLeditor control and some text inputs below.When we make the window smaller, there is no second tab created, only when the space is very small: And in the second tab only the last field is shown. Is this a bug? Or default behaviour when having a large component on a detail?

I am looking for a nice solution to do two things: save a report to PDF and send it to someone. The 'Autonomously generate report and send it by e-mail’-example is great, but as for as I know is that only suitable if you want to send a report to one receiver.I have a table with over 300 persons, and I want to generate a report per person (parameter is per person different), save it and send it to their mail adress.For now I have the following process flow to loop through the list and save the report: With this flow it takes a bit of time to generate and save each report, so the user cannot do anything. Best thing is to move it to Indicium, so the only thing the user has to do is to start the Table task (and that calls Indicium to start the generate report / mail report flow).What is the best way to achieve such a ‘loop through list’-feature in Indicium?

I’m trying to use the new ZIP connector to zip a folder.With the following input parameters.The input parameter ‘Source file or folder (pointer)’ suggests that I can use a folder path. However I can’t seem to get this working.Indicium log file shows the following error: “The parameter 'Source file or folder (pointer)' was provided with an invalid value.”I’ve tried different folder paths but keep getting the same error:Are folders not supported?Can I choose a source folder outside the file storage location that is linked to the process action?

Is it possible to enable subject’s page size also in Windows Gui?I would like to load only first 500 records and ‘on request’ load also other records.If i load all records i have a performace problems.I know there is ‘max no. of records’ oprion on subjects, but i don’t know how can end user can disable this filter.  

Hi all,I have currently in our live production System 3 separate applications for which:The 2 Applications share the same DB but separate GUI and subdomain access Universal GUI+Indicium on App Service A Web GUI on App Service B The 3rd Application separate DB  and subdomain access Universal GUI+Indicium on App Service C The reason we have separate App Service was to enable O365 login on App Service C, as the users of App Service A, B cannot be enabled yet. The subdomain is for creating individual uniqueness of the published app to differenciate to users.App Service A Universal GUI login:App Service B Web GUI login:App service C Universal GUI Login with O365 only: NOW with the 2022.2 version and the new openID Provider being configured in the IAM, there is no possibility to have the App Service A login but Only App Service C. Questions:How or what can I configure to have the same specific logins as it was before? Is this a matter of IAM and openID Provider cannot be assigned to specif

I have following warning in the indicium log (2022.2.15):2022-11-15T09:45:00.0010321+01:00  [WRN] Process action "list_folder_connector_ubl_files" in processflow "ubl_read_files_system_flow" in application 224 returned the following message: "The parameter 'Delete all directory contents' was provided with an invalid value 'list_folder_recursive_no'. Only disk_list_recursive_on and disk_list_recursive_off are recognized, defaulting to disk_list_recursive_off (false)." (86be518d) It tells me to provide a value on or off, but I can only choose No or Yes: 

How do I make a cube editable? Like this: