[imp] coding sample required for parameterised filters in master file

Focal Point

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/8417046816

April 05, 2012, 02:14 AM

kumud.vaish

[imp] coding sample required for parameterised filters in master file

Hi ALL,

I want to know if we can use variables in the master file join condition and filter coding

e.g JOIN_WHERE table1_pkey EQ table2_fkey and criteria_field EQ --any user defined variable--

Please guide me for creation of user defined parameterised variables in master files and using them

Any suggestion would be a great help.

-Regards
-Kumud Vaish

This message has been edited. Last edited by: kumud.vaish,

version-773
platform-windows
All Outputs

Scott

April 11, 2012, 06:34 AM

kumud.vaish

I am trying the same but when the master file get called in InfoAssist, I get no prompt for the value in variable

-regards
-Kumud Vaish

version-773
platform-windows
All Outputs

April 11, 2012, 02:41 PM

j.gross

Read The WebFocus Manual.

Note that

1. You can declare a default value. ("Syntax: How to Create a Master File Variable")

2. There are restrictions on where in the syntax of Master and Access files a declared variable may be referenced. ("Reference: Support for Variables in Master and Access File Attributes")

April 12, 2012, 01:24 AM

kumud.vaish

Thanks buddy...

I was going through the developer studio online help and found a note there mentioning that "Parameters are not supported with the master file filters".

So I assume that master file filters can work with a predefined static value.

-Regards
-Kumud Vaish

version-773
platform-windows
All Outputs