Workflow Builder and row state

[#1]

Hi,

It seems that Workflow Builder does not appear to record the script when the Row data filter is used to select rows of a table and then change row state for the selected rows.

Tried using log window to view the steps and could not locate the steps either.

Any help would be appreciated.

Cheers.

[#2]

Hi @Onjai ,

I think because the creation of the data filter is not 'logged' it is not accessible to the Workflow Builder to record into the steps. That being said, if you have the rows selected with the filter, you can click onto the data table then apply the change to the row state manually (i.e. Row hide and exclude) and this will be recorded in the WB.

For example if I use the Tablet Production sample data set and want to filter (and exclude) by API Particle size, I can get the data filter ready with 'Select' ticked:

Then I can choose my selection (at this point the WB does not record any actions):

I can then apply a change to the row states manually (in this case hide and exclude):

And then it appears as a step in the WB:

Hope that helps!

Thanks,

Ben

[#3]

Hi Ben,

Interesting that Workflow records the Hide/Exclude but for me but the workflow does not record changing row color.

I am using using JMP 18.1.

Onjai

[#4 · Accepted solution]

At least in JMP 18.2 it does record color row state changes, so it might have been added with that

And the recorded script looks like this

Data Table("Big Class") << Select Where(
	(:age == 12 | :age == 13) & :height >= 59.03
) << Colors("Medium Dark Red")

[#5]

Hi Jarmo,

Perfect.  Thank you!

Onjai