https://antibiotiqueaugmentin.com/surdosage-augmentin-bebe/
× This is the optional Forum header for the Suggestion Box.

vertical instead of horizontal display of search

  • pngrover
  • pngrover's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
12 years 7 months ago #1249

hi

i just installed tablejx and can't believe how easy it was to get started.

my issue is that i have a large number of columns for each row- too many to fit on one line, and i would like the data to be shown vertically instead of horizontally after the search. only one record would be shown for each search, and i don't need all records shown before doing a search.

is there a way to do this with your product?

thanks

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

More
12 years 7 months ago #1268

Hi,

I am afraid that this is not possible. I suggest that you show less columns, because usually not all columns are necessary.

Regards,
Tomaž

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

More
12 years 6 months ago #1338

I have a simular request:

Is it possible to show with an extra script only one row of a table using variables?

Like that in an article:

First php request which row is needed f.e. with ID

Description1: {column5}
Description2: {column7}
Description2: {column8}
Description2: {column10}

The component works great but I need this additional feature and I thought when the connection to the external database is still available...

I would also be interested to an commercial support.

Thanks
K.

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

More
12 years 6 months ago #1339

Hi,

I suggest that you consider using Card View JX. Displaying just one card will do similar as you described.

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

More
12 years 6 months ago #1340

If I can define in the settings of each card, which Record / ID it has to show?!
Because I want to display only one row with selected columns (like in tables) in one article...

But this means hundreds of grids... :S

I´m not sure if I understand the selection field in settings: 'Additional Condition'
In another thread you wrote: option to filter records depending on a category ... (Joomla category or external database category?)

The best way for me would be:

Define Grid as Card
Cards per row = 1
number of rows = 1
Select wishes Columns
Choose additional condition where: Column in external database f.e. the ID

article:
{insertgrid ID = 2; record = 17} -> (17 = ID entry in the table)

next article:
{insertgrid ID = 2; record = 18}

another article:
{insertgrid ID = 3; record = 17} -> (17 = ID entry in another table defined in a new grid)

Is that possible?
Thanks a lot
Klaus

Last edit: 12 years 6 months ago by lichtbruecke.

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

More
12 years 6 months ago #1344

You would use 'Additial Condition'. In the box you would put something like:

my_id_column_name = 6
This would display the record with id=6.
Joomla content category.
It is not possible to do it as you described. But you can do it the other way around. You can add another column to your database with article id's.
Than you use 'Additional Condition' with:
my_article_column=@article_id
This will display just the records that include id of the current article in the 'my_article_column'.

However this feature has experienced some problems due to the bug in Joomla. It can be fixed by applying a patch that you find here:

joomlacode.org/gf/project/joomla/tracker...racker_item_id=24340

This problem was already discussed on this forum:

toolsjx.com/support/2-installation/1265-...17-and-clauses-where

'Additional Condition' syntax follows the SQL where statement syntax. You can learn more about it here:
www.w3schools.com/sql/sql_where.asp
www.tutorialspoint.com/mysql/mysql-where-clause.htm

Regards,
Tomaž

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

Moderators: tomaz
Time to create page: 0.165 seconds

Contact Us

Contact us on Discord

Contact us on Facebook