Hello Blommetje,I am not sure how the web interface handles this. Perhaps someone with more experience regarding the web interface can answer this.Erwin
What GUI are you using? With the windows GUI using filter with the setting 'Start empty with filter’ is the way to go. When opening the screen this retrieves no data. Then when applying the filter it only retrieves the relevant rows.
Search highlights the first row that matches the search description, without filtering the data on screen. Filter actually filters the data and returns only the rows matching the search criteria. In most cases you would probably want to use the filter option. Search form however, this screen type object does not seem to work correctly currently. I have reported this as a bug. Please note that you can always search using right mouse button and selecting 'find’.
Can't wait to work with this new feature this will save lots of time!
This is a feature that is on the backlog. For now you could create 2 tasks and assign the template to both tasks. https://community.thinkwisesoftware.com/ideas-18/allow-multiple-variants-of-tasks-to-be-linked-with-a-table-225
Indeed this part is skipped when there are no model changes. Please report this as a bug.
What version of the software factory are you using?
Create a second reference but based on a different value. You probably need to create a new column to do this. This could be an expression column where you have a value based on the initial reference, something like: (id + 1). Then you also need to create a screen type to support this.
The customer has a screen where the import is always from the clipboard. However, I have discussed this with them. In the future we will not use this functionality any more so they will use it the way it is for now, since currently it is not possible to do this. No wish required, this topic can be closed.
Can you check the following: do you have multiple columns with the same column filter order no? For me it does not work when this has the same number.
Do you have any columns set up as Extended in the combined filter (subject - data - filter)? If so try a subject that only has visible for filter: always.
does it also not work when applying the change to the column document_number using the enter key? It works perfectly fine if i use enter.
This seems to only work when using enter to apply the change. Using tab or the mouse ignores the setting and just goes to the next field.
Currently this is not possible. If you feel this is needed then please make a wish for the default to include variant_id.
The manual states: The Advanced option affects the expansion of the search/filter screens. This implies that the filter condition is not used for the Combined filter. So please make a wish for this.
This is either a bug or a wish. The filter condition is only applied to the filter (right mouse button: filter) and not to the combined filter.
Hi Frank, This helps a lot. Thank you very much. Erwin
What is the function of this task? The version is automatically created when creating a project. And once v1 of a project is build you only want to copy the version. I would opt for removing this button, unless someone can explain when you would use this task?
Why not just make the default 0.01? Most projects I have seen use 0.01 incrementals.
I strongly disagree with step 3 if you mean this should create an actual SQL function (table or scalar): "For every program object of type EXPRESSION a function is generated." not only will the function slow down your SQL query it will also mess up the execution plan. I think it would be better to translate the function to a sub select or a join (cte or regular join).
@Jop ter Horst I had the same idea a few weeks back: https://community.thinkwisesoftware.com/ideas-18/make-added-functionality-visible-in-the-process-flow-design-screen-787 so of course you get my vote.
Consider changing the recovery model of the database to BULK LOGGED during the data import operation. This will reduce the IO of the log file a lot. The article Vincent mentioned follows up on it a bit later as well. @Anne Buit I assume this is only advised when the current recovery model is set to full model.
@Mark Jongeling based on what you mentioned, the temp table is probably your best bet. But try to do a select into for the new temp table, instead of insert. I think it's best to give this a try with some mock data and compare the execution plans and run time. You mainly want your primary key columns to be correct in the temp table.
@Mark Jongeling What are the differences in the primary key columns in the global temp table? Is it just the data types or do you need to concatenate columns in the temp table to create the columns from the product table? If so it is best to fix these issues when you fill the global temp table with data. Then you can create an index and insert the data.
There is no easy answer to this question. Because like with most things SQL related it depends on a lot of factors. Make sure you don’t have too many indexes and statistics on the table ‘Product’. Rule of thumb: max 5. Like Vincent said, you do not want too many triggers and constraints on this table. Is all imported data new? Or could there be updates/deletes or rows ignored (since they already exist? If so, don't use the merge statement but use individual insert/update/delete statements (all set based of course). If possible use select into instead of insert into for the global temp table. Also consider creating a (clustered) index on the global temp table based on your clustered index of the Product table.
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.
