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
10 years 9 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
10 years 9 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
10 years 8 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: 10 years 8 months ago by andybon.

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

More
10 years 8 months 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: 10 years 8 months ago by tomaz.
The following user(s) said Thank You: andybon

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

More
10 years 8 months ago #2668

Perfect. I got it. Thanks!!!!

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

More
10 years 8 months 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.175 seconds

Contact Us

Contact us on Discord

Contact us on Facebook