Reference Field value getting removed

[kailashthiyagar]

I m working on a custom Application and currently in Fuji Release..

I have a main form(appln) which has reference to multiple tables ,,, one of the reference field is macro team.. and we had data in the main table(macro)

As part of data maintenance, we happened to reload all the data in macro team. As a result of this, the main table which had reference to Macro team is wiped off.. Dont know why it happens

Also , i m running a filter in my table with the reference field.. If the sysid returned by my script include is not present, then it takes the condition as empty... and displays entire records...

[kailashthiyagar]

Thanks lchicoine

As far as returning result from the script include and then displaying the filter as "empty", what we can do?

[LaurentChicoine]

Hi,

Could you please give me a more global picture of what you are trying to do because actually, other then telling you why your fields were set empty, I have difficulty to understand what you want.

[kailashthiyagar]

lchicoine

Lets say, I have a employer table which has "First Name", "Last Name" and "Company(Reference)"

And i have company table with "Name" field alone..

Go to Employer table

In the filter choose, Company and give "XYZ".. Lets say the company XYZ is not in ur list of companies.. In this case,   the filter will automatically turn to "Company=Empty" and display records accordingly rather than making the filter to appear as "Company=XYZ"

In my scenario, i m using "List" block as part of CMS site and in that the filter criteria company will come from a script include, i m supposed to display list of logged in users' company employee records.. Since the filter is turning to empty condition, it displays incorrect information.

[LaurentChicoine]

First, if you plan on using v_user_session, this won't give you the right information as it only shows users logged in the current node the user is in (typically an instance has 2 nodes).

For the filter, inside your CMS you could use a custom block to build the filter as the default "Go to" filter is not working very well in general. However on my side when I try a similar use case, I'm getting Company.Name >= XYZ. So I'm not sure if we are talking about the same filter.