topic Re: Object Report With Conditionals in Community Forum

Object Report With Conditionals

TCTech — Mon, 23 Jan 2023 15:30:43 GMT

I am attempting to create a conditional response within an object report based upon the following syntax:

~([Students.U_Students_Extension]HLS_NT_YN;if.fieldvalue.Yes.then=~([Students.U_Students_Extension]HLS_NT_YS))

I would like the report to render the value of [Students.U_Students_Extension]HLS_NT_YS when the value of

[Students.U_Students_Extension]HLS_NT_YN evaluates to "Yes", and render nothing (blank) when the value of [Students.U_Students_Extension]HLS_NT_YN evaluates to "No".

(Please note: similar but different field names ,"YN" vs. "YS")

Is this possible?

Also, what is the difference between the conditional statements:

^(field;if.fieldvalue.XX.then=result)

and]

^(field;if.fieldvalue#XX.then=result)

Re: Object Report With Conditionals

TCTech — Mon, 23 Jan 2023 15:44:32 GMT

It should also be noted that the statement above currently renders "No" when the value of [Students.U_Students_Extension]HLS_NT_YN evaluates to "No", and

nothing (blank) when the value of [Students.U_Students_Extension]HLS_NT_YN evaluates to "Yes".

Re: Object Report With Conditionals

wilhelzm — Mon, 23 Jan 2023 17:12:41 GMT

I'd like to do something similar.

What I would like to do is have the object report check the PSCORE_LEGAL_FIRST_NAME and PSCORE_LEGAL_LAST_NAME fields. If those fields return blank, then I would like the report to use the First_Name and Last_Name fields instead.

Re: Object Report With Conditionals

mbuonato — Wed, 15 May 2024 16:32:11 GMT

Try this. Basically if the legal first name is blank it will use the first name

^(decode;^(StudentCoreFields.PSCORE_LEGAL_FIRST_NAME);;^(first_name);^(StudentCoreFields.PSCORE_LEGAL_FIRST_NAME))

Re: Object Report With Conditionals

jbloom1 — Wed, 17 Jul 2024 19:14:20 GMT

I am working on something similar to this. Were you able to get this working?

Re: Object Report With Conditionals

jbloom1 — Thu, 18 Jul 2024 11:31:51 GMT

I actually got mine working. This document helped me get the right conditions set up. How-To: PowerSchool SIS - IF THEN and DECODE - PowerSchool Community

I had one field that was populated from a form with 2 possible answers. This is what I ended up with:

^([Students.U_Students_extension]CA_Q1;if.fieldvalue.N.then=X;if.fieldvalue.Y.then= )

If CA_Q1 value is N it would populate an X (to act as a checkbox on a printed form) if the value was Y it would show up blank.

I am thinking with yours you will need to have another IF letting it know what to do when the answer is YN so something like this:

^([Students.U_Students_Extension]HLS_NT_YN;if.fieldvalue.Yes.then=^([Students.U_Students_Extension]HLS_NT_YS);if.fieldvalue.No.then= )

I am not sure if you need to replace the ^ with ~ like in your conditionals before but I needed to have ^ to work for me.

^(field;if.fieldvalue.XX.then=result) ---- The fieldvalue equals a variable (XX)

^(field;if.fieldvalue#XX.then=result) ---- The fieldvalue does not equal a variable (XX)