Hello,

Can we change the start command of a standard session when opened through a customized session with filter (query.extend.where.in.zoom() & zoom.to$())

Standard session has start command 44 (get the saved settings)

After filtration when opened need to use group navigation buttons.

Thanks & Regards
Biswajyoti Panda

Hi,

Can you specify the exact requirement? Are you calling the standard session from zoom field?

One way is to copy the standard session into your VRC and make the changes to start command or duplicate the standard session with new start command.

If you have to add single field filter, and you are calling the standard session from the zoom field, then you can code it in before.zoom section of that field.

e.g. Say, session tcibd0501m000 is zoomed from item.f form field and the zoom should show only the items with Item Group "XYZ"

field.item.f:
before.zoom:
tcibd001.citg = "XYZ"

function extern pay()
{
string namm
message("pay")

message("tdcom106.cnam=%s",tdcom106.cnam)
selection.filter:
query.extend.where.in.zoom("tdcom107.ocnam =:tdcom106.cnam")
start.session(MODELESS,"tdcom1507m000","tdcom1506m000","")
}


it open the session,but no values are there.empty table is there,how can i solve this problem.

You need to use the value in the query.extend.where.in.zoom. The zoom session does not know that variable.

query.extend.where.in.zoom("tdcom107.ocnam = " & quoted.string(tdcom106.cnam))

,thank you sir,i had solved the problem sir, i have one more question.
1)how to filter the record in a zoomed session using
query.extend.select.in.zoom("tdcom105.stid")
query.extend.from.in.zoom("tdcom105")
query.extend.where.in.zoom("tdcom105.stid >2")


where condition alone work,it will not select a column which i give in select query
how to select particular column using select,from,where query in selection fillter,please provide a solution for me.....


advance thanks...

If tdcom105 is the main table of the zoom session, the

query.extend.where.in.zoom("tdcom105.stid >2")

is enough to filter.

it's ok ,but i have many coloumn from that i need to select only specific column using query.extend.select.in.zoom and also from.

query.extend.where.in.zoom will work, but i should need to use select query for selecting specific ccolumn .....i think you will understand better.

"extend" in general does not mean that you can remove columns :-).
Because it seems that your zoom session is a custom session, you can add the after.form.read section and make the fields invisible. You can do that conditionally based on the name of the parent session.