Find Details Using Specific Operators
Find in TallyPrime | List of Field Names | FAQ |
You can find within specific master types, fields, or voucher types, and refine results using specific operators. Use AND, OR, NOT to include or exclude results, and operators like >, <, or = to find values above, below, or equal to a specific number or date.
Logical operators such as AND, OR, and NOT can be used directly with keywords. Numerical and string operators must be used with field names. You can view the list of field names here. When using field names, make sure there are no spaces or special characters in the query. The correct syntax is Fieldname: value. For example, ledgeramount: 10000 or stockitem: Television.
Logical Operators
| Symbol | Operator | Result | Example |
| & | AND | All transactions and masters with both keywords | Type: Steel & Cement Displays all transactions and masters that contain Steel and Cement; in any order |
| | | OR | All transactions and masters that contain any one of the keywords | Type: Repairs | Services Displays all masters and transactions that contain Repairs, Services, or both. |
| ! | NOT | All transactions and masters that do not include the entered keyword | Type: Repairs ! Replacement Displays transactions and masters that contain only Repairs; excludes those with Replacement, both Repairs and Replacement. |
Numerical & String Operators
| Symbol | Operator | Result | Example |
|
= |
Equal to |
All transactions and masters that have exactly matched entries as the specified value. |
Type: Name=Samsung, Ledgername=John Similarly, it displays transactions in which the field Ledger Name contains an exact match for John. |
|
!= |
Not equal to |
All transactions and masters that do not have matching entries as the specified value. |
Type: Name!=Samsung |
Numerical/Date Operators
| Symbol | Operator | Result | Example |
|
> |
Greater than |
All transactions and masters that have any field value greater than the specified value. |
Type: Ledgeramount>50000, actualquantity<120kg Displays transactions where actual quantity is less than 120 kg. |
| Similarly, you can use >= (Greater than equal to), < (Less than), <= (Less than equal to) | |||
String Operators
| Symbol | Operator | Result | Example |
|
~ |
Similar to |
All transactions and masters that have any field value with approximate similarity and exact matches. |
Type: Name~Sourav, Address~Bangalore Similarly, displays transactions and masters where the address like Bangalore or Bengaluru both exist. |
| Similarly, you can use !~ (Not Similar to) to view all masters and transactions without exact and similar matches. | |||
|
” “ |
Double quotes |
All transactions and masters that have any field value with exact matches of the words in any order. |
Type:“Sourav Traders” |
|
‘ ‘ |
Single quotes |
All transactions and masters that have any field value with exact matches of the words in any order. If you choose to include similar spellings result will show both similar and exact matches. |
Type:‘Sourav Traders’ |
|
: |
Colon |
All transactions and masters that have any field value that contains, starts with, ends with, equals, or is similar to the entered keyword. |
Type: Destination:Bangalore, Vouchernumber:INV/1236 Similarly, displays INV/1236 in the voucher number. |
Combination of Operators
You can use multiple operators together to form complex conditions.
|
Type |
Result |
|---|---|
|
stockitemname=Refrigerator & actualquantity>30 vouchertypename:Sales & ledgername:Bhagya |
Displays transactions with item name Refrigerator and quantity is greater than 30. |
|
ledgername:bhagya & itemname:samsung |
Displays transactions where ledger name is bhagya and item includes samsung. |
|
ledgername:bhagya | itemname:samsung |
Displays transactions where ledger name is bhagya or item includes samsung. |
| (vchtypename = payment & narration: ‘cash paid’) & amount > 25000 |
Display all the payment voucher where the narration is mentioned as cash paid and amount is greater than 25000. |
If the query entered is not valid, it is treated as plain text, and results are displayed accordingly. A note appears below the Find Results page stating:
“The query may not be valid. However, the results are displayed based on the matching text.”
Here are a few examples of invalid queries:
Cash & – Here there is no keyword after the & symbol.
Ledger: – Here there is no keyword after the : symbol.
Narration: = cash – Here both the colon and the = symbol are used, which is wrong.
Samsung 50” – You might have created a stock item as Samsung 50” but for Find the symbol “ (double quotes) is reserved in order to apply and show results for exact match. If you want to ignore this rule, then the same query has to be written within single quotes i.e. ‘Samsung 30”’ or with a backward slash \ before 30 i.e. Samsung 30\” to get the required results.
