Book a Demo

Author Topic: Search: Query Builder  (Read 4757 times)

vladap

  • EA User
  • **
  • Posts: 79
  • Karma: +0/-0
    • View Profile
Search: Query Builder
« on: April 14, 2020, 07:15:52 pm »
Hi All,

I am using Query Builder for some advance searches and it works well if I write a precise select for the looking term.

My question is how to use the search bar in this case "<Search Term>" -  It doesn´t matter what I write to the search Term the result with SQL Query is always the same.

Example:
result of the SQL Query are two columns like this and I would like to use search bar to select for example only the lines with "D" result

A---B
A---B
A---C
A---C
A---D


Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13523
  • Karma: +574/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: Search: Query Builder
« Reply #1 on: April 14, 2020, 07:28:21 pm »
You write something like

Code: [Select]
where t_object.Name like '<Search Term>'
EA will replace the '<Search Term>' with whatever you fill in in the search field.

Geert

vladap

  • EA User
  • **
  • Posts: 79
  • Karma: +0/-0
    • View Profile
Re: Search: Query Builder
« Reply #2 on: April 14, 2020, 11:20:15 pm »
it works, thanks

vladap

  • EA User
  • **
  • Posts: 79
  • Karma: +0/-0
    • View Profile
Re: Search: Query Builder
« Reply #3 on: April 14, 2020, 11:36:57 pm »
it works, thanks

is there a way how to share this Query between all users?

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +397/-301
  • I'm no guru at all
    • View Profile
Re: Search: Query Builder
« Reply #4 on: April 14, 2020, 11:41:11 pm »
Look into %appdata%\Sparx Systems\EA\Search Data and share that.

q.

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13523
  • Karma: +574/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: Search: Query Builder
« Reply #5 on: April 14, 2020, 11:44:42 pm »
is there a way how to share this Query between all users?
You can share queries with individual users using the query import/export feature.
If you want to share it with all users you can include it in an MDG. I have some MDG technologies that exist only to share searches.

Geert


Paolo F Cantoni

  • EA Guru
  • *****
  • Posts: 8626
  • Karma: +259/-129
  • Inconsistently correct systems DON'T EXIST!
    • View Profile
Re: Search: Query Builder
« Reply #6 on: April 15, 2020, 08:27:46 am »
is there a way how to share this Query between all users?
You can share queries with individual users using the query import/export feature.
If you want to share it with all users you can include it in an MDG. I have some MDG technologies that exist only to share searches.

Geert
(my emphasis) We've done the same!

Paolo
Inconsistently correct systems DON'T EXIST!
... Therefore, aim for consistency; in the expectation of achieving correctness....
-Semantica-
Helsinki Principle Rules!

Eve

  • EA Administrator
  • EA Guru
  • *****
  • Posts: 8110
  • Karma: +119/-20
    • View Profile
Re: Search: Query Builder
« Reply #7 on: April 15, 2020, 09:20:54 am »
We do the same for internal searches that we don't think will help the wider world.