Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Printing a blank line??

636453Jul 11 2008 — edited Mar 1 2012
Hello!! :)

I have a table called employees, it has the following column:

JOBTITLE
-----------------
Accountant
Accountant
Accountant
Accountant
Clerk
Clerk
Salesman
Salesman
Salesman
Salesman
Salesman

What i would like to do is print a blank like between the differents groups, i.e:

Accountant
Accountant
Accountant
Accountant

Clerk
Clerk

Salesman
Salesman
Salesman
Salesman
Salesman
*************************

Any ideas anyone??

Thanks

Comments

Cvele_new_account

try to set Disabled property for that fourth SOC, to be false _only if first three SOC attributes are set to non-null values...

OR, make 4.th SOC ;disabled property to be false only if 3.-th SOC value are set, then the same for 3. SOC (depends on 2. SOC), then the same for 2. SOC, etc... got a point?

Jose Aróstegui

Excellent idea!

Can you help me please a bit to build the expression?

I don't know how to reference the fields as they are inside a Query Panel based on a View Critera.


BR

Ashish Awasthi

This 4th Lov is dependent on all 3 lovs?

If you are using view cirteria then uncheck "Ignore Null Values" Check box in criteria to not show any data in case of no value is selected in other 3 lovs

Ashish

Jose Aróstegui

Thanks a lot for your help Ashish.

This 4th Lov is dependent on all 3 lovs?

2nd Lov depends on 1st

3rd Lov depends on 2nd

4th Lov depends on 3rd

If you are using view cirteria then uncheck "Ignore Null Values" Check box in ...

Ignore null values is not editable:

screen3.png

I've tried your solution Igonre null values in viewCriteria -Jdeveloper 12c (Not a bug but a change) – Ashish Awasthi's Blog (Jdev/ADF) but It didn't activate the checkbox either.

Regards,

Jose.

Ashish Awasthi
Answer

Hi Jose

It'll not activate checkbox , you just need to add GenerateIsNullClauseForBindVars="false" under viecriteriItem tag like this and then check

<ViewCriteriaItem

    Name="DepartmentId"

    ViewAttribute="DepartmentId"

    Operator="="

    Conjunction="AND"

    Value=":BindDeptId"

    IsBindVarValue="true"

    Required="Optional"

    **GenerateIsNullClauseForBindVars="false"**/>

After this 4th lov will not show any data untill 3rd one is selected

SnapShot.jpg

Ashish

Marked as Answer by Jose Aróstegui · Sep 27 2020
Jose Aróstegui

It works fine. I was confused and was setting the value to true:

screen4.png

Thanks a lot!

1 person found this helpful
Ashish Awasthi

Jose that post was not about this problem , It was about chnaging it's value only

Anyway you solved it  

1 - 7
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 29 2012
Added on Jul 11 2008
14 comments
12,891 views