Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Show only
|
Search instead for
Did you mean:
This page has been translated for your convenience with an automatic translation service. This is not an official translation and may contain errors and inaccurate translations. Autodesk does not warrant, either expressly or implied, the accuracy, reliability or completeness of the information translated by the machine translation service and will not be liable for damages or losses caused by the trust placed in the translation service.Translate
Is it possible to search 2 fields for 1 value using an Or Criteria.
I have items that contain "To" and "From" fields. I am creating a custom app where I want to search on "Connections". If the user types "BOX A" in the Connection box, I want to search in for it in the To and the From field. I know it is possible to search 1 field for 2 values ( Criteria being From Contains val1 OR val2. But is it possible to search ona criteria "From Contains val1 OR to contains val1".
An example SQL query would be (searching for a value of P5)
SELECT * FROM table1 WHERE table1.From Like "*P5*"OR table1.To Like "*P5*"
As you may already know, direct database access is unsupported.
Through the API you can only do AND type searches. However you can manually
create an OR search through the API by making two searches and performing a
union on the results.
Here are the steps:
1. Do the first search. Ex. To="Bob"
2. Do the second search. Ex. From="Bob"
3. Combine the results from the 2 searches.
4. Remove any duplicates.
Any possibility that this is going to change? This is a feature that is fairly common in other applications. For example, we recently changed or description procedure so it would be nice to search on "old description OR new description". I would think this is in pretty high demand.
