Sign in
XDataCondition
XDataCondition - Indices of Sage 50 data for a given condition
Description
This function is only available for Sage 50 Canadian edition
This function returns the indices corresponding to the requested criteria.
Parameters
Table
Database table from which the data will come.
Condition
Condition to evaluate.
Dataset [Optional]
Custom dataset to use.
Connections [Optional]
Sage 50 Connection to query. If left empty, the default connection will be utilized.
Examples
It is strongly recommended to utilize an Excel cell address (ex. A1:B19) containing the information of the parameters requested in all Logicim XLGL functions, such as names or codes. This practice adds flexibility to your worksheet and will ensure the coherence of your results. Moreover, the use of quotation marks (") is essential when the parameters are manually written in the arguments function window.
Returns the indices from table tCustomr for column sName with values starting with A
=XDataCondition("tCustomr", "sName Like 'A*'")
Edited: Tuesday, November 05, 2024
Was this article helpful?
Thank you! Your feedback matters.
You can Contact us so we can address your question.
