• Article Type: General
• Product: Aleph
• Product Version: 19.01

Description:
p_ret_01 doesn't let you search directly on fixed field values; only variable fields. How can we do this?

Resolution:
One way sites have enabled such searching has been to include the entire LDR, 008, etc., fixed field as a user-defined field in tab22 / z13u.
Then you can search on values in particular positions in the z13u using SQL.

The attached document, "How to use expand procedures to retrieve records with 'd' in position 5 of LDR field", describes another approach, which is to use expand_doc_type to generate a temporary TYP field which can be used by p_ret_01.

See also: KB 6543.


-------<<Added by Tania G on May 21, 2012>>-------------

To retrieve records where a fixed field is missing, set fix_doc_do_file_08 in RET entry in tab_expand, with a generic fix (COPY-SYSTEM-NUMBER) that copies the fixed field to a data field, and then search the data field in p-ret-01.
The setting in the generic fix will be, for example:

1 001 COPY-SYSTEM-NUMBER MIS ,L,a

In p-ret-01, search for Tag MIS From text =ZZ, To Text = ZZ.
--------------------------<</end>>--------------------------------

• Article last edited: 10/8/2013