Jump to content

Search the Community

Showing results for tags 'view'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Forums

  • Caspio Bridge
    • Caspio Apps for Ukraine
    • General Questions
    • Caspio JavaScript Solutions
    • Tables, Views and Relationships
    • Import/Export and DataHub
    • DataPages
    • Deployment
    • Security, Authentications, Roles, SAML
    • Styles and Localizations
    • Parameters
    • API and Integration
    • Calculations and aggregations
    • User JavaScript and CSS Discussions

Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


MSN


Website URL


ICQ


Yahoo


Skype


Location


Interests

Found 17 results

  1. Hi, I need to perform a cross join between two tables and I'm looking for any possible way or workaround. Context: I have one user table and one opportunity table, I want to do a cross join between the two tables so I can get one table that contains every user and opportunity pair, then create a calculated column to define a "compatibility score" for each pair. I know this will be a large table and cross joins are generally ill-advised, but I believe this is a valid use case for one. Brainstorming: Cross joins are not an option when creating a view, but not sure if there is some workaround for this? From research it doesn't look like there are any ODBC connectors that could be used by some sort of SQL query tool to query the tables with a cross join and then load the data back into Caspio. It would probably be possible to use the API to pull data out then use another tool to perform the cross join and load the data back in, but this seems a bit clunky and inefficient. Don't know if I've missed anything obvious but any ideas, suggestions, or feedback would be great! Thank you!
  2. Thought this might help anyone struggling as I did to create a View of only IDs (1) not duplicated between two tables or (2) duplicated between two tables but a second field is a certain value. I have two tables: 1. Table A - has a list of every available ID 2. Table B - contains IDs of inserted records (can have same ID on multiple records) I did a full outer join on the two tables in a View based on the ID First criteria only show IDs that are in Table A but not in Table B I then only want to include IDs if the record is in Table A and Table B, but a second field has a value of "Yes". However, Table B can have multiple records with the same ID with the second field with values of "Yes" or "No". The Not Equal filter wouldn't work because you can't NOT at the AND level. To solve this I added a sub-AND filter with two lines stipulating what I wanted the field to be and what I wanted it not to be.
  3. I am trying to conditionally show/hide HTML elements based what type of user is logged in. I’m not too familiar with how Caspio sessions are handled and how they relate to my HTML pages. I also have very little Javascript experience. There should be three levels of access, Admin, Manager, and User. I currently have an authentication table that has three users and three yes/no fields (admin/manager/user), each user is a different type. My first idea was to use cookie data. On successfully logging into my authentication form it would make a cookie for user type which would have a value of admin, manager, or user. Then I could use that cookie to add the display:none style to certain elements that I don’t want lower access users viewing. My problem is that I’m not sure how to do that with Javascript, or if that is the best practice. I currently have an HTML Datapage linked to my Authentication. On that page is this code: var type_admin = '[@authfield:admin]'; var type_manager = '[@authfield:manager'; var type_user = '[@authfield:user]'; if (type_admin == "Yes") { document.cookie="type=admin"; } else if (type_manager == “Yesâ€) { document.cookie="type=manager"; } else if (type_user == “Yesâ€) { document.cookie="type=user"; } Then I assume I would just reference the cookie on my HTML pages somewhat like this: <div class="adminContent"> Show this content if the user is Admin </div> <div class=â€managerContentâ€> Show this content if the user id Manager </div> <div class=â€userContentâ€> Otherwise show this content </div> Here are the HTML/PHP files I’m working with: http://domco.us/vita/test/ And here is the login page that’s just an embedded Datapage: http://domco.us/vita/page_login.php In the end I would like to be able to filter things like navigation buttons or div blocks. It would be great to have an Admin Tools link in the navigation that only Admins/Managers could see. I’m not sure the specifics of getting something like this to work. Also I don’t know how to keep that @authfield data throughout different HTML pages (not linked to Caspio) and I’m just assuming Cookies are the best option. Any help would be greatly appreciated.
  4. If I have a view with a million records because I have joined 3 tables, will it take up storage?
  5. my one authentication is built from a view based on a user_ table. when i build a report from that view, all fields present their expected values, that is, they show the values that are in the user_ table. however, when i build an HTML page and select authentication fields for embed (using the 'insert parameter' feature), not all fields present their expected values. for instance: [@authfield: user__first_name] prints out the user's first name on the HTML page and [@authfield: user__last_name] prints out the user's last name on the HTML page and even [@authfield: user__display_name] (which is a function that concatenates the first and last name) prints out the user's first name on the HTML page HOWEVER [@authfield: user__original_user_id] displays nothing even though it has a text field value of IAQM6XBX in the user table (upon which the authentication view is built, and, again, which prints out just fine in a tabular report built from that view) AND [@authfield: user__has_a_pool] displays nothing even though the text field has a value of 'Y' in the user table, and even though it prints out just fine in the tabular report built from the view. the only theory i have for why this might be is that the fields that are displaying nothing did not exist when the table was first created; they were later added. that is, i suspect that some caspio features don't update after initial creation (such as authentication view fields). i have created new views based on the updated table, but that hasn't helped. the only thing i haven't tested is creating a whole new table, which i am loathe to do. a perhaps related issue is that i have noted that when i change / add fields in tables - and ensure that those changes are duly reflected in the views that they participate in - datapage lookups for those views still do not reflect the changes in the table fields. in other words, if i were to change 'field ABC' to 'field XYZ' in a table, i can confirm that the change is reflected in view. however, when i select that view as a lookup table for a datapage's dropdown field, i will still see 'field ABC' and not see 'field XYZ'. that is, it is as if the original blueprint of the table/view is preserved. so, any thoughts? thanks for reading this far.
  6. i have changed / added / renamed fields in some tables. i have checked the views which use those tables, and have ensured that the changes are reflected in the view (e.g. ensured that 'include all fields' is checked). however, whenever i use a VIEW for a datapage, the 'datasource' fields that are available for record-level security or for lookup tables in dropdown elements show only the old fields and the old field names. the only way to see the correct fields is to use the table as the datasource, but of course that shouldn't be the case. all this is to say, it seems that dropdowns in datapages for lookup tables and record -level security are using cached versions of the original view/table. a screenshot is tough to pull off, but perhaps this example will help: current table fields: field ABC (originally named field AB) field XYZ (not originally in table or view) current view fields (match table, as expected): field ABC field XYZ fields available for dropdowns and record-level security in datapages (does not match table; unexpected behavior): field AB (not field ABC, and not field XYZ)
  7. Hello; Do views and tables have different performance characteristics? Or, is their only purpose to provide multi-table data sets? Consider these two scenarios: tbl_1 -> fld_1 | fld_2 | fld_3 | fld_4 | fld_5 | fld_6 frm_1 -> tbl_1.fld_3 | tbl_1.fld_5 Will the following View save me data usage or speed up the call? (or do anything else) view_1 -> tbl_1.fld_3 | tbl_1.fld_5 ---------------------------------------------------------------------------- frm_2 - tbl_1.fld_1 | tbl_1.fld_2 | tbl_1.fld_3 | tbl_1.fld_4 | tbl_1.fld_5 | tbl_1.fld_6 Will the following View slow down the call? (or do anything else) view_2 - tbl_1.fld_1 | tbl_1.fld_2 | tbl_1.fld_3 | tbl_1.fld_4 | tbl_1.fld_5 | tbl_1.fld_6 THANKS
  8. I want to create a view that will give me unique values for an activity with an entity, while the table stores activity, entity and sometimes multiple contact persons per entity. I want a chart and a report that shows the number of activities with each entity (and do not want those entities with multiple contact persons to count / shown multiple times). Is there a way to create so-called Group By views, or is there a way to structure a report in such way that The multiple contacts are not shown?
  9. Does anyone know if its possible in JS to dynamically change the filters applying to a Table or View that's linked to a datapage? I have several checkboxes for Users to select from, and the selections can drastically alter the types of filters I want to apply. Essentially I'm looking for much greater control over the results table than the Caspio wizard screen filters can allow. Thanks
  10. I have a View based on about 6 related tables. One of these tables has about 60,000 records that span the last 20 years, which is by far the largest table. I really only need the last 5 years of data from this table for Caspio purposes, so I'm wondering if it might be worth it to archive any data in that table that's older as a means of improving performance. That said-- unless there's a huge performance boost, my preference would be to create a View that filters out all years from prior what I need.
  11. I've found an issue doing a left-outer self-join. I can't get any criteria to work for what should be a simple left join; does anyone have any ideas? One table, relevant columns are:CID (Number) - ID number to join with other tables (other tables not relevant in this instance, relationship has not been defined in Caspio)VID (Text[255]) - Name of the Vendor usedEndDate (Date/Time) - Date that the relationship with the Vendor endedLet's have 3 people:John Doe - CID 1Billy Bob - CID 2Fat Joe - CID 3Table Enteries are as follows:1, HR, *null*1, Surefire, *null*1, Vantage, *null*2, HR, 01/01/20162, Surefire, 01/01/20163, HR, *null*3, Vantage, *null*Table should join to itself (left outer) with the CID as the relationship join. What I want to see is anyone with a *null* value for the HR end date and their corresponding Surefire information. View should populate as:1, HR, *null*, 1, Surefire, *null*3, HR, *null*, *null*, *null*, *null*I can't get the criteria right to do this. When I restrict the criteria for the self-join to only join if the right table VID entry is "Surefire" it restricts all the results by that field. The view I end up with is:1, HR, *null*, 1, Surefire *null*
  12. I've created a View that utilizes several tables. When I update the design of a Table, I'm not seeing that change reflected in my View. Is this normal behavior, or perhaps I'm overlooking something? As a work-around, I can delete the view, and create another, using the same tables (which by this point have the mentioned Design change already in place), and everything just works. I'd love to find quicker way to go about this though.
  13. Hi, I'd like to share a performance tweak I discovered this morning. Filter your data at the Data Page, not the View. In a View, I filtered out values based on the criteria of time-stamped values from the last 30-days. The Data Page that used this view took ~9 seconds to load. I switched to Filtering a DataPage, and now it loads in <1 second. Think Easy CHAD
  14. Good morning, i need some help with some views, I have 3 tabels I need a view whit: all horses (tabel2) (tabel3 empty) all conections horses (tabel2) (tabel3) tabel1 name:users field: user_id(key) tabel2 name:horse field: horse_id (key) field: user_id Tabel3 name:conections field:conection_id(key) field:horse_id field:user_horseowner_id (user_id) field:user_linked_id (user_id)
  15. Hello Caspio Gurus! I have an action log, and in this action log I have three Foreign Key user fields - Assigned, Creator, Completer. (all three which point at tblUser) How might I go about displaying all these users in one report? I tried creating views (qryUserAssigned, qryUserCreator, & qryUserCompleter) and using those views in a view, but I can only use tables when creating a view. Any help will be greatly appreciated. CHAD
  16. Hello; I am trying to create a view in which I would like to use multiple criteria on one field to filter the data. i.e. RecordID <> 101, 109, 117, 131, 140 When I attempt to do this Caspio tells me "Invalid value - Value Must Be A Number" Is there a workaround for this? Thanks!
  17. I have a view With the relationship between tables. The values from a parent table are displayed With values from the related Field (configured i Relationship settings). When I create Search and Report With such a view I want to see values from the related table instead of Ids (from parent table). Also I eant to be able to insert and update such records in Report.
×
×
  • Create New...