Announcement

Collapse
No announcement yet.

Want grid search to use ID field instead of Lookup value

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Want grid search to use ID field instead of Lookup value

    I have a table displayed in a grid and using Advanced Search (ScriptCase 8.1). The table being looked up has an ID field and then a corresponding string field for description via LookUp so the user can choose based on the description. But I'd like the search to use the ID field even though the user sees the description. Is there a way to accomplish this? Thank you.

  • #2
    In your lookup add the id in the concat. So by typing the idnumber you will see the ID + description

    HTML Code:
    SELECT Id, sc_concat(Id,':', Name, '.', Firstname)

    Comment


    • #3
      Thank you! I have some special code for search with a foreign language and it causes trouble.

      Comment


      • #4
        so does it work? if not share the code

        Comment

        Working...
        X