r-labs » Issue Template

Hello.
I think this is related to #995 and its tracker is not the defect but feature. Is this right?

By the way, do you have already some other system or knowledge base system that you hope to apply these data as template?

Akiko Takano は書きました:

Hello.
I think this is related to #995 and its tracker is not the defect but feature. Is this right?

Yeah, thats right.
I think the differene is that a query to get templates from other system could have more than just one key attribute.

By the way, do you have already some other system or knowledge base system that you hope to apply these data as template?

No, at the moment the table is a csv list which is edited manually. There is no 2 tier application at the moment. But we plan to make crud app (maybe rails or adobe lifecycle) which will store that data in a database in near future. That we will at least be able to query a table on same server as redmine db we will create by extracting template master data from other system by sql query and cron job .

I read your blueprint and i think number 3 would be best. Thre must be some place where one can configure a 2 sql queries. First query shall return a list with template key entries, so that one is choosen in drop down the seond query will use that entry as search param to get fields which will be pushed into corresponding redmine issue fields as template. The desihn in best case make it possible to replace slq queries 1/2 with any http web service client to get template key entry list and a template fields later....

Akiko Takano は書きました:

Hello.

First of all, i am very pleased for your invested work in your concepts. Would be glad to have someone in my developer team

I think this is related to #995 and its tracker is not the defect but feature. Is this right?

Yeah, thats right.
I think the differene is that a query to get templates from other system could have more than just one key attribute.

By the way, do you have already some other system or knowledge base system that you hope to apply these data as template?

We have two deployments scenarios. First is opentrs which does have a soap web service to access ticket data. Yout find its soasp wsdl here: https://gitorious.org/otrs_cvs/otrs_cvs/blobs/d3d40956d413643d48d0dcbf8c4bdede60102408/development/webservices/GenericTicketConnector.wsdl

Second - no, at the moment the table is a csv list which is edited manually. There is no 2 tier application at the moment. But we plan to make crud app (maybe rails or adobe lifecycle) which will store that data in a database in near future. That we will at least be able to query a table on same server as redmine db we will create by extracting template master data from other system by sql query and cron job .

I like ur idea correspdondinng to your #995 drafts, that template key entry query not only return unique names also a description field which is shown on mouse over event.
At the moment our design is not as far to say if we really have the need of filtering the initial issue template selection list by another attribute than the key name itself.

I paralell to this templating feature we proof to have a custom field of type list which shall be populated also from others system data also via a sql (on local db extraction or table mirror) or life web service request. This approach does choose linking instead of "copying" data.

In any case if this lists have more than 30 entries (we expect this), scrolling search is not acceptable. Then at least a a combo box search by typing feature (substring match)is needed to filter the list of the fly (ajax needed)