Hi,

I'd like to make my Data Tables query (the "SQL query" setting) include reference to a parameter I pass in the URL so I can navigate from a master list of data to the detail list. I figure I would use something like this in the SQL query but it doesn't work;

SELECT * FROM detailtable where foreignkey=$_GET['id']

Can I do this? If so, how?

Bill

Hello,

Use the following query:



Regards,
ARI Soft

Thank you. Your answers always work first time!

On the calling screen I have a data table. I want one of the fields to link to the detail table on the second screen, so in the SQL for the calling screen I have this:

SELECT '/index.php/items?keyfield='+[keyvalue] as keyfield
,...other fields...
FROM [mastertable]
order by keyfield

In the "Columns settings" section I set "Recognize Links" to "Yes" for this field. It renders a URL but the hovering over the URL gives me:

index.php/items?keyfield=KEYVALUE1

which isn't a valid link in itself. If I could add a "/" at the front it would be. Also I'd like to just display KEYVALUE1 in this field, but it displays a link which includes KEYVALUE1.

What is the right way to set up a clickable link in this field?

Bill

Hello,

You can use "Columns settings" parameters section to apply custom formatting for particular columns. For example if you want to format "keyvalue" field, populate "Columns settings -> ID" parameter with keyvalue value and populate "Columns settings -> Format" with the following value:



Regards,
ARI Soft

Almost there...

It seems {$value} is not available inside the Format field. Removing all the anchor-related HTML, no variant of {$value} is injected into the HTML.

{$value} injects an empty string
${value} injects the string "${value}"

I checked my SQL. It works in MSSQL studio. It works as a query in Excel. It just doesn't display the {$value} field if that's in the Format field.

Ideas?

Bill

Is it possible to see the problem anywhere? Probably you can setup a test env and provide a temporary access to your J! backend by email so we can investigate the problem in more details?

Regards,
ARI Soft