10-22-2011 08:28 PM
I have a simple SQL view that I made into a Mainview in SLX.
Everything goes OK so far. When I create a group in the groupbuilder and include some fields in the group the data shows up but no matter what I do I can't seem to make any column hyperlink to the Entity Details page.
If I manually type the URL into the address bar, the details page comes up fine - like this:
I checked the "entity Linked" check box on all the columns but none work.
Any ideas what to look for?
The SQL view is simple:
Create VIEW [sysdba].[CFXSpotTrades2]
SELECT ROWTYPE as RowType,
Cast(TRANID as Varchar(12)) as CFXSpotTrades2ID,
TRANDATE as TranDate,
Cast(TRANCODE as Varchar(4)) as TranCode,
cast(STATUS as Varchar(1)) as TranStatus
WHERE (ROWTYPE = 1)
10-24-2011 08:51 AM
10-24-2011 12:17 PM
A - Use the facility DB manager to convert it properly (RMB)....
B - Make sure the unique keyfield (for the view) is defined in RESYNCTABLEDEFS - it might note be.. there's been a "bug" lurking here ;-)