Tall & Fall
This is a concept I fabricated. Sometimes users would ask me to create a saved search and have a filter for a checkbox. That seems simple enough. NetSuite does allow users to filter based on the checkbox status - either unticked or ticked. But users would sometimes request to be able to filter ticked, unticked, or both in the results. As a workaround, I recommended to use a formula (text) as an available filter, where users can type t, f, or all. The criteria filter would be a formula (text), returning tall or fall (true or false respectively). It worked I guess. When doing this however, I recommend not adding other formula (text) filters in the criteria. Doing so will apply AND logic, and can mess up search results.
Comments
Post a Comment