Setting Filter in SmartObjectWizard for For each loop

  • 21 April 2017
  • 1 reply
  • 1 view

Badge +4

I have troubles with filtering out SmartObject data for For each loop. The SmartObject is SharePoint list type. Problem is that instance runs too long (about 2 hours each day), since I not able to filter per Datum field (today). Currently i have set filter by ID, status, and some other fileds. I noticed that filter doesn't work correctly when i have combination A and B and (C or D). I managed to work it correctly when I chnaged filter rule to A and B and C and D and E (just changed status to AND conditions withoud grouping OR).

 

I will be very hapy if anybody has hint how to filter our per datum, or maybe some other way (prepairing/replicating filtered data in other SO for 4eachloop).

 

Some details about configuration:

SO has 3000 rows

For each SO conf.: Input parameters empty, Filter (has parameters).

 

Please find enclosed screens.

 

Thank you for hints!

 

 

 


11469iC8FC7BB28A59B364.png
15528i1F2DB64387275B07.png
15861i6890067AF546F3B4.png


1 reply

Badge +4

I just solved it. I was not able to get any result, when I defined datum in input mapping, but I succed in Filter.

 

I constructed 1.1.20*personal details removed*:30 AM (the value which I have stored in SO) in following way:

NameofVariable, type DateTime

Transfer data, expression:

 Today ->  NameofVariable

 Add Hour NameofVariable -> NameofVariable

 Add Minutes NameofVariable -> NameofVariable

 

I hope anybody helps this ...

 

 

 

Reply