Report and iFrame method problem

[admin]

Thanks.

[Janusz]

@mariorog
the main issue is how to transfer record ID to the report placed inside the iframe.
If no other possibility you can use temporary table where you store user by user current ID of the main from (or other data).
Just create table ex. raport2 with 2 fields rap_user and rec_id
you can set the value with PHP Before Edit:

Code: Select all

$q="UPDATE raport2 set rec_id='#RECORD_ID#' WHERE rap_user = '#USER_ID#';";
$t  = nuRunQuery($q);

and for WHERE in the raport in SQL use:

Code: Select all

...
WHERE con_part=(select rec_id from raport2 where rap_user='#USER_ID#')

For initial test insert manually the user IDs (to be able to use update from mysql)
the table can look like this

Przechwytywanie.JPG

but for final solution you need to define more automatic solution

[kev1n]

@Janusz: This seems like a good/easy to implement workaround. And hopefully there will be a fix soon. Let's keep our fingers crossed.

[admin]

Hello people,

This should now be fixed.

Please test it.


Steven

[kev1n]

@Steven: The change works for me!

@mariorog:

You can simply change the line

Code: Select all

last.hash 			= nuHashFromEditForm();

with this one

Code: Select all

last.hash 			= parent.nuHashFromEditForm();

in the file nuajax.js, Line 170
https://github.com/steven-copley/nubuil ... ax.js#L170

[mariorog]

@Steven: The change works for me!

@mariorog:

You can simply change the line

Code: Select all

last.hash 			= nuHashFromEditForm();

with this one

Code: Select all

last.hash 			= parent.nuHashFromEditForm();

in the file nuajax.js, Line 170
https://github.com/steven-copley/nubuil ... ax.js#L170

Dear Kev1n and Steven,
the change works for me too !!!!!

Thanks A LOT for your time.
All the best.

[admin]

No worries.

Steven