> ## Documentation Index
> Fetch the complete documentation index at: https://docs.finscreener.in/llms.txt
> Use this file to discover all available pages before exploring further.
# FQL Examples
> Real-world FQL query examples for common business scenarios
## Investment Research
Find mid-sized tech companies in major hubs:
```
(State IN ['Maharashtra', 'Karnataka', 'Tamil Nadu']) AND
(NICDesc CONTAINS 'software' OR NICDesc CONTAINS 'technology') AND
(paidUpCapital > 1000000 AND paidUpCapital < 50000000) AND
dateOfIncorporation > '2018-01-01' AND
llpStatus == 'Active'
```
**Use Case**: Target recently incorporated tech companies with growth potential.
Find publicly listed companies with significant capital:
```
Listed == 'Listed' AND paidUpCapital > 100000000 AND State == 'Maharashtra'
```
Find private companies with high capital, recently incorporated:
```
classOfCompany == 'Private' AND
paidUpCapital > 50000000 AND
dateOfIncorporation > '2020-01-01' AND
llpStatus == 'Active'
```
## Lead Generation
```
NICDesc CONTAINS 'manufacturing' AND
City IN ['Pune', 'Chennai', 'Ahmedabad'] AND
paidUpCapital > 5000000 AND
llpStatus == 'Active'
```
```
(NICCode IN [62011, 62012, 62013]) AND
City IN ['Bangalore', 'Hyderabad', 'Pune'] AND
paidUpCapital > 1000000
```
```
NICDesc CONTAINS 'retail' AND
State == 'Delhi' AND
llpStatus == 'Active'
```
## Compliance Monitoring
Identify entities with potential compliance issues:
```
(Status != 'Active' OR TaxpayerType == 'Composition') AND
Turnover > 20000000 AND
(ConstitutionBusiness == 'Proprietorship' OR ConstitutionBusiness == 'Partnership')
```
```
Status == 'Suspended' AND state == 'Maharashtra'
```
```
llpStatus == 'Dormant' AND State == 'Maharashtra'
```
## Market Research
Companies incorporated in the last year:
```
dateOfIncorporation > '2024-01-01' AND
State == 'Karnataka' AND
llpStatus == 'Active'
```
```
(NICDesc CONTAINS 'e-commerce' OR NICDesc CONTAINS 'electronic commerce') AND
paidUpCapital > 1000000
```
```
(NICCode IN [64191, 64192, 65110]) AND
llpStatus == 'Active' AND
paidUpCapital > 10000000
```
## Regional Analysis
```
City IN ['Jaipur', 'Lucknow', 'Indore', 'Kochi', 'Chandigarh'] AND
dateOfIncorporation > '2022-01-01' AND
llpStatus == 'Active'
```
Compare tech companies across states:
```
(State IN ['Maharashtra', 'Karnataka', 'Tamil Nadu', 'Telangana']) AND
NICDesc CONTAINS 'software' AND
paidUpCapital > 5000000
```
## Query Optimization Tips
Put most selective conditions first:
```
Turnover > 100000000 AND City == 'Mumbai'
```
More efficient than multiple OR conditions:
```
City IN ['Mumbai', 'Delhi', 'Bangalore']
```
Fields like City, State, Status are indexed and faster to query.
Narrow date ranges improve performance:
```
dateOfIncorporation > '2023-01-01' AND dateOfIncorporation < '2024-01-01'
```