Search the Community
Showing results for tags 'select'.
Found 4 results
Hi, I have a Details Datapage where i would like to use a SELECT statements to pull data another table into a Virtual Calculated Field. It goes well so far as pulling the count across all Company_ID's, but when I add RLS to the statement values turn 0 even though the formula is verified. - Both, Booking_Status & Assign_To are in the table Bookings - Assign_To is a text field (255) that match the [@authfield:Company_Users_tbl_Company_ID] I have tried various combinations and expression like: 1. SELECT COUNT(DISTINCT Booking_Status) AS Pending FROM Bookings WHERE Assign_To = '[@authfield:Company_Users_tbl_Company_ID]' 2. SELECT COUNT(Booking_Status) from Bookings WHERE Booking_Status='Pending' AND Assign_To = '[@authfield:Company_Users_tbl_Company_ID]' Though, the formulas are both verified but not working as they return 0, i think perhaps that the table field Assign_To needs to have a FROM Bookings reference, this i have tried as well without luck. I would appreciate very much if anyone have suggestions to a correct statements. Sincerely Ras
Hi, all. So, I need to make the calendar date selection tool available to my form's users, but I don't want them to select a date that is less than two weeks in the future. In other words, if today is Sept. 10, the earliest date they should be able to enter/select is Sept. 24. Ideas? Thanks much!
I Have tried to get support but they are not responding to my ticket and I have been struggling with this very simple task for a report. I need to create a calculated field that counts the number of fields with data in a column by district - do not count NULL fields. In normal SQL, you can use a count function which does not include NULL fields but this counts everything for some reason. Not sure what I am doing wrong but here is the statement which should pull the count of fields with data but instead counts all the fields by distrcit.. ANY help would be appreciated... select count(Dropping_Unit) FROM CH_tbl_Base WHERE District=[@field:DistrictName] THANKS
I'm using the below select statement in a calculated field, the resultset works great in the html grid when I fire the datapage, but when I export the datapage the columns are blank. I am able to get results if I change the values from 'true' and 'false' to 1 and 0. Has anyone run into this? We would like the text value of either 'true/false' or 'yes/no' Thanks, -John select case when sum(b.CCO_Place_Points) > [@field:State_Points_Required_Required_Points] then 'True' else 'False' end from JRRESULTSTABLENEW a join Lookup_Places_2 b on b.CCO_Place_ID = a.CCO_PlaceID where a.MemberID = [@field:JRCOOKSLISTING_MemberID]