FQL Examples

(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'

Listed == 'Listed' AND paidUpCapital > 100000000 AND State == 'Maharashtra'

classOfCompany == 'Private' AND
paidUpCapital > 50000000 AND
dateOfIncorporation > '2020-01-01' AND
llpStatus == 'Active'

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'

(Status != 'Active' OR TaxpayerType == 'Composition') AND
Turnover > 20000000 AND
(ConstitutionBusiness == 'Proprietorship' OR ConstitutionBusiness == 'Partnership')

Status == 'Suspended' AND state == 'Maharashtra'

llpStatus == 'Dormant' AND State == 'Maharashtra'

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

City IN ['Jaipur', 'Lucknow', 'Indore', 'Kochi', 'Chandigarh'] AND
dateOfIncorporation > '2022-01-01' AND
llpStatus == 'Active'

(State IN ['Maharashtra', 'Karnataka', 'Tamil Nadu', 'Telangana']) AND
NICDesc CONTAINS 'software' AND
paidUpCapital > 5000000