Jump to content

Search the Community

Showing results for tags 'top'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


  • 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


Last Updated

  • Start


Filter by number of...


  • Start




Website URL






Found 1 result

  1. Hi, I'm have a calculated field that gets values from a View by the earliest date. It puts together a string (for html view) with 3 fields (date, project, and title) of the record so it can be displayed in an html block. It looks like this: CONVERT(VARCHAR(40),(SELECT TOP 1 DueDate FROM _V_Client_Portal_Calendar_Notify Where PortalID='[@authfield:PortalID]' ORDER BY DueDate ASC)) + '<br />' + (SELECT TOP 1 Project_Name FROM _V_Client_Portal_Calendar_Notify Where PortalID='[@authfield:PortalID]' ORDER BY DueDate ASC) + '<br /><i>' + (SELECT TOP 1 Title FROM _V_Client_Portal_Calendar_Notify Where PortalID='[@authfield:PortalID]' ORDER BY DueDate ASC) The issue is I need to then have another calculated field that gets the 2nd 'top' record, and another for the 3rd and 4th. How do you change this calculation to pull the 2nd record instead of the first? The result is I what to be able to pull the next 4 events in a calendar table, one in each calculated field, so they can be displayed as notifications.
  • Create New...