Using Virtual Fields via Search

I have created a virtual field that is subtracting two date fields that will show anything that is less than or equal to a certain range for a custom list. I set logic up on the virtual field to be set as a 1 if it is within that range (true) and a 0 if it is not within the specified range (false). My goal was to then be able to use the search look for a value of 1, but it says 0 filtered hits, which is not accurate.

Is it even possible to use virtual fields to search for specific value? If it is possible, how can it be done?

Thanks!

Find more posts tagged with

Accepted answers

All comments

Rene Bottern

I don't think this is possible, since Search is only including Tables (Fields in Tables).
This might make for a great ER, and also being able to use these Virtual Fields in Search API's (CMS015) would be a great feature!

Denis MARETTE

I agree with Rene.
Indeed, the search is limited to the fields of a main table.
And even if we only use fields from this main table to build a logic using virtual fields, unfortunately these virtual fields can't be used as selection or search criteria either.

Copyright © 2025 Infor. All rights reserved.