Ticket #1612 (new enhancement)

Opened 13 months ago

A Visible Formula attribute in Queries

Reported by: humdinger Owned by: stippi
Priority: normal Milestone: R1
Component: User Interface Version: R1 development
Cc: Blocked By:
Platform: All Blocking:

Description

This is r22860 in vmware.

There is tip262 "Show formula query strings in Tracker" on the Tipserver (which has been down at http://www.betips.net for some time now...). I think it'll be nice to have that out of the box. Here's the tip, originally from Chris Herborth:

Supergeeks who use formula queries frequently might like to be able to edit their formulas directly from the Tracker, rather than having to edit the queries first.

To do this, you need to take the hidden attribute that stores the formula and make it visible. That hidden attribute is called _trk/qrystr. Open the FileTypes preferences panel and scroll to application/Be Query. In Extra Attributes, click Add. Give the new attribute the name "formula" (without the quotes) and the Internal name _trk/qrystr. Make it of the type String, and select the Editable and Visible checkboxes. Give it a default display width of 200, click Done, close FileTypes, and close then re-open any Tracker windows displaying queries. You should now have a Query sub-type in the Tracker's Attributes menu from which you can select "formula."

Note: See TracTickets for help on using tickets.