lookup values in assignment or validation

[Former Member]

Hi All,

I just want to know how we can use lookup values in assignemnt or validation.

Like i have category lookup field and it ahs values christams,lycero etc..

IF(IS_NULL(Category[Christmas]),"true","false")

if i am executing these assignment on the record which hav category christmas then also i am getting value false.

I just want to know how we can use this lookup values.

Thanks,

Sudhanshu

[Former Member]

Hi Sudhanshu,

For working with lookups, you can use the function "Has any values" and choose the field and value from the toolbar "Lookups".

one small example would be

HAS_ANY_VALUES(Countries[Australia],true)

The above validation will check if the lookup field Country has the value "Australia" .

Regards

Edited by: Sudheendra P on Dec 8, 2009 11:32 AM

[Former Member]

Hello Sudhanshu

Assignments

Assignment save value into Field

You can use assignment for save data to field in LUT, partually QLUT, main tables

in assignment condition you can use values from main table fields, LUT fields, attributes for selected category(only when you use Branch) resul of conditions will save selected field

for xample:

you have

Main table:Main

Text Field in main table: what now

Categories: holidays,workdays

text Attribute "celebrations": X-mas, New Year, cemetery day

1)Create simple assignment

2)set table to: Main

3)set assignment field to : what now

4)in assignment expression: select function->Branch(Categories)

5) save assignment with name "what now?":

6) select assignment "what now?" and right click

7) in menu select" Add Branch"

😎 in "Branch value select category (holidays)

9)open assignment expression: select attribute "Celebrations"

10)save

11)create new record in main table

12) set category to holidays, set attribute "what now?" to "X-mas" an save

13) run assignment and get in "what now" field in main table value "X-mas"

modify assignment

14) select "Branch" assignment open assignment expression

15) select from Function IF-function

16) enter net expression: if( what now? ="X-mas","Happy X-mas"," Happy holiday") and save it

17) run assignment

18) in "what now: fields of main tabled get "Happy X-mas"

You can use attribute values from current record in expression but you canot assign value to attribute only to field which selected in assignment field propertie

Regards

Kanstantsin

Edited by: Kanstantsin Chernichenka on Dec 8, 2009 12:03 PM