Alpha Video Training
Results 1 to 3 of 3

Thread: Data-binding with a LIKE or IN operator possible?

  1. #1
    Member
    Real Name
    Edgar Solorio
    Join Date
    Nov 2012
    Posts
    65

    Default Data-binding with a LIKE or IN operator possible?

    Is there any way to use a LIKE or IN operators in data-bindings or link fields in an embedded object?

    something like
    SELECT Notes.*, Vehicles.*
    FROM Vehicles Vehicles
    INNER JOIN Notes Notes
    ON Vehicles.VIN LIKE (('%' + Notes.Vehicles) + '%')

    (The notes vehicle VIN section can list multiple VINs per note, and a VIN may have multiple notes)

  2. #2
    "Certified" Alphaholic
    Real Name
    Gregg Schmidt
    Join Date
    Mar 2001
    Location
    Milwaukee
    Posts
    1,257

    Default Re: Data-binding with a LIKE or IN operator possible?

    Hi Edgar,

    Try this. I shortened the aliases to make it more readable to me.
    You could also try eliminating the inner join and simply use where.
    Gregg
    Code:
    select n.*, v.*
    FROM Vehicles V
    INNER JOIN Notes N
    ON V.VIN LIKE concat('%' ,v.vehicle,'%')

  3. #3
    Member
    Real Name
    Edgar Solorio
    Join Date
    Nov 2012
    Posts
    65

    Default Re: Data-binding with a LIKE or IN operator possible?

    Thank you, what I wanted was something to be able to embed/link a grid onto a ux using something like that as a link (having it look for a singular vin contained in the note vins record (multiple vins in the field) )

    What I ended up doing was in SQL Sever setting a view using string_split to split the VINs and using a list on the UX, then a separate UX handle note details and or new note, ended up looking slightly nicer than what i planned to do originally.

Similar Threads

  1. inserting data into multiple tables(data binding)
    By amitloh in forum Mobile & Browser Applications
    Replies: 5
    Last Post: 07-03-2017, 01:19 PM
  2. List Control Data Source Filter using SQL IN operator
    By frankiez in forum Mobile & Browser Applications
    Replies: 4
    Last Post: 06-01-2017, 04:00 PM
  3. Need help with data binding and primary key in UX
    By Tbrondolo in forum Mobile & Browser Applications
    Replies: 12
    Last Post: 06-03-2014, 07:59 PM
  4. One to one data binding in a UX
    By bob9145 in forum Mobile & Browser Applications
    Replies: 2
    Last Post: 01-28-2014, 09:59 AM
  5. Data binding in Dialog2
    By Sparticuz in forum Application Server Version 11 - Web/Browser Applications
    Replies: 1
    Last Post: 10-25-2011, 01:26 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •