--- title: payout tags: subscription --- ``` query ($organizationsId: uuid) { jobPostOrganizationsStatus(where: {_and: {hired: {_neq: 0}, organizationsId: {_eq: $organizationsId}}}) { hired job { creditPerVacancy created_by } organization { payoutsTransactionHistories_aggregate { aggregate { sum { transactionAmount } } } } } } ``` ``` query MyQuery { jobPostOrganizationsStatus(where: {hired: {_neq: 0}}, distinct_on: jobId) { hired job { id title creditPerVacancy totalVacancies created_at } } } ``` ``` { jobPostOrganizationsStatus (where: {_and: {hired: {_neq: 0}, organizationsId: {_eq: $organizationsId}}}){ hired applied rejected jobId organization { isIndividual name } job { title creditPerVacancy totalVacancies payoutsTransactionHistories(where: {organizationsId: {_eq: $organizationsId}}) { id accountName accountNo accountType approvalAmount created_at created_by ifsc jobId organizationsId promisePeroid sanctionedAmount transactionAmount transactionMethod transactionNo } payoutsTransactions(where: {organizationsId: {_eq: $organizationsId}}) { id accountName accountNo accountType approvalAmount created_at created_by ifsc promisePeroid sanctionedAmount status transactionAmount transactionMethod transactionNo updated_at updated_by organizationsId jobId } } } } ``` ``` jobPostOrganizationsStatus(where: {_and: {hired: {_neq: 0}, jobid: {_eq: $JobId}}}){ hired applied rejected jobId organizationsId organization { isIndividual name payoutsTransactions (where: {jobId: {_eq: $jobId}}){ id accountName accountNo accountType approvalAmount created_at created_by ifsc promisePeroid sanctionedAmount status transactionAmount transactionMethod transactionNo updated_at updated_by organizationsId jobId } payoutsTransactionHistories(where: {jobId: {_eq: $jobId}}) { id accountName accountNo accountType approvalAmount created_at created_by ifsc jobId organizationsId promisePeroid sanctionedAmount transactionAmount transactionMethod transactionNo } } job { title creditPerVacancy totalVacancies } } ```