Create posted_date index for Tally integration DB

Description

Add posted_date index to the light microfinance database (table = financial_trxn). Its just a speed thing not to worry if small amount of data. Worse case it should be added to 1.7 schema. (JPW can handle this once decide to do on 1.6 or 1.7).

Environment

None

Activity

Show:
Kay Chau
September 15, 2010, 8:28 PM

Put in backlog, we will figure out later which release

km Krishnan
February 9, 2012, 5:35 AM

John,

Please can you update or close? This comes up under 'Accounting & Cash Management', and i am trying to work through all these issues and put the ones that don't need any more work to rest

johnwoodlock
February 12, 2012, 11:05 PM

If there is any accounting extract functionality using table financial_trxn... and it extracts based on posted_date... then this index should be added. I don't know of any right now. This issue was raised in response to a Tally Extract that was done but I don't think it is used.

johnwoodlock
February 12, 2012, 11:06 PM

Probably best to take this off the radar

Assignee

johnwoodlock

Reporter

Kay Chau

Labels

None

Implementation Priority

None

URL

None

Story Points

None

Team

Core

Scheduled For

None

Epic

None

productboard URL

None

Man Day Estimate

None

Fix versions

Priority

Trivial
Configure