Jump to content

Search the Community

Showing results for tags 'multirecord'.

  • 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 1 result

  1. Hello, I'm trying to figure out how to filer records with a text field that contains comma delimited values. The problem is the search doesn't actually recognize 'delimited' in a field and so 'contains' will bring up records that I need to filter out. For example, if a record's text field has a value of 1,2,3,4,12,22 the user might do a search/filter; "‘contains 2” (it can’t do = 2 because the actual value of the field is “1,2,3,4,12,22” and “2” won’t be equal to it). But the ‘contains’ function will bring up records with not only ‘2’ in them but also ’12’ and ’22’ etc. I tried using "" in the search box so "2" would bring up records with just 2 and not 12 or 22, etc, but this doesn't work either. Does anyone know how to deal with this? I can't use List for data type as these records are imported and you can't import to List fields. The value 1,2,3,4,12,22 denotes a multi-record, meaning that record is related to 6 different records in another table. Thanks for any help!
×
×
  • Create New...