Jump to content

Search the Community

Showing results for tags 'top'.

  • 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 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...