how to do parameter Binding in dataset for boolean datatype.
i have a data set in which there is a boolean field say "X" which has both "true" and "false" values in it. By default, if i dint set any condition for the boolean field "X" in the parameter page of the dataset, it is pulling only the values which has false values.But i would like to get both true and false values from the dataset. Please let me know what is the way to get all the values irresspective of the true or false flag for the X.
For multiple value selection in the dataset of type String we use '\'Y\',\'Z\''.Similarly is there a way that we use for boolean too?
Accepted answer
In the web client, you can retrieve true and false archive-related fields by checking the "Include Archived" check box when you run the report. By default, when running an installed report, work items that have an archived Category, Team Area or Iteration are not retrieved. That's one of the reasons to archive these. Queries won't retrieve them either.
Comments
Thanks a lot Bill Taylor. The reports is able to show the Archived artifacts too.I dint notice this option at all.I was trying to fetching it via dataset Queries.
Thanks a lot for the quick reply.
Hi Bill,
I have one more question.I could see the ''Include Archived" ption when i run the report by creating a "Report from Resource" option but if the report is added to the dashboard i could not see this option while linking to the main or micro report.
Is there a way that i can include the archived defects in this option too?
2 other answers
Boolean fields should behave the same as other types of field. Which field in which dataset are you having a problem with?
The only special case I can think of is one like CATEGORY_ARCHIVED, where by default when running an installed report, archived work items are not retrieved.
The only special case I can think of is one like CATEGORY_ARCHIVED, where by default when running an installed report, archived work items are not retrieved.
Comments
i am trying to retrive Iteration Archived,Contributor Archived, Category Archived,Owner Archived from WORKITEMS Table,LIVE_WORKITEM_CNT table .But by default its retriving only false records if no condition is given to these fields.
I would like to get both true and false records of these fields.May i know what is the condition that i need to use for these fields in the parameter binding of the dataset.
I am able to retirve either true or false records alone.Let me know how to retrive both value records?