kinamu reported help please.

[chris.marsden]

I am trying to run a report on an accounts module which will show me some random selected information (custom fields) - i want it to report current user only... why will it not output any information???

sql shown before... i dont get the rskfdzgdpac.id referances... are these correct???

SELECT COUNT(sugarRecordId) as totalCount from (SELECT rskfdzgdpac.id as sugarRecordId from accounts as rskfdzgdpac LEFT JOIN accounts_cstm as esjxsjjrkwr ON rskfdzgdpac.id = esjxsjjrkwr.id_c WHERE rskfdzgdpac.deleted = '0' AND (((rskfdzgdpac.created_by = 'admin'))) ) as origCountSQL

[christianknoll]

Seems you have not selected any fields.

christian.

I am trying to run a report on an accounts module which will show me some random selected information (custom fields) - i want it to report current user only... why will it not output any information???

sql shown before... i dont get the rskfdzgdpac.id referances... are these correct???

SELECT COUNT(sugarRecordId) as totalCount from (SELECT rskfdzgdpac.id as sugarRecordId from accounts as rskfdzgdpac LEFT JOIN accounts_cstm as esjxsjjrkwr ON rskfdzgdpac.id = esjxsjjrkwr.id_c WHERE rskfdzgdpac.deleted = '0' AND (((rskfdzgdpac.created_by = 'admin'))) ) as origCountSQL

[citapinc]

I am trying to run a report on an accounts module which will show me some random selected information (custom fields) - i want it to report current user only... why will it not output any information???

sql shown before... i dont get the rskfdzgdpac.id referances... are these correct???

SELECT COUNT(sugarRecordId) as totalCount from (SELECT rskfdzgdpac.id as sugarRecordId from accounts as rskfdzgdpac LEFT JOIN accounts_cstm as esjxsjjrkwr ON rskfdzgdpac.id = esjxsjjrkwr.id_c WHERE rskfdzgdpac.deleted = '0' AND (((rskfdzgdpac.created_by = 'admin'))) ) as origCountSQL

It might be your count() function. Just for tests, replace the count() function with just * and see if any records get selected.

Next, try building your SQL statement in pieces adding a piece each time until it breaks.