QueryBuilder: Sort the QueryField Attribuites ??

kalel_4444 · October 26th, 2009, 07:32 PM

Hello,

Anyone have a take on sorting / OrderBy the QueryFieldAttributes that are created in the DAL/...DataQuery.cs files ?

The QueryBuilder that was created with this book gives great flexibility. Vince, definitely thank you for this one.

I tried enumerating through the QueryFields in the Builder right after calling the GetCustomAttributes method. But I failed because it's of type object[] and I tried doing something like:
IEnumerable<QueryFieldAttribute> qfa = QueryFields.OrderBy(q => q.FriendlyFieldName);

I'm completely shooting in the dark on this since I never worked with QueryFieldAttributes till now. Is there a simple way of doing this and I'm just completely looking at this wrong..?

As always, any assistance is appreciated.
Ronnie

kalel_4444 · October 27th, 2009, 01:24 AM

Sorry, I guess I wasn't clear. I meant the actual Query Field Attribute List that is declared in the QueryData class and populates ddlFields in the QueryBuilder, not the results that populate ddlValues.

For example:

Day Type [0]
Current Owner [1]
Request Type [2]
Current State [3]

Thanks,
Ronnie

varallov · October 27th, 2009, 08:46 AM

try this

var sortedQueryFields = from q in QueryFields
where q isQueryFieldAttribute && !(q isRequiredQueryFieldAttribute)
orderby ((QueryFieldAttribute)q).FriendlyFieldName
select q;
foreach (object attribute in sortedQueryFields)
{
QueryFieldAttribute qfa = (QueryFieldAttribute)attribute;

_ddlFields.Items.Add(newListItem(qfa.FriendlyFieldName, qfa.FieldName));
}
_ddlFields.Items.Insert(0, "");

kalel_4444 · October 27th, 2009, 09:46 AM

Exellent, works great..!!!

Thank you

ZeroFactorial · November 9th, 2009, 05:59 PM

kalel,

thought I would post in this thread since you are familular with this portion.

Having a problem with the Query Builder. I can get all the way to the ReportQuery.aspx but when i click the Preview button I get the following.

Code:


if (QueryBuilder1.GetWhereClause(ref whereClause, ref validationErrors))
{
ENTReportBO currentReport = CurrentReport;
ReportDocument report = newReportDocument();
report.Load(Server.MapPath(currentReport.FileName));
Type objectType = Type.GetType(currentReport.ObjectName);
object listObject = Activator.CreateInstance(objectType);
 
//This is where it fails
object[] data = (object[])objectType.InvokeMember("Select", BindingFlags.InvokeMethod, null, listObject, newobject[] { whereClause });

I get the following error:
"Exception has been thrown by the target of an invocation."

The debugger shows that the data object is null. The SQL that I used in the DAL QueryData file uses a good amount of aggregate functions. Do you think this is the cause. I have looked and doubled check all that I can think of. Also, I added a query filed that is not pulled by the selet statement, but I cant include that field in the Select statement because it has to be apart of an aggregate function which isnt possible (datetime). Any help is appreciated.

Thanks

varallov · November 9th, 2009, 09:02 PM

Try putting a breakpoint in your Select method and a try/catch block to trap the exception. You'll be able to get a better idea of what is doing on if you get the real error message. It could be as simple as an SQL typo.