Search the Community
Showing results for tags 'sql query'.
Found 2 results
I am trying to get the count from a table and applying record level security, but in the where clause, when I am comparing it with my auth field, it is saying "Invalid Query" For instance, my query: ISNULL((SELECT COUNT(DISTINCT [@field:PropertyKeyId]) FROM UI_FactTrxn_1 WHERE [@field:InvestorUserId] = [@authfield:Users_UserId]),0) I am getting Invalid error for this. But when I am trying to pass the string in place of authfield, it is a valid one! Can anyone please help me on this?
I'm looking to display the the record count for a tbale in the header of a chart datapage and I'm not sure how to accomplish this. I have a table called tblEventRegistration and I would like show the query results of: 'SELECT Count(tblEventRegistration.ERID) AS TotalReg FROM tblEventRegistration;' . I was told that I could be done with a java script but I'm not sure how to access the data. Any help would be greatly appreciated.