To Add Filter For Status In Report

Former Member
Former Member
I Have Three color Red-Green-Yellow Red=Pending, Green=Complete,Yellow=In Working I Need To Show Only Pending Activity On Report As Pending Activity Color Is Red So only  Red Color Should Be In Status <b>column</b> Please Help Me to Filter Status.. Its Urgent var qryItem = new Item("Project","get"); qryItem.setID(projId); qryItem.setAttribute("select","date_start_target,date_due_target,date_start_sched,date_due_sched,name,project_number,wbs_id,date_start_act,date_due_act,status,percent_compl,expected_duration"); qryItem.setProperty("status","#FF0000"); qryItem.setPropertyCondition("status","red");
Parents
  • Hello, By default, the Project ItemType does not have one status property that you can query on. There are 12 different status properties named status_1, status_2, status_3, etc, each representing the states of various phases of the project. I believe you'll want to search on the state proeprty of the Project by using code like qryItem.setProperty("state", "Pending");. Chris
    Christopher Gillis Aras Labs Software Engineer
Reply
  • Hello, By default, the Project ItemType does not have one status property that you can query on. There are 12 different status properties named status_1, status_2, status_3, etc, each representing the states of various phases of the project. I believe you'll want to search on the state proeprty of the Project by using code like qryItem.setProperty("state", "Pending");. Chris
    Christopher Gillis Aras Labs Software Engineer
Children
No Data