I have a module containing multiple line items. One of the line item is "org code" with format "Text". I need to filter data based on the values in this line item. "Org code" is actually representing organizations under a department. One department can have multiple org codes. As an example, I am attaching a screen print showing some of the line items of this module. For the sake of understanding, let's say there are 2 type of org codes - a.) Normal org codes - Having just the numbers in them e.g. 664401010. b.) Input org codes - They end with "_Input". e.g. H1_Input While selecting any department, I should be able to see org codes under it. There are 3 possible scenarios which I have to handle. Scenario1- Here I have taken some sample values of Org codes. 664401010 660401010 680436001 615401002 In this case, all the values should appear. Scenario2- In this case, I have taken following 5 sample values of "org code". 664401010 660401010 680436001 615401002 N1_Input In this case, I want filters to show all the values except for "N1_Input". Scenario3- In this case, I have taken following 4 sample values of "org code". N1_Input N2_Input N3_Input H1_Input In this case, all of the above values should appear. Basically, the ask here is whenever there are normal org codes then show all of them and whenever we have both i.e. normal as well as Input org codes then only show normal org codes and when we just have Input org codes then we should show all the Input org codes.
... View more