In addition to the following topic: It would be nice to be able to weave code before the begin try so we are able to create custom scenarios in the software.(For example for logging purposes) For the same reason it would be nice to be able to weave code after the end catch.
Having the possibility to use indicium to automate generating / unit test / validation and all is very nice, as found here: https://docs.thinkwisesoftware.com/docs/sf/deployment_automation I think it would be a great addition the be able to schedule these from within the SF since from there we know the current project / project_vrs and the indicium we need. We want to schedule unit test and validations every night, it would be nice and quick if we can accomplish this within the SF with a simple click instead of having an external program running a schedule and retrieving the current active project_vrs to run the procedure.
In a process flow you can choose different actions, like activate form and activate grid, but you cannot choose to active a card list, we are missing this because in some situations we only show the card list and the form, and not a grid, and we want to send the user back to the “overview” which in this case is a card list. https://docs.thinkwisesoftware.com/docs/sf/process_flows_actions#activate-gridactivate-form
As we all know, merge statements are ideal for executing multiple actions in a single statement—an insert, update, and delete with one statement and one source query. This blog is intended to help you make a well-informed decision about when to use a merge statement and when it’s better to avoid it. There is no right or wrong choice, but be aware of the consequences of using a merge statement and the consequences of using separate statements. When using a merge statement, you must take into account that the source and target tables can be locked. These locks are larger than with separate statements due to lock escalation, which increases the likelihood of deadlocks. You can (partially) prevent this by using a CTE (Common Table Expression) to make the target table smaller, thereby reducing the size of the locks, and by placing the source table in a temporary table so that it doesn't cause a lock during the merge. For example: -- Collect data to mergeselect j.product_id , j.product_namei
As a developer, I aim to unit test my table-valued functions independently from the functionality where they are used. This approach provides better results and simplifies the setup of unit tests. Unfortunately, the current documentation indicates that testing table-valued functions separately is not supported. However, I propose an alternative approach: Setup: Use the same setup as for a scalar function. Output Testing: Verify the function’s output using an assertion query. Below is an example of how the generated code might look: -- Declare parametersdeclare @first_id int = convert(int, '1');declare @second_id int = convert(int, '2');declare @return_table table ( "id_1" "int" null, "id_2" "int" null, "value_1" "varchar(10)" null); -- Execute unit testinsert into @return_table (id_1, id_2, value_1)select id_1, id_2, value_1from dbo.table_valued_function(@first_id, @second_id); -- Assertion queryif exists (select 1 from @return_table)begin exec tsf_send_assertion_msg 1, 'Successful';en
Having a couple of different base model linked to different work models we come across a small problem. After generating the “generated by control procedure” field is populated with the text “Copied from base model”, in my opinion it would be very useful to see from which base model this is copied, could this be added? Now we have to search the different base model, this would help a lot! It could be shown as something like this:"Copied from base model (MODEL)”
In IAM you can see your system flows and also add an extra schedule as a application owner. But the thing I am missing is that an application owner can manually start a system flow from IAM. Epically handy when in D/T/A environments but also useful in production when you don't want to wait 59 minutes for a system flow to become active when it just ran 1 minute ago.
All the standard indicium API's are expecting JSON and have JSON as output, also most of the 3rd party API's use JSON, therefore I think it would be useful to have some different JSON approaches and examples at one place, please feel free to add your own in the comments. Creating JSON When creating a simple JSON statement it would look something like this, this is without data from a table, but for example data you get in a process flow for 1 record and need to pass it to a JSON API. --Having an example variabledeclare @json nvarchar(max) set @json = ( select 0 as Value_1 ,1 as Value_2 ,1 as Value_3 ,1 as Value_4 ,0 as Value_5 ,0 as Value_6 ,0 as Value_7 for json path, without_array_wrapper) The output would look like this: { "Value_1": 0, "Value_2": 1, "Value_3": 1, "Value_4": 1, "Value_5": 0, "Value_6": 0, "Value_7": 0} When you leave out the "without_array_wrapper” you will treat the set as an array and the result would look like this, where the difference is in the square brackets,
Within the functionality you can add a piece of code before, during and after a upgrade script, this is really usefull with data converisons, really like the functionality. But what I am missing is when I add a new function and need this function in the data conversion there is no place I can do this except for the manual script. But the manual script I have to delete after upgrading, otherwise this will be executing every upgrade.It would be usefull for me if we are able to make a upgrade script functionality but the really in the end which we can assign to a certain upgrade version x → version x.y
Hi, I am using the Resource Scheduler in the universal GUI, I really like the look and feel, but I dont really like the way the sorting is working right now. By default is sorts (within a resource): Start date end date name In my opinion the sorting should have more customization options. For example: I want it to sort how my subject is sorted, because I have an order column in my appointments. In my example I want the first 4 green ones like they are, but then the 5, 6 and 7 from the blue one, then the 8 and 9 from the yellow and then the 10 and 13 from blue again. If the events dont overlap, then they can start behind the others, but with overlap, I would like it to sort with the order numbers in the table.
Case When adding a column to a table, often we have a generated trace column with a high order_no, this so the columns are always in the back of the table. When adding a new column the SF checks what the maximum order no is within the table, when there is a number with a bigger step then 100 the SF ignores this, which is really helpfull for adding new columns. In our end product we have generated views for history tables, these have an automatic generated reference with an order_no of 999, when adding a new reference this will get the max number + 10, so a new reference will be 1009, can you add the same logic for this order no as well? And maybe add this for all the functionality which has a automatic generated order_no?
Imagine the following situation: Version 1.27 is on the test database Version 1.28 got an upgrade script functionality, assigned to ug_after_1_27_to_1_28 This works perfect and I will create version 1.29 after upgrade. After developing and testing version 1.29 I want to deploy 1.29 to the production Production is version 1.27, so in the SF I will put 1.27 as previous project version. When upgrading from 1.27 → 1.29 I will loose the upgrade script ug_after_1_27_to_1_28 I can imagine that this works the same with branching and merging. Ususally I will attach these upgrade functionality to ug_after_always to prevent this situation, but then I have to cleanup upgrade scripts after a while. It would be nice if we can prevent this and the SF would recognise that between 127 and 1.29 there is an upgrade script that needs execution.
Hi, We have a view with a auto-edit and auto-save form, we have 1 editable field which is a barcode, after entering a barcode and hitting <tab> (which a barcode scanner does) in universal the focus goes onto the next object and does not save the record, is that intended? (2022.2.14 gui) Focus is on the 3 dots, top right. Also: When entering the screen, I cannot change records because of the form being in edit mode, we first have to cancel the row and select a new row. For us not a big problem for now, but I don't think this is intended?
SQL server version 2016 has introduced the feature of setting up system-versioning to tables (also known as ‘system-versioned’ temporal tables). This means that SQL server stores a history of data changes and deletions which take place within a table. There are various methods of creating history tables, but with SQL server you can allow a history table to be made automatically for a table. To build a test scenario, let’s first create a table called article. code: create table article(article_number varchar(10) not null,article_name varchar(100) null,article_price numeric(9,2) null,constraint article_pk primary key clustered(article_number asc)) In order to create a history table, SQL first needs start_date_time and end_date_time columns on the table which is to be logged. code: alter table articleadd start_date_time datetime2 generated always as row start hidden not null default '1900-01-01 00:00:00.0000000', --Can be anything, but has to be in the past. end_date_time datetime2 genera
Hi all, I am curious about a couple of things in the Universal GUI:We have a subject with 2 prefilters, showing perfectly on a bigger screen: Prefilters showing up top left But when the screen gets smaller, the prefilters are hidden behind the 3 dots, in my opinion there is enough space left to show the prefilter buttons, is this by design? And can we influence this by a setting? And can we influence if only 1 prefilter shows, which one that would be, is that with the “order no” ? Prefilters hidden top left. The next question is about the alignment of the headers in universal, we see them aligning with the same alignment of the data, the same behavior as the windows GUI.But in the Windows GUI we see that the text that is aligned on the right side, still starts at the beginning, as in the Universal GUI we only see the end of the text, is this by design? Cause I would prefer the same behavior as in the windows GUI since this is more clear. Alignment right, with “verkooporder” & “Nummer”
When developing a process flow, in the design screen it would be very usefull to have a viausal indication when a process procedure is used in a process step. Now you have to go to the step to check, and then going back to the design (which takes a bit of time rebuilding the screen). There is no visual indication that a process procedure is being used on a step.
I think it would be a nice addition to add subroutine_paramtr_tag the same way there is for task_paramtr and report_paramtr.
It would be a very nice feature if we can set a default password expiration, as in 2 month for example. So after 2 months the user will be forced into changing it's password.
Goal Sometime you need to extract only the file name (or maybe extention) from a file path. Solution declare @file_path varchar(500) = '\\server_name\folder_name\folder_name_2\file_1.txt';select right(@file_path, charindex(char(92), reverse(@file_path)) - 1)
When you request something from indicium (ie a table or subroutine) and a column is empty, then indicium will not send the column with the respond. It would be nice if there is a setting per request if you want the empty columns to be sent or to be hidden.
The current situation is as follow: We have a development IAM, test IAM, acceptance IAM and production IAM. For now we can focus on dev and test IAM. The roles are now in the SF, so after synchronizing to any IAM the roles are copied automatically, which is very nice. When creating a new branch or application we synchronize this to the develop IAM, and from there we create groups and attach them to the roles and application. But now we want to push the application to the test IAM, we synchronize the SF to the IAM, all the roles are copied, but not the groups. It would be very nice to have a task which can copy the groups to the test IAM FROM the develop IAM and attach the roles already present in the test IAM. This way the develop IAM is leading towards develop, acceptance and production.
When I logon to the community and I check the box: "keep me signed in" it will keep me signed in for the day / session. But the next day I have te sign in again, is this by design or a bug?
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.
We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.
