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


Table JX - get param from URL

  • Sagi74
  • Sagi74's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
9 years 2 months ago #2628

Hello,
I use Table JX. I would like use them with parameters from URL address to be used in a select formula in a where part.

For exampla: www.abc.com?param=123
-->
SQL: select * from table where param=123

How to make it? Is it possible to reuse this values?

Thanks, regards

Roman

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

More
9 years 2 months ago #2629

Hi,

Unfortunately this is not supported yet. What you can do is to to force search parameters trough url. You can do it as it is described in the following topics.

toolsjx.com/support/3-suggestions/1389-l...ield-to-1-table#1405
toolsjx.com/support/3-suggestions/1208-s...imitstart=0&start=12

I hope this was of some help.

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

More
9 years 2 months ago #2664

Hi Tomaz,

I'm trying to follow the advice in those links myself to create a URL with a pre-set search string.

Can you see anything wrong with this link syntax.... it doesn't seem to filter the table at all....

http://www.mysite.com/results?s_f=event&data_search=CARE

Last edit: 9 years 1 month ago by andybon.

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

More
9 years 1 month ago #2667

Hi,

If you are using advanced filters, the syntax is a bit different:

http://www.yoursite.com/yourpage?data_search=column1|value1|column2|value2

Got it?

Last edit: 9 years 1 month ago by tomaz.
The following user(s) said Thank You: andybon

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

More
9 years 1 month ago #2668

Perfect. I got it. Thanks!!!!

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

More
9 years 1 month ago #2669

One issue with this I just found... If the results from the URL are paginated, then if you try to go on to page 2, it looks like it forgets what it filtered and returns to the full data set.

Does that make sense.... and if so, do you see any possible solution for that?

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

Moderators: tomaz
Time to create page: 0.160 seconds

Contact Us

Contact us on Facebook