Education & Training
Services & Support
to create and rate content, and to follow, bookmark, and share content with other members.
Query for Ideas
Question asked by
on Feb 19, 2010
on Feb 20, 2010 by senthi
Show 0 Likes
I'm looking for a query on IDEAS that will allow me to get started on some graph portlets. Looking for main fields like ID, Owner, Target Manager, status, etc. Does anyone have one built that they'd be willing to share? Thanks.
No one else has this question
Mark as assumed answered
This content has been marked as final.
Show 1 comment
(Required, will not be published)
Feb 20, 2010 4:11 AM
Hi, You can add the cloumn whatever your wishes based on the below query.. SELECT * FROM INV_INVESTMENTS INV , INV_IDEAS IDEA , ODF_CA_INV ODF , ODF_OBJECT_INSTANCE_MAPPING OBJ , FIN_FINANCIALS FIN , ODF_CA_FINANCIALS ODF_FIN , ODF_CA_IDEA ODF_IDEA , CMN_INSTANCE_PAGES CMN WHERE INV . ODF_OBJECT_CODE = 'idea' AND INV . CODE = 'test_idea' AND INV .ID = IDEA .ID AND INV .ID = ODF .ID AND INV .ID = OBJ . PRIMARY_OBJECT_INSTANCE_ID AND OBJ . SECONDARY_OBJECT_INSTANCE_ID = FIN .ID AND FIN .ID = ODF_FIN .ID AND IDEA .ID = ODF_IDEA .ID AND INV .ID = CMN . OBJECT_INSTANCE_ID SELECT PMA . * FROM PMA_FINANCIAL_VALUES PMA , INV_INVESTMENTS INV WHERE INV . ODF_OBJECT_CODE = 'idea' AND INV . CODE = 'test_idea' AND INV .ID = PMA . OBJECT_ID AND PMA . FINANCIAL_TYPE IN ( 'PLAN_CST' , 'PLAN_BEN' ) Thanks Senthil
Show 2 Likes
Retrieving data ...
How to create alarms with the unknown SNMP devices traps?
How to Submit Posts and Types of Content
How to convert .p12 to .pem for CEM
MicroGateway Creating MetaPolicy JSON file