i have table "jobapplication"

in this table there is following fields

JobApplicationID JobDetailID CandidateID JobBoardID DateApplied

now i want to execute following query

select  count(candidateid)  from jobapplication group by jobdetailid;

so how can i achieve in LLBLgen?

please give me some sample code please.

This is easy done with DynamicList. I assume from your previous threads, that your are using SelfServicing:

EntityFields fields = new EntityFields(1);
fields.DefineField(JobApplicationFields.CandidateId, 0);
fields[0].SetAggregateFunction(AggregateFunction.Count);

IGroupByCollection groupByClause = new GroupByCollection();
groupByClause.Add(JobApplicationFields.JobDetailId);

DataTable dynamicList = new DataTable();
TypedListDAO dao = new TypedListDAO();
dao.GetMultiAsDataTable(fields, dynamicList, 0, null, null, null, true, groupByClause, null, 0, 0);

Hope helpful

daelmo wrote:

This is easy done with DynamicList. I assume from your previous threads, that your are using SelfServicing:

EntityFields fields = new EntityFields(1);
fields.DefineField(JobApplicationFields.CandidateId, 0);
fields[0].SetAggregateFunction(AggregateFunction.Count);

IGroupByCollection groupByClause = new GroupByCollection();
groupByClause.Add(JobApplicationFields.JobDetailId);

DataTable dynamicList = new DataTable();
TypedListDAO dao = new TypedListDAO();
dao.GetMultiAsDataTable(fields, dynamicList, 0, null, null, null, true, groupByClause, null, 0, 0);

Hope helpful

Hi daelmo,

Thanks for reply, but problem is that due to some special requirement i cannot use TypedListDAO or DATATABLE or datareader. i can just use only entity and collection and i want to get output.

this is special requirement.

please help me

Hi daelmo

i have done like below and this also gives proper output. is this right method to do???

JobapplicationCollection JobApplicationDetail = new JobapplicationCollection(); Label1.Text = JobApplicationDetail.GetScalar(JobapplicationFieldIndex.CandidateId, null, AggregateFunction.Count, (JobapplicationFields.JobDetailId == 3)).ToString();

daelmo wrote:

This is easy done with DynamicList. I assume from your previous threads, that your are using SelfServicing:

EntityFields fields = new EntityFields(1);
fields.DefineField(JobApplicationFields.CandidateId, 0);
fields[0].SetAggregateFunction(AggregateFunction.Count);

IGroupByCollection groupByClause = new GroupByCollection();
groupByClause.Add(JobApplicationFields.JobDetailId);

DataTable dynamicList = new DataTable();
TypedListDAO dao = new TypedListDAO();
dao.GetMultiAsDataTable(fields, dynamicList, 0, null, null, null, true, groupByClause, null, 0, 0);

Hope helpful

Hi daelmo

i have done like below and this also gives proper output. is this right method to do???

JobapplicationCollection JobApplicationDetail = new JobapplicationCollection();
        Label1.Text = JobApplicationDetail.GetScalar(JobapplicationFieldIndex.CandidateId, null, AggregateFunction.Count,
            (JobapplicationFields.JobDetailId == 3)).ToString(); 

This is your first quey:

select count(candidateid) from jobapplication group by jobdetailid;

Such query generates more than one result (row), right?

If it generates more than one result you cannot use GetScalar. If you only want the total count, then the GetScalar is just fine

daelmo wrote:

This is your first quey:

select count(candidateid) from jobapplication group by jobdetailid;

Such query generates more than one result (row), right?

If it generates more than one result you cannot use GetScalar. If you only want the total count, then the GetScalar is just fine

Hi Daelmo,

Thanks for make me clear. well i want to know that in below code:

EntityFields fields = new EntityFields(1);
fields.DefineField(JobApplicationFields.CandidateId, 0);
fields[0].SetAggregateFunction(AggregateFunction.Count);

IGroupByCollection groupByClause = new GroupByCollection();
groupByClause.Add(JobApplicationFields.JobDetailId);

DataTable dynamicList = new DataTable();
TypedListDAO dao = new TypedListDAO();
dao.GetMultiAsDataTable(fields, dynamicList, 0, null, null, null, true, groupByClause, null, 0, 0);

how to display the output above code in gridview??? because dao.GetMultiAsDataTable return bool value.

DataTable dynamicList = new DataTable(); TypedListDAO dao = new TypedListDAO(); dao.GetMultiAsDataTable(fields, dynamicList, 0, null, null, null, true, groupByClause, null, 0, 0);

GetMultiAsDataTable() fills the passed in DataTable (dynamicList...in your case), so you can bind this dataTable to the gridView.

Walaa wrote:

DataTable dynamicList = new DataTable(); TypedListDAO dao = new TypedListDAO(); dao.GetMultiAsDataTable(fields, dynamicList, 0, null, null, null, true, groupByClause, null, 0, 0);

GetMultiAsDataTable() fills the passed in DataTable (dynamicList...in your case), so you can bind this dataTable to the gridView.

thanks walaa,

its too easy after ur solution. thanks.

hip hip hurray.