Dear All,

I have requirement to skip few records in customized maintain session ( Std table tisfc001) based on one condition.

I have tried skip.io in following but unsuccessful :mad:
- main.table.io
- after.form.read
- before.display.object
- field.level
:
Is there any other command other than skip which acts like lattr.print = false
in reports.

Thanks in Advance,
Sathish

Hi,

If DAL exits on the table the main.table.io subsections except read.view are ignored. So, it's better to use query extensions.

Hi ,


Thanks for reply.

I have particular scenario that particular field having value=empty that is not displayed.
where should i write query extension.



Thanks in advance,
Sathish

Hi,

What kind of session is it?

If its just a display session. You can use query extension in before.program section.


Code:
query.extend.select("tcibd001.*")
query.extend.from("tcibd001")
query.extend.where("tcibd001.kitm = tckitm.service")

I have the same problem, the table has an active DAL but I can't set up a query extensión since the condition for skipping are the three first letters of a field.

For example, the table is tccom903.

The evaluation field is tccom903.cpar which will have something like "CFP99999999" or "CVG888888888" or "PSE777777777". But I just want to be displayed the records starting with CVG or CFP... how can I do it?

Hi,

You can try this:-

form.all:
init.form:
cpar.f = "CFP"
cpar.t = "CVG"
query.extend.select("tccom903.*")
query.extend.from("tccom903")
query.extend.where("tccom903.cpar(1;3) inrange {:cpar.f} and {:cpar.t}")
rebuild.query()

If your session is just a display session then you can disable DAL in before.program section using disable.dal() and then use skip.io() in main.table.io -> after.read section.

Hi,

Just a caution, if you use disable.dal(), it will ignore all the field checks and integrity checks which can lead to bad data. Make sure you are updating table with proper data.