Re: add row to _status table

I see i need to
roundup-admin -i [location] set query[id] 
url=@columns=title,id,creation,activity,customer,priority,status,assignedto&@sort=priority&@group=customer&@filter=status&@pagesize=50&@startwith=0&status=-1,1,2,3,4

for each...

Hmm... it may be easier to just modify the db, but I don't have perms.
Thanks.
On 7/9/2013 10:20 AM, Aaron Jonen wrote:
> Ok thanks,
> It appears all of my saved searches are not updating to included my new
> "updated" status.
> When I go to edit a saved search they are set to "don't care".
> How /where do I modify saved searches for "not resolved" to fix this?
> On 7/9/2013 9:38 AM, Aaron Jonen wrote:
>> graci
>> Sorry for all the posts, I am a bit of a newb at mail lists.
>> On 7/9/2013 9:30 AM, Tom Ekberg wrote:
>>> Aaron,
>>>
>>> You have to customize your issue.search.html file. Here is what I have for the status attribute:
>>>
>>>       $ roundup-admin -i /the/path/to/your/tracker/home list status | sort
>>>       1: unread
>>>       2: inactive
>>>       3: active
>>>       4: for-review
>>>       5: resolved
>>>       7: not applicable
>>>
>>> And here is the snippet from my issue.search.html file:
>>>
>>> <tr tal:define="name string:status;
>>>                    db_klass string:status;
>>>                    db_content string:name;">
>>>      <th i18n:translate="">Status:</th>
>>>      <td metal:use-macro="search_select_translated">
>>>        <tal:block metal:fill-slot="extra_options">
>>>          <option value="-1,1,2,3,4" i18n:translate=""
>>>                  tal:attributes="selected python:value == '-1,1,2,3,4'">not resolved</option>
>>>          <option value="-1" i18n:translate=""
>>>                  tal:attributes="selected python:value == '-1'">not selected</option>
>>>        </tal:block>
>>>      </td>
>>>      <td metal:use-macro="column_input"></td>
>>>      <td metal:use-macro="sort_input"></td>
>>>      <td metal:use-macro="group_input"></td>
>>> </tr>
>>>
>>> Note that 'resolved' (id 5) and 'not applicable' (id 7) are not in the list for the 'not resolved' option. The 'search_select_translated' macro is defined in page.html. You can do a similar thing for your 'updated' attribute. You just have to know what the id is.
>>>
>>> Tom Ekberg
>>> Senior Computer Specialist, Lab Medicine
>>> University of Washington Medical Center
>>> 1959 NE Pacific St, MS 357110
>>> Seattle WA 98195
>>> cell: (253) 561-2509
>>> email: [email protected]
>>>
>>> On Tue, 9 Jul 2013, Aaron Jonen wrote:
>>>
>>>> Now when I do a search for status = not resolved.  updated is left out.
>>>> How do I make sure status of "updated" is included in not resolved
>>>> status searches?
>>>> On 7/9/2013 8:37 AM, Ralf Schlatterbeck wrote:
>>>>> On Tue, Jul 09, 2013 at 08:09:46AM -0700, Aaron Jonen wrote:
>>>>>> How do I use roundup-admin to add a row to _status table in the database?
>>>>>> I want to add an additional status of "updated".
>>>>> roundup-admin -i /path/to/tracker create status name=updated order=9
>>>>>
>>>>> you may want to redefine the orders of the other stati if you
>>>>> want a different order in the web interface.
>>>>>
>>>>> Ralf
>>>> ------------------------------------------------------------------------------
>>>> See everything from the browser to the database with AppDynamics
>>>> Get end-to-end visibility with application monitoring from AppDynamics
>>>> Isolate bottlenecks and diagnose root cause in seconds.
>>>> Start your free trial of AppDynamics Pro today!
>>>> http://pubads.g.doubleclick.net/gampad/clk?id=48808831&iu=/4140/ostg.clktrk
>>>> _______________________________________________
>>>> Roundup-users mailing list
>>>> [email protected]
>>>> https://lists.sourceforge.net/lists/listinfo/roundup-users
>>>>
>> ------------------------------------------------------------------------------
>> See everything from the browser to the database with AppDynamics
>> Get end-to-end visibility with application monitoring from AppDynamics
>> Isolate bottlenecks and diagnose root cause in seconds.
>> Start your free trial of AppDynamics Pro today!
>> http://pubads.g.doubleclick.net/gampad/clk?id=48808831&iu=/4140/ostg.clktrk
>> _______________________________________________
>> Roundup-users mailing list
>> [email protected]
>> https://lists.sourceforge.net/lists/listinfo/roundup-users
>
> ------------------------------------------------------------------------------
> See everything from the browser to the database with AppDynamics
> Get end-to-end visibility with application monitoring from AppDynamics
> Isolate bottlenecks and diagnose root cause in seconds.
> Start your free trial of AppDynamics Pro today!
> http://pubads.g.doubleclick.net/gampad/clk?id=48808831&iu=/4140/ostg.clktrk
> _______________________________________________
> Roundup-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/roundup-users


------------------------------------------------------------------------------
See everything from the browser to the database with AppDynamics
Get end-to-end visibility with application monitoring from AppDynamics
Isolate bottlenecks and diagnose root cause in seconds.
Start your free trial of AppDynamics Pro today!
http://pubads.g.doubleclick.net/gampad/clk?id=48808831&iu=/4140/ostg.clktrk