https://antibiotiqueaugmentin.com/surdosage-augmentin-bebe/
× Welcome to the ToolsJX forum!


How to show table with search filter from other ta

  • eddiex666
  • eddiex666's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
5 years 6 months ago #3467

Hi,

In the old Grid it was possible to create a "advanced search criterie" with selections/filters from other tables...

example: I create a table view from virtuemart(VM) . orders and show:
order number
order price

then i would like so show all orders with a spesific product.
where database.virtuemart.products = 1234


How can this be done in the latest table JX?

And yes i am trying understand - how-to-create-a-database-view-and-use-it-with-tools-jx



Eddie

Last edit: 5 years 6 months ago by eddiex666. Reason: Still dont understand :-)

Please Log in or Create an account to join the conversation.

  • eddiex666
  • eddiex666's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
5 years 6 months ago #3468

So my table names is....
k1sg2_virtuemart_products and k1sg2_virtuemart_orders

there is 1 common coloms in the tables... - virtuemart_vendor_id

I would like to create a view witch shows both tables and all tables...
so I can select and filter in table JX view...

I tryed some queries but it failed.. so any help will be nice

tnx, Eddie

Last edit: 5 years 6 months ago by eddiex666.

Please Log in or Create an account to join the conversation.

More
5 years 6 months ago #3471

Hi,

there is still the 'Additional condition' option in the Advanced section of the Table JX configuration form.

Please Log in or Create an account to join the conversation.

Moderators: tomaz
Time to create page: 0.385 seconds

Contact Us

Contact us on Facebook