[code]declare @pointer int = 1 while @pointer < 3 begin select row.value('(./param1[1])', 'int') , row.value('(./param2[1])', 'varchar(10)') from @xml.nodes('(/rows/row[sql:variable("@pointer")])') as t2(row) set @pointer += 1 end [/code]
I don't think looping in processflows ever even crossed my mind. This could be a very nice solution. One thing though, I would personally prefer keeping a pointer (int) to the current row, this would keep the input intact. I had to fiddle around a bit, but here's an example of using a pointer:
Sounds great. But I can't quite see yet whether this would solve our issue where the process in question contains a http connector. The api we're talking to, only allows a single item to be requested every time. Which means the http connector needs to be ran for every item in the selection, which (if I read correctly) is still not possible.
I must say, those are some good arguments. I never really looked at it from a "does it add anything to our model" standpoint. My point about SQL injection might have been overstated, but allowing developers to go against the model using these fields might not be really great (although I must admit I don't see how you could deny them this without a SQL parser).
Hi Anne, you are completely right that in theory this should never happen. Problem is though, that in reality, with time pressure and such, we don't really manage to keep the trunk completely free of procedures that are ready for review
Haha, that seems to be a solution, but I think you are basically saying we can use SQL injection in those fields. So I don't think this is the nicest possible way. And what will happen when in the future someone does decide to include a checkbox for the peristed flag (I still support this), will all calculated column expressions be updated then?
Wow, that was quick. Kudos Anne
Nice, thanks!
Does that mean the GUI somehow sets that registry key? Does it do so right before opening the browser? I'm just being curious here, although it's also good to know what we can expect from client machines. Here's the result btw, so you're completely right: [img]https://uploads-eu-west-1.insided.com/thinkwise-en/attachment/bc19bbf9-da84-49d1-9f3a-7a83c734925d.png[/img]
Will this new prefilter filter on project or project_vrs? We are looking for a filter that filters all changes in the branch, not the specific version.
Sounds good. I'm looking forward to reading more of your blog posts.
I can imagine a focus on an international version for now. But why can I still select Dutch from the menu (next to German and Chinese) if these are not actually supported?
Hi Vincent, How far have you gotten with: "Enabling parts of a process flow to be executed for each selected record by introducing iterations."? For the time being we're not able to run a process on multiple lines in a grid.
Already have an account? Login
Enter your username or 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.