Hello, I am trying to create a saved search to get...
# administrationm
megha
08/31/2020, 2:55 PMHello, I am trying to create a saved search to get all the items that that have more than 1 bin location . For example Item A has two locations Bin 1 and Bin 2. I tried to put the criteria as summary but I didn't work. It is showing all the items even if they have one only bin location. Could anyone please help me with this how I can get all the items that are in more than 1 bin location ? Thanks
s
Sandii
08/31/2020, 2:57 PMWell you put greater than 0, so exactly 1 location should populate.
m
megha
08/31/2020, 3:03 PMoops Sorry.. I tried it with greater than 1 too. it didn't worked 😞
b
battk
08/31/2020, 3:12 PMwhat do your columns look like
v
Vtor
08/31/2020, 3:21 PMyour results need to be summarized as well for this to work if i am not mistaken
m
megha
08/31/2020, 3:54 PMHere's the results snapshot which columns I am trying to pull. I tried to summarize results also and it gives no result. I am only looking for the highlighted results in the search.
megha
08/31/2020, 3:54 PMHere's the item record look this:
v
Vtor
08/31/2020, 3:55 PMwhen you edit the search on the results column did you try grouping by a field, and then counting the binonhand,binnumber field also?
Vtor
08/31/2020, 6:21 PMif you could send a screenshot of the actual inside of your saved search's results area that would be good. should be an easy fix once we can see that
m
megha
08/31/2020, 6:47 PMPlease find attached screenshot, it is giving zero results
b
battk
08/31/2020, 6:53 PMdont group by bin number
💯 1
battk
08/31/2020, 6:54 PMgrouping by bin number means that each combination of name and bin number gets its group/row
battk
08/31/2020, 6:54 PMthe groupings that are used by the columns is the same as that used by the criteria
💯 1