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
    • 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 16 results

  1. If I have a view with a million records because I have joined 3 tables, will it take up storage?
  2. 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__disp
  3. 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 dropdown
  4. 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 work
  5. 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.fl
  6. 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?
  7. 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
  8. 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.
  9. 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,
  10. 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.
  11. 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
  12. 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)
  13. 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
  14. 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!
  15. 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
  16. 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...