I wanted to know this, please be patient and read....
# suiteanalytics
t
I wanted to know this, please be patient and read. I wanted to know the Number of sales orders till now in a field on sales order(pretty unusual). So I created a saved search on sales order with mainline true, now I took count of internal ids in the results, going well.. Now I ran the search and it gave me count , perfect. Now in order to populate that field I need to give a filter in Available filter, I gave internal id (I know this is wrong but listen) and it gave me value 1 in the field on sales order. Perfect .. Now I changed the filter in Available filter to Internal id (Number) and it gave me full count. I don't know why, I tried to populate the internalid number field myself in the saved search and it gave me count 1, while it gives the 4563(total numbers of SO) in that field. Unsure of how this is working, I wanted to give the test to another fields, I tried with another text field in available filter, it returned error in field, I tested another integer number fields and it gave me total(4563) again in the field. Now my mind says, when an interger number is applied as filter, it is dropped and no filter is applied , that's why it gave me total . I just want to know from you people why filter is dropped.
p
Just trying to understand what you actually want to do. You want a field on every single sales order that is effectively a count(*) of sales order transactions? So each sales order dynamically has this same number visible on it? Very weird business requirement
t
Its, not a requirement at all. Its very weird , I know,(It was some random thing, and I am stuck on this now) I just want to understand how the filter was removed. I just want an explanation over this, why this happened ? @PNJ