KenWi

@JolliBeng Did the ability to authenticate based on groups ever get added? Please Advise, Ken

Is there any update on this? I haven't been able to develop a method to use groups in a directory to control access to specific datapages. It would be ideal to be able to add/remove users from groups to control datapage access. From what I have experienced, Directory logins offer all or nothing access.

Just a tack on, to have this format properly it needs to use a 1, 2 at the end of the STUFF function to remove the additional space. But the isolation of the return type is what did it.

Thank you again, that worked perfectly and I would have never have thought that I needed to isolate the field using ()s.

The XML returned is effectively the same as if the query was. Select DISTINCT Preceptor_Name_FullName from _v_M3_Placement_View where (Preceptor_Join_Placement_IsPrimary = 0) The Placement_Placement_ID = '[@field:Placement_Placement_ID] and Placement_WeekNumber = '[@field:Placement_WeekNumber] seem to be being ignored, or evaluating against every possible value for the fields. Removing FOR XML PATH ('') will result in the table displaying the proper number of Rows, but every row is individual and contains the first element of the expected result set.

That seems to be getting me closer, as it will stuff a big block of XML in the cell. However using the SQL Select DISTINCT Preceptor_Name_FullName from _v_M3_Placement_View where ((Placement_Placement_ID = '[@field:Placement_Placement_ID]' AND Preceptor_Join_Placement_IsPrimary = 0 AND Placement_WeekNumber = '[@field:Placement_WeekNumber]') ) causes an issue as soon as I add FOR XML PATH (''), because at that point the system seems to lose any concept of [@field:Placement_Placement_ID]. Any experience on how to keep the variables I need to reference for the query? Possibly defining some intermediate variables?

Is there any way to have a calculated field in a data page display multiple return values from a select? I have this But where that query should return 5 items it is only displaying the first one, Can I concatenate and iterate in some fashion? I was expecting the entire result set to appear.

Thanks for the Attempt, the view will still display only 1 Person_Name 😕 (Tried this previously.)

Hello Caspio users, I seem to have an issue with Data Views and Many to Many relationships. In the example of Teachers, Students and Classes I want to be able to list multiple entries of the many to many relationship in a single data page cell. So if I make a view that lists all students by class, and the class has multiple teachers, I want the teachers Concatenated in a cell rather than listing a number of records for teacher A and a number of records for Teacher B. Given Tables Student Student_ID Student Name Teacher Teacher_ID Teacher Name Class Class_ID Teacher_ID Student_ID How would I tell the data page to create a line with All of the teachers, then list by student? Hopefully this makes sense. Please Advise, Ken

Unfortunately it does not. My issue is not with creating the view, but in having the view join the same table in two separate ways. I know how to do this trivially in SQL, however I can't seem to find a way to make Caspio do it. It seems that my solution is to just de-normalize the data.

Dear Caspio Users, I am attempting to do something which while I believe is a smiple join, Caspio doesn't seem to want to return any records on As an Example, given the following 4 tables Person (Contains a field NAME) Student Teacher Class All of these tables join on unique IDs so given the following joins Teacher <-> Person Student <-> Person Class <-> Teacher Class <-> Student Is there a way to get Names to display for Teachers and Students in a Caspio View? (Hopefully someone has encountered this and has found an easier way to work with it) Thank you, Ken

Follow Up: that works perfectly.

@CoopperBackpack thank you for the speedy reply. I'll see about implementing this method. Out of curiosity, I have seen a lot of the Caspio videos using space(1), is there a reason to use that over ' ' ? (New to Caspio) Thanks again, Ken

As a First time Caspio user I'm sure there is a way to do this but I have been encountering some difficulties. I have created this solution a number of times directly using AJAX and a Databse, but there are some tiny things that seem to be holding me back in Caspio. I am hoping someone can assist me. The situation is fairly simple. 3 tables, two of which are data and one of which institutes a many to many join between the two So I have Person (Table) Person_ID (Unique) (ID) FirstName (Text255) LastName (Text255) FullName (Formula FirstName + ' ' + LastName) Employer (Table) Employer_ID (Unique) (ID) Employer Name Person_Join_Employer Person_ID (Text255) Employer_ID (Text255) Creating a DataPage I start with Person_Join_Employer and I am able to create dropdowns from Person and Employer using the FullName field for Person for the display and the Person_ID from Person for the Value and doing the same with Employer, Dropdown using EmployerName and Employer_ID for the name and value respectively. Select both, press a button and the record gets added.. Now I want to change the dropdowns to Autocompletes and everything goes of the rails. FullName is no longer an acceptable value, and I'm not able to pair a value with the selection. Can anyone help? I'd prefer not to have to perform one selection then pass the ID to another DataPage to make the second one, but I will try that if I have to. Please Help, Ken