01. Queries - Examples in Ledger

Selecting all Ledger names
  
  Select * from Ledger 



Select $Name from Ledger

Ledger name with GSTIN

Select $Name, $PARTYGSTIN from ledger

Select $Name, $PARTYGSTIN from ledger where $Parent Like "%Sundry Debtors%"


Select $Name, $Parent, $PARTYGSTIN from ledger where $Parent Like "%Sundry Debtors%"

Select $Name, $Parent, $PARTYGSTIN from ledger where $Parent Like "%Sundry creditors"

Select $Name, $Parent, $PARTYGSTIN from ledger where $Parent Like "%Sundry creditors%" or $Parent Like "%Sundry Debtors%" 

Select $Name, $Parent, $PARTYGSTIN from ledger where $Parent Like "%Sundry creditors%" or $Parent Like "%Sundry Debtors%"  and $PartyGSTIN is not null

Select $Name, $Parent, $PARTYGSTIN from ledger where $Parent Like "%Sundry creditors%" or $Parent Like "%Sundry Debtors%"  and $PartyGSTIN is null

Select $Name, $Parent, $_PrimaryGroup, $ClosingBalance from ledger

SELECT $Name, $ClosingBalance FROM Ledger WHERE $$IsDr:$ClosingBalance

Select $Name, $Parent, $_PrimaryGroup, $$AscrAmt:$ClosingBalance from ledger

Select $Name, $Parent, $_PrimaryGroup, $$AscrAmt:$ClosingBalance as Closing_Balance from ledger

***String Start with the word Sundry Creditors
Select $Name, $Parent, $PARTYGSTIN from ledger where $Parent Like "%Sundry creditors"

***String is contains the word Sundry Creditors
Select $Name, $Parent, $PARTYGSTIN from ledger where $Parent Like "%Sundry creditors%"

***String end with the word Sundry Creditors
Select $Name, $Parent, $PARTYGSTIN from ledger where $Parent Like "Sundry creditors%"

***String is contains the word S any where in the parent string
Select $Name, $Parent, $PARTYGSTIN from ledger where $Parent Like "%S%"


Select $Name, $Parent, $_PrimaryGroup, $OpeningBalance, $ClosingBalance, $Isrevenue from ledger